Bank statements, supplier price lists, and published reports often arrive as PDFs, but you need the numbers in a spreadsheet to sort, total, or chart them. Retyping is slow and error-prone. Conversion can get you most of the way there, as long as you understand what a PDF actually contains and are ready to do a little tidying afterwards.
Why PDF Tables Are Tricky
A PDF does not store a table the way Excel does. It stores pieces of text and the exact position of each one on the page, plus lines that are drawn separately. What looks like a neat grid to you is, to software, a scatter of words at particular coordinates. Converters have to rebuild the rows and columns by looking at where text sits. That is why results vary so much between documents.
Two Kinds of PDF
- Text-based PDFs are created by exporting from software such as accounting systems, Word, or Excel. The text is real text you can select and copy. These convert well.
- Scanned PDFs are photographs of paper. There is no text inside, only an image, so they need optical character recognition (OCR) before any data can be extracted.
Quick test: open the PDF and try to highlight a single number with your cursor. If you can select it, the PDF is text-based.
How the ToolGhost PDF to Excel Tool Works
The PDF to Excel tool reads the text from each page of a text-based PDF, groups text that sits on the same line into a row, and places each separate piece of text into its own cell, from left to right. Each PDF page becomes its own sheet in the workbook. Everything happens in your browser, so financial documents are never uploaded.
This works well for simple tables where each value is a separate piece of text. Results need more tidying when:
- A cell contains text that wraps onto two lines, which becomes two rows.
- Columns are empty in some rows, which can shift later values one column to the left.
- A table spans several pages, since each page lands on a separate sheet.
- The PDF is scanned, in which case there is no text to extract.
Step-by-Step Clean-Up in Excel
1. Combine pages
If your table spans several pages, copy the rows from each sheet into one sheet, then delete repeated header rows that appeared at the top of each page.
2. Fix misaligned rows
Sort or filter by a column that should always contain a value, such as a date, to spot rows where values have shifted. Insert cells to push values back into the right columns.
3. Split combined values
If a cell contains several values separated by spaces, select the column and use Data → Text to Columns, choosing the delimiter that separates them.
4. Remove stray spaces
Extracted text often has extra spaces. In a helper column, use =TRIM(A2) and copy the results back as values.
5. Turn text into numbers
Numbers sometimes arrive as text, which stops SUM from working and shows a small green triangle in the cell. Use =VALUE(A2), or select the cells and choose "Convert to Number" from the warning menu. For amounts with thousands separators or currency symbols, remove those first with Find and Replace.
6. Fix dates
Dates can be misread depending on your regional settings, for example 03/04/2026 as 4 March instead of 3 April. Text to Columns lets you specify the date format (DMY or MDY) for a column during the split.
7. Check the totals
Compare a column total in Excel with the total printed in the original PDF. If they match, you can trust the conversion. If not, look for rows that were split or skipped.
Other Options Worth Knowing
- Excel's built-in PDF import: In Excel for Microsoft 365 on Windows, Data → Get Data → From File → From PDF can detect tables in text-based PDFs and load them through Power Query.
- Ask for the source data: Banks and suppliers can often provide CSV or Excel exports directly. This is always the most accurate route.
- OCR for scans: For scanned documents, run OCR first, for example by opening the PDF with Google Docs from Google Drive, then extract the text.
Keeping Financial Data Safe
Statements and invoices contain account numbers and personal details. Before using any online converter, check whether it uploads your file. Browser-based tools, like ToolGhost's PDF to Excel, keep the document on your device. Delete converted copies you no longer need, especially on shared computers.
Frequently Asked Questions
Why is my spreadsheet empty after converting?
The PDF is almost certainly scanned, so it contains an image rather than text. It needs OCR before the data can be extracted.
Why are my columns out of line?
Rows with empty cells or wrapped text shift values sideways. Use the clean-up steps above, starting with filtering by a column that should always contain data.
Can it keep the table formatting, like colours and borders?
No. Extraction captures the text and numbers, not the visual styling. Apply formatting in Excel afterwards.
Does it work with password-protected PDFs?
Unlock the PDF first with the password in a PDF reader, then convert the unlocked copy.