purchase order
Your purchase orders
become rows in a Google Sheet.
Upload or forward a purchase order 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 purchase order here
PDF, photo, scan, Word or PowerPoint — up to 200 pages
No account. No card. Your first sheet is free.
Example of what your sheet will look like
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | PO number | PO date | Customer | Ship to | Requested date | Line total |
| 2 | 4500218841 | 07/14/2026 | Northstar LLC | Aurora, IL | 07/28/2026 | 18,420.00 |
| 3 | PO-9921 | 07/15/2026 | Halden Foods | Memphis, TN | 08/04/2026 | 6,240.00 |
| 4 | 4500218902 | 07/16/2026 | Northstar LLC | Reno, NV | 08/01/2026 | 2,115.30 |
| 5 | TX-44117 | 07/18/2026 | Bridgeport Mfg | Houston, TX | 08/12/2026 | 44,900.00 |
This is an example. You decide which columns your own sheet has.
The columns
These are the columns we usually find on a purchase order. 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.
- PO numberstring
- PO datedate
- Customerstring
- Ship tostring
- Requested datedate
- Line totalnumber
- Buyerstring
- Termsstring
Questions people ask
- Do I get one row per PO or one per line item?
- One per line item when the PO has several, so quantities and part numbers stay usable. Say so before the sheet is created if you would rather have one row per PO with a single total.
- Every customer's PO looks different.
- None of them need setting up. There is no template to map per customer — a PO from a new account works the first time it arrives.
- 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 purchase orders?
- Each one becomes its own row. We show you the first rows we read before the sheet is created, so you can see we are reading it the way you would — and if a document should be split some other way, you say so in your own words and we follow it.
- Do photos from a phone work?
- Usually, yes — including stamped, stapled and hand-annotated copies. If a photo of a purchase order 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 purchase orders?
- No. We keep the extracted row, not the document. The file is discarded once your sheet is built.
- What if there is no attachment — just the email?
- We read the message itself: its text becomes the rows, with the quoted thread and signature stripped first. When a file is attached we read the message alongside it, so a reference typed in the email can still reach its column.
- How is this counted — what is a page?
- Pages are what your plan is measured in, and everything we read counts as pages: each page of a document, each photo or scan, and the text of the email it arrives in. A document that produces forty rows still costs its pages, not its rows.
- 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. Several attachments on one email is fine: each is read on its own and adds its own rows. You never have to open this site again.