Docly practical guide
How to Convert PDF to Excel Online
Retyping a table out of a PDF is slow and introduces errors. Converting it moves the text into cells so you can calculate with it. The output is never ready to use straight away, so plan a short clean-up and verification pass.
Convert a PDF table to a spreadsheet
Add your file to the PDF to Excel tool and start the conversion. Pages are analysed one at a time, so it takes longer than most tools and long documents need patience.
When the XLSX opens, check the row count first: does it match the number of records in the source? Then check whether the columns were separated correctly. If only a few pages contain tables, extracting those pages before converting shortens the job and produces a much cleaner result.
Bank statements and financial tables
Statements and accounting exports are the most common real use for this conversion. If the statement you downloaded from your bank has a text layer, each transaction can be moved into cells. Statements built from screenshots are images and need OCR first.
Verify four things afterwards: the number of transactions, whether the date column is recognised as dates rather than text, whether thousands separators and minus signs were read correctly in the amount column, and whether the total matches the closing balance on the statement. Before importing into accounting software, rearrange the headers into the order that software expects; most import failures are about column order, not formatting.
Scanned tables need OCR first
A document with no text layer has no cells to extract. Run PDF OCR on scanned or photographed tables first, then convert.
Character confusion is common after OCR: zero and capital O, one and lowercase l, five and S are the usual pairs. For tables of amounts, recalculating the total in Excel and comparing it with the total printed in the source is a far faster check than reading every cell.
Clean up the spreadsheet
Typical clean-up work includes deleting table headers that repeat on every page, splitting merged cells, removing blank rows and columns, and converting numbers that arrived as text. If numbers sit left-aligned in their cells, Excel is treating them as text and arithmetic will not work.
Long documents can spread content across several sheets, so check the sheet tabs when you open the file. Keeping an untouched copy of the raw conversion makes it easy to go back and confirm how a particular cell was read.
Quick checklist
- ✓Extract the pages that contain tables before converting.
- ✓Recalculate the total in Excel and compare it with the source.
- ✓Fix date and number formats one column at a time.
- ✓Use Office to PDF for the opposite direction.
Tools in this guide
Frequently asked questions
Do Excel formulas come across?
No. A PDF stores calculated values, not formulas, so you rebuild any formulas in Excel.
Why did numbers arrive as text?
Values containing thousands separators, currency symbols or spaces are often read as text. Convert the column to a number format to fix it.
Why can the conversion take a while?
Pages are processed individually, so processing time grows with the page count.