You get a bank statement, a price list or a report as a PDF. It has a lovely table. You need that table in a spreadsheet so you can sort it, add it up or chart it. So you select, copy, paste... and Excel gives you one long column where every cell is a jumbled mess of words and numbers. There's a better way, and it takes about a minute. This guide covers how to convert a PDF table to Excel or CSV, how to check the result so a misplaced digit doesn't ruin your totals, and what to do when the PDF just won't cooperate.
Why does copy-paste from a PDF go wrong?
A PDF isn't a spreadsheet with a nice coat of paint. It's closer to a printout: each word is placed at a fixed spot on the page. There are no real rows, columns or cells inside it, only text that looks like a table because of where it sits.
When you copy from it, your computer guesses where one cell ends and the next begins. Sometimes it guesses well. Often it doesn't, and you end up with merged columns, split numbers and rows in the wrong order.
That's why a converter that rebuilds the table structure is a much better starting point than pasting and cleaning up by hand.
How do you convert a PDF table to Excel?
The short version: upload the PDF, convert, open the result. Here are the steps with PDF to Excel:
Try it now: PDF to Excel
Free, quick, and nothing to install. Open PDF to Excel →
Most simple tables come through in one go. Wide tables with many columns and tables with merged header cells are where you will want to look more closely.
- Open the PDF to Excel tool in your browser; there's nothing to install.
- Add your PDF file.
- Run the conversion and download the spreadsheet.
- Open it in Excel (or any spreadsheet app) and check the result before you rely on it.
Can I trim the PDF first so I only convert what I need?
Yes, and it's worth doing. A 40-page report might have one useful table on page 17. Converting the whole thing means hunting through sheets of stuff you don't need.
Use Extract PDF Pages to pull out just the page (or pages) with your table, then convert that smaller file. You get a cleaner spreadsheet and less to check.
If the table is the only thing you want from a page that also has headers, notes and logos, Crop PDF can trim the page down first. It's a small step that sometimes spares you a lot of deleting later.
Excel or CSV: which should you pick?
Both give you rows and columns, but they suit different jobs.
Excel (.xlsx) is the friendly choice when you'll be working by hand: formulas, formatting, filters, charts.
CSV is plain text with commas between values. It's the one to choose when you're importing into another system, such as accounting software, a database or a mailing tool, because almost everything can read it. If that's your goal, try PDF to CSV.
A quick rule: if a human will look at it, go Excel. If another program will read it, go CSV.
One more reason to pick CSV: it has no formatting to get in the way. No merged cells, no colours, no hidden sheets. Just rows of values, which is often exactly what an import wants.
How do you check that the numbers survived?
Conversion tools can misread a table, especially one with merged cells, tiny print or an unusual layout. So spend two minutes checking before you build anything on top of it. Here's a short checklist:
- Compare the totals. Add up a column in the spreadsheet and compare it with the total printed in the PDF. If they match, you're probably in good shape.
- Count the rows. Does the spreadsheet have as many rows as the table?
- Scan for numbers stored as text. If a number is left-aligned or has a little green warning triangle, Excel doesn't see it as a number yet. Convert it before summing.
- Look at dates. Dates can flip between formats, so spot-check a few.
- Check the page breaks. Rows that span two pages sometimes get split or duplicated.
What if the table comes out in the wrong columns?
It happens. A few fixes that usually help:
Try the other output. If Excel gives you a tangle, run the same file through CSV, or the reverse. The two can lay things out differently.
If the data is more text than table, PDF to Text gives you the raw words, which you can paste into a spreadsheet and split into columns using Excel's Text to Columns feature.
And if the table is simple and short, honestly, retyping ten rows can be faster than fighting a messy layout. Know when to stop.
Another trick for stubborn tables: convert one page at a time. A long table that changes layout halfway down often converts better in smaller chunks, and Split PDF makes that easy.
Why won't a scanned PDF convert properly?
If your PDF is a photo or scan of a paper page, there's no real text inside it, just a picture of text. A table converter is looking for actual text in the file, so a scan is likely to give you an empty or useless result.
A quick test: open the PDF and try to select a word with your cursor. If you can highlight individual words, it has real text. If the whole page highlights as one block, it's an image.
For image-only pages, your best options are to ask whoever sent it for the original digital file, or to retype the table by hand.
A few habits that make this painless
Keep the original PDF next to your spreadsheet, so you can always check a figure against the source.
Name the output clearly, say invoices-march-converted.xlsx, so you don't mistake it for the original data.
And as a general rule, avoid uploading highly sensitive documents, such as full bank details or ID numbers, to any website. For routine price lists, schedules and reports, a quick conversion is exactly what these tools are for.
Frequently asked questions
How do I convert a PDF table to Excel for free?
Open the PDF to Excel tool on PDFbox.pro, add your PDF, convert it and download the spreadsheet. The tools on the site are free to use. Check the totals afterwards to make sure the numbers came through correctly.
Why does my PDF table paste into Excel as one column?
A PDF stores text at fixed positions on a page rather than as real rows and columns, so copying it gives your computer little to go on. Converting the file with a PDF to Excel or CSV tool is more reliable than pasting.
Can I convert a scanned PDF to Excel?
Usually not well. A scan is a picture of a page rather than real text, and table converters need real text to work with. Try selecting a word in the PDF: if you can't, it's a scan. Ask for the original digital file if you can.
Back to all posts