4 guides
Document parsing is the conversion of a PDF, scan or photo into structured spreadsheet data. These guides cover how, for bank statements, invoices, receipts and resumes.
Four ways to extract a table from a PDF — copy-paste, Excel Power Query, Tabula and Camelot, and automatic parsing — what each one actually does, where each breaks, and how to pick without trying all four.
Google Sheets cannot import a PDF — File → Import does not accept the format. Four ways around it: Google Docs conversion, converting to CSV/XLSX first, Workspace add-ons, and parsing straight into a sheet.
InvoicesWhat invoice data extraction is, why line items are the hard part, and how manual entry, template-based rules, schema-based AI and e-invoicing compare — plus the checks that catch a bad extraction before it reaches your ledger.
Bank statementsThree ways to convert a PDF bank statement to Excel — copy-paste, Excel Power Query, and automatic parsing — with the trade-offs of each and how to get a clean transaction table.
Each guide is written against one kind of paperwork. These are the document types ParseForMe parses — every page explains the fields it reads and what you can export them into.
The vocabulary these guides use, and what separates the methods they compare.
Document parsing is the process of reading a document — a PDF, a scan or a photo — and pulling its information out as structured fields rather than free text. A parsed bank statement becomes dated rows with amounts and balances; a parsed invoice becomes a supplier, a total, a tax figure and line items. The output is something a spreadsheet can hold.
OCR converts pixels into characters — it tells you a scan contains the text "Total 249.00". Parsing is the step after: deciding that 249.00 is the invoice total and belongs in a total column. OCR alone gives you a wall of text; parsing gives you fields. Documents that are already digital PDFs skip OCR entirely and go straight to parsing.
Copy-paste usually loses the table because PDFs store position, not structure, so everything lands in one column. Excel Power Query keeps the structure when the PDF is text-based and laid out consistently. Automatic parsing handles scans as well as digital PDFs and returns named columns. Our bank statement guide walks all three methods.
No. Each guide covers the manual and built-in options first — copy-paste, Excel Power Query, spreadsheet formulas — and says where each one stops working. ParseForMe appears as one method among them, with the same trade-offs stated. The methods are useful whether or not you ever create an account.
Every method in these guides ends at the same place: a clean spreadsheet. Upload a document and watch ParseForMe do it — the first 30 tokens are free, and no card is needed to try it.