What PDF to Excel does
Tables locked inside PDFs are frustrating. You can see the numbers, but you cannot sort, filter, sum or chart them. Retyping is slow and error-prone. Converting to a spreadsheet gets the data into a form you can work with.
PDFHook reads the text from each page and uses spacing between words to work out where columns begin and end. It then writes rows and columns into an Excel file. Because it works from the arrangement of text on the page, it performs best on clean, regular tables.
Good candidates for conversion
- Bank or card statements exported from systems as PDFs
- Price lists, product catalogues and inventory sheets
- Timetables, schedules and attendance lists
- Simple financial summaries and reports
- Data tables in reports where columns are clearly spaced
What makes a PDF convert well
- Digital, not scanned. The PDF should contain real text. If you can select individual words in your viewer, it is a good sign.
- Clear spacing between columns. Gaps are how the tool detects boundaries.
- One value per cell. Cells that wrap onto several lines or contain mixed content are harder to split.
- Consistent row layout. Regular rows convert better than free-form layouts.
- No heavy decoration. Plain tables beat tables with overlapping graphics.
What may not convert well
- Merged cells and multi-level headers. Spreadsheet structure like merged cells is not recreated.
- Formulas. A PDF contains the displayed values, not the formulas that produced them.
- Tables without clear column gaps. If columns are tightly packed, values may merge into one cell.
- Scanned tables. There is no text to read until you run OCR PDF, and recognition errors are possible in numbers.
- Complex page designs. Layouts with multiple tables, charts and text on one page may extract in a confusing order.
After conversion: a short clean-up routine
Even a good conversion benefits from a quick review:
- Check that column counts are consistent across rows
- Spot-check totals against the PDF to be sure no numbers were misread or shifted
- Fix any numbers stored as text so formulas work
- Remove header and footer lines repeated on each page
- Format dates and currencies as needed
Always compare a few key values with the original, especially if the data feeds into financial decisions.
Tips for better results
- Extract just the table pages using Split PDF if the PDF has lots of narrative.
- Rotate landscape tables the right way up with Rotate PDF first.
- Crop out headers and footers with Crop PDF so they do not appear in the data.
- Try PDF to Text if you want to inspect what the tool reads before converting.
Common mistakes
- Trusting numbers without checking. Always verify totals.
- Converting a scan directly. It will find no text.
- Expecting formulas. The result is values only.
- Not unlocking protected files. Use Unlock PDF if you know the password.
PDF to Excel vs copy and paste
Pasting a table from a viewer often puts everything in one column or loses alignment. A conversion tool that detects columns saves time on multi-page tables. For very small tables, copy-paste can still be quickest.
Privacy
Spreadsheets often contain sensitive information such as financial records and customer lists. The conversion in PDFHook runs in your browser, so the PDF and the Excel file are not uploaded. See how this differs from upload-based tools.
A worked example
A supplier sends a three-page PDF price list with columns for code, description, unit and price. Convert it, open the .xlsx and check that each row has the same number of columns. Delete repeated header rows from pages two and three, convert price cells from text to numbers, and spot-check ten prices against the PDF. Once clean, you can sort by price, filter by category or build a pivot table. For very long lists, extract only the table pages first.
Troubleshooting
If descriptions are split across several columns, merge them in Excel. If numbers are left-aligned, they are stored as text; convert them. If everything lands in one column, the PDF has too little spacing for detection, and a cleaner source file will do better.