MotionShine01 / Rows
Text on one line is one row
Every piece of text has a position in a PDF. Pieces on the same baseline become a row, in order from left to right.
Free tool
PDF to Excel, tables back into cells.
Drop a PDF with a table in it, like a bank statement, a price list or a report, and get a spreadsheet back. The page reads where every piece of text sits, puts each line in a row and finds the columns from the gaps that run down the page. Numbers become real numbers you can add up. Check the preview, then save an XLSX for Excel, Numbers or Google Sheets, or a CSV.
Works on PDFs made from a computer. A scanned page has no text to read: run it through OCR PDF first.
The PDF is read in your browser. Nothing is uploaded.
How it finds the table
Rows from lines, columns from gaps.
02 / Columns
The gaps decide
Where no row has any text across the whole page, a column ends. That keeps right-aligned amounts in their own column.
03 / Numbers
Ready to add up
1,234.50, -12, (300) and 45% become numbers in the sheet; codes like 007 stay as text.
Questions
Good to know.
Will the formatting come across?
The text and numbers do, in rows and columns. Colours, borders and fonts are not part of what a PDF says about a table, so they are left out.
Can it read a scanned PDF?
Not directly: a scan is a picture with no text in it. Make it searchable with OCR PDF first, then convert it here.
Does it work with Google Sheets and Numbers?
Yes. XLSX opens in Excel, Google Sheets, Numbers and LibreOffice; CSV opens anywhere.
Is my PDF uploaded?
No. It is read in your browser, which matters for bank statements and invoices.
A column came out split or merged. What now?
Try All pages in one sheet or the other way round, and fix the rest in your spreadsheet. Tables with merged headers sometimes need a quick tidy.