Amazon orders → Excel

Drop the label-and-invoice PDF from Seller Central and get a clean order sheet — one row per SKU, columns you pick.

Runs entirely in your browser. Your PDF is never uploaded — it works even in airplane mode. Free, no signup, any number of orders.

AdLeaderboard 728×90 — below the tool, never near the buttons

How it works

1

Download from Seller Central

Grab the label-and-invoice PDF for the Amazon orders you want in the sheet.

2

Drop it above

Every invoice line is read on your device — order no., SKU, qty, amounts, tax, place of supply.

3

Pick columns & download

Choose the columns you file with, then export Excel or CSV.

What the Amazon order sheet gives you

Read from the tax invoice, not from the label

An Amazon label PDF alternates between two kinds of page: a page carrying the shipping label, and one or more pages carrying that order's tax invoice. The order data lives on the invoice pages, and those pages are real text — order number, ASIN, HSN, unit price, tax rate, place of supply, your GSTIN. All of it can be read exactly, with no guessing.

The label page cannot. Amazon prints it as a single flattened image, so the AWB number and the delivery-station code exist only as pixels. That is why this sheet has no dispatch columns. We could run OCR over a barcode-dense label and produce something that looks like an AWB number, but a wrong AWB in a spreadsheet is worse than an absent one — so we leave it out and tell you why. (Flipkart's sheet does carry AWB and courier, because Flipkart's label keeps its text layer.)

One row per line item — not one row per order

An order with three products produces three rows, each with its own ASIN, HSN, tax rate and taxable value. That is the shape GST reconciliation needs. A single row per order would blend three tax rates into one meaningless average and hand the unpicking work back to you.

Long invoices that spill onto a continuation page are handled — the continuation rows stay attached to the order they belong to, not to whatever label happens to follow.

All 29 columns

The sheet opens with the core columns; tick Select all to widen it. Amazon's invoice is richer than Flipkart's in two respects — it carries the ASIN and the payment transaction ID, neither of which Flipkart prints.

Core

  • Order Date
  • Order Number
  • SKU
  • Qty
  • Net Amount
  • Tax Type
  • Tax Amount
  • Place of Supply

GST & invoice

  • Invoice No
  • Invoice Date
  • HSN
  • ASIN
  • Unit Price
  • Discount
  • Tax Rate
  • Total
  • Invoice Value
  • Payment Mode
  • Payment Txn ID
  • State Code
  • Seller
  • Seller GSTIN
  • Seller PAN
  • Product

Buyer

  • Buyer
  • Shipping Address
  • Pincode
  • Billing Name
  • Billing Address

Blank beats wrong. If Amazon changes its invoice layout and an amount doesn't parse cleanly, we leave the cell empty and warn you, naming the order. We never write a 0 or a 1 as a placeholder.

A spreadsheet that quietly under-reports your taxable value is far more dangerous than one with an obvious hole you can go and check against Seller Central. The gap is the honest answer; a fabricated zero is not.

Same PDF — crop the labels from it too

The Excel and the 4×6 labels come out of the same file. Use the Amazon label cropper to take both in one pass: print-ready 4×6 labels, the invoice pages kept intact as their own A4 PDF, and the sheet.

Nothing is uploaded

Amazon invoices carry your buyers' names, addresses and phone numbers, and your own GSTIN and PAN. None of it reaches us. The PDF is parsed inside your own browser tab — this is a static site with no application server, so there is nowhere on our side to send a file. Load the page, turn off your internet, and build the sheet anyway. It works, and that is the proof.

Other tools

Questions

How do I get my Amazon orders into Excel?+

Drop the label-and-invoice PDF you download from Amazon Seller Central. Every invoice line is read into a sheet you can download as Excel or CSV — no retyping.

Which columns do I get?+

You start with the basics — date, order no., SKU, qty, net, tax and place of supply — and can switch on GST, dispatch and buyer columns from the column picker. An order with several items becomes one row per SKU.

Are my files uploaded anywhere?+

No. The PDF is read inside your browser. Buyer names, addresses and phone numbers never reach our servers — the tool even works with your Wi-Fi off.

I also need the labels cropped.+

Use the Amazon → 4×6 labels tool — same PDF, cropped to print-ready thermal labels.

AdRectangle 300×250