PDF to Excel
Drop a PDF here or click to choose
Choose a PDF with real text. Scans will not become rows.
Pull text that is lined up in columns into a spreadsheet. Check the result. This is a spacing guess, not a model of the original table.
How to use
- Choose a PDF where you can already select the text.
- Click Build sheet. The box shows the first rows so you can see whether the columns split in a useful place.
- Download XLSX or CSV. CSV is UTF-8 with a byte-order mark so Excel is more likely to open accents correctly.
How columns are chosen
Words that sit close together stay in one cell. A wide gap, including the large space PDF readers insert between columns, starts a new cell. The same horizontal positions are lined up down the page. A title that spans the page sits in the left cell and leaves the other cells blank.
If every line becomes one cell, the file did not have a gap wide enough to call a column. That is reported in the status line. It is still a usable one-column sheet.
Pages are stacked in one worksheet. When the PDF has more than one page, a row reading Page N is inserted so you can see the break. There is no second sheet per page.
Questions
Why did two columns land in one cell?
The gap between them was small, similar to a normal word space. The tool would rather keep a sentence together than split every word. Widen the source, or split the cells in Excel.
Can it read a photo of a spreadsheet?
No. OCR is not part of this page. Use PDF to Text with English OCR, or type from PDF to JPG. A picture has no columns to measure.
Will formulas survive?
PDF tables are not spreadsheets. You get text, including numbers stored as text. There are no formulas to keep.