commercial invoice
Your commercial invoices
become rows in a Google Sheet.
Upload or forward a commercial invoice by email and its extracted data is added as a new row to a Google Sheet, within seconds. Drop one below and we will determine the column names and create the sheet.
Drop a commercial invoice here
PDF, photo, scan, Word or PowerPoint — up to 50 pages
No account. No card. Your first sheet is free.
What your sheet will look like
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Invoice number | Invoice date | Seller | Country of origin | HTS code | Line value | Incoterm |
| 2 | CI-2026-0412 | 07/14/2026 | Shenzhen Kaiyu Ltd | CN | 8482.10.5008 | 18,420.00 | FOB |
| 3 | CI-2026-0412 | 07/14/2026 | Shenzhen Kaiyu Ltd | CN | 4010.31.6000 | 6,240.00 | FOB |
| 4 | EX-99214 | 07/16/2026 | Fabrica Duarte SA | MX | 7318.15.8060 | 2,115.30 | DAP |
| 5 | CI-2026-0418 | 07/18/2026 | Kraus Werke GmbH | DE | 8536.50.9065 | 44,900.00 | CIF |
Four commercial invoices, four rows. Yours starts at row 2.
The columns
These are the columns we usually find on a commercial invoice. You can rename them, drop the ones you do not track, and add your own before the sheet is created. Anything you add to the right of our columns stays untouched — including formulas.
- Invoice numberstring
- Invoice datedate
- Sellerstring
- Buyerstring
- Country of originstring
- HTS codestring
- Descriptionstring
- Quantitynumber
- Line valuenumber
- Incotermstring
Questions people ask
- Does each line item become a row?
- Yes, because HTS classification and duty are per line. One row per invoice would hide exactly the detail a customs entry runs on.
- Can it read invoices from overseas suppliers?
- Layout and wording vary enormously and none of it needs configuring. Where a document is in another language the values still land in your English column headers.
- I work in Excel. Can I get the data out of Google Sheets?
- Yes, and it is Google's feature rather than ours: Google Sheets will download any sheet as .xlsx or .csv from its own File menu, and it opens in Excel from there. What we build and keep filling is the Google Sheet itself — we never produce an Excel file, so anything forwarded later adds a row to the sheet and not to a copy you have already taken off it.
- What if one scan holds several commercial invoices?
- Each one becomes its own row. We tell you how many we found before the sheet is created, and you can correct it in one click if we got it wrong.
- Do photos from a phone work?
- Usually, yes — including stamped, stapled and hand-annotated copies. If a photo of a commercial invoice is too blurry to read we say so rather than inventing a row.
- Who can see my Google Sheet?
- Only people you give the link to. The link is unguessable, anyone holding it can edit the sheet, and we never share it with anyone else.
- Do you keep my commercial invoices?
- No. We keep the extracted row, not the document. The file is discarded once your sheet is built.
- How does forwarding work?
- Your sheet gets its own address at in.tosheet.ai. Forward a document there — from your own mailbox, or straight from whoever sends them to you — and ToSheet.ai adds its row within seconds. You never have to open this site again.