Amazon guide · 5 min read
How to turn Amazon shipping label/invoice PDFs into an order Excel
Amazon gives you a PDF in which shipping labels and tax invoices alternate, page after page. Those invoice pages are full of the order data you need for your books and GST. This guide shows how to pull that data into a clean order Excel in seconds — free, and entirely inside your browser, so nothing gets uploaded.
Want the labels as well?
You can have both, from this same file. CropSheet crops Amazon's label pages to true 4×6 thermal labels and hands the tax invoices back as their own PDF — see the Amazon label crop guide. This guide stays on the data side: getting a spreadsheet you can reconcile and file.
What you'll need
- Your Amazon PDF that includes the tax invoice (the label + invoice document from Seller Central).
- The free CropSheet Amazon orders-to-Excel tool. No install, no signup.
- Excel, Google Sheets, or any accounting tool that opens .xlsx or .csv.
Step 1 — Download the label + invoice PDF from Amazon
In Amazon Seller Central, open Manage Orders and select the orders you're dispatching. Generate the shipping documents so you get the PDF that includes the tax invoice page (depending on your fulfilment method, this is the Easy Ship label sheet or the invoice you print for each order). Save the PDF to your device. You can include several orders in one file — CropSheet reads them all.
Step 2 — Open CropSheet and drop in the PDF
Head to the Amazon orders-to-Excel tool and drag the PDF onto the page. CropSheet reads it in your browser, detects that it's an Amazon document, and parses each invoice into rows — one row per invoice line item, so a two-item order gives you two rows. The processing is local: the file never leaves your computer, so customer names, addresses and phone numbers on those invoices stay private.
Step 3 — Choose your columns and export
Pick a preset for how much detail you want, then download as Excel (.xlsx) or CSV:
- Basic — order date, order number, SKU, quantity, net amount, tax type, tax amount and place of supply.
- GST — adds invoice number and date, HSN, ASIN, unit price, discount, tax rate, total, payment mode, buyer state code and seller GSTIN.
- Full — everything above, plus buyer name, shipping address and pincode.
That GST preset is the reason to bother: it lines up the fields — GSTIN, HSN, tax rate, place of supply and buyer state code — that make reconciliation and return-filing far less painful. The dispatch columns (AWB, courier, sort code) are Flipkart-only: those fields come off Flipkart's label, and Amazon's tax invoice doesn't print them.
Step 4 — Put the sheet to work
Open the exported file in Excel or Google Sheets. From here you can total your sales, match payments, hand it to your accountant, or import it into your bookkeeping or GST software. Since every field came straight from the invoice text, you skip the tedious, error-prone retyping of order numbers and amounts.
Tips and troubleshooting
- Missing a column? Some fields only appear when Amazon prints them on the invoice; switch to the Full preset to capture everything available.
- Big batch? One multi-order PDF becomes one spreadsheet — no need to export order by order.
- Need the labels too? The same PDF crops to 4×6 thermal labels — see the Amazon label crop guide.
- Also sell on Flipkart? Use the Flipkart guide to crop labels and get an Excel from the same file.
Frequently asked questions
- Can CropSheet crop Amazon shipping labels to 4×6 as well?
- Yes. The same PDF works in the Amazon label cropper, which crops every label page to a true 4×6 inch (288×432pt) thermal label. This guide covers the data side; if you want the labels, see the Amazon label crop guide.
- Is it free, and are my buyer details safe?
- Yes on both counts. Turning Amazon invoice PDFs into an order Excel is free and unlimited with no signup. The PDF is read entirely inside your browser and is never uploaded, so buyer names and addresses stay on your device.
- Which columns can I export for Amazon?
- Core fields include order date, order number, SKU, quantity, net amount, tax type, tax amount and place of supply. The GST preset adds invoice number and date, HSN, ASIN, unit price, discount, tax rate, total, payment mode, buyer state code and seller GSTIN. The full preset also adds buyer name, shipping address and pincode.
- Can I process many orders at once?
- Yes. Upload a multi-page invoice PDF and CropSheet reads every order into its own row, then exports the whole set as one Excel or CSV file.
- Excel or CSV — which should I pick?
- Choose Excel (.xlsx) if you'll open it in Excel or Google Sheets and work with it directly. Choose CSV if you're importing into accounting or GST software that expects a plain comma-separated file.
Turn your next Amazon invoice PDF into a spreadsheet.
Open the Amazon orders-to-Excel tool