How to Copy a Table From PDF to Excel (Free, Clean Results) | Tools4PDF

You open a PDF, see exactly the table you need, and then discover it will not behave. Select and paste, and every row lands in a single column. Numbers turn into text. Headings end up in the wrong place. For a short table that is annoying; for a long statement or price list it can eat an afternoon.

There are two reliable ways to solve it: convert the PDF into an Excel file, or copy and paste carefully and clean up in Excel. This guide covers both, shows how to fix the usual problems, and explains how Tools4PDF can prepare the file so the result is cleaner.

Quick answer

Open PDF to Excel, upload your PDF, convert it and download the XLSX file. Open it in Excel (or any spreadsheet app) and tidy the formatting. For a very small table, you can also select the table in a PDF reader and paste it straight into Excel.

Method 1: Convert the PDF to Excel (best for most tables)

This is the fastest route when the table is long, spans several pages or has many columns.

1. Go to the PDF to Excel tool.
2. Upload your PDF.
3. Start the conversion and download the XLSX file when it is ready.
4. Open the file in Excel, Google Sheets or LibreOffice Calc.
5. Check the result and fix any small formatting issues.

Tables and data are extracted into editable cells, so you can sort, filter and write formulas straight away instead of rebuilding the table by hand.

If the PDF is a scan

A scanned PDF is really a picture of a page, so there is no text for a converter to read. Run it through OCR PDF first. OCR recognizes text in scanned documents and makes them searchable and editable. OCR is available on the paid plans, and it works best on clear, straight, well-lit scans. After conversion, always double-check numbers such as 1, 7, 0 and 8, since these are the ones most easily misread.

A quick test: try to select a single word in the PDF. If you can highlight it, the file has real text. If the whole page highlights as one block, it is an image.

Method 2: Copy and paste by hand

Manual copying is fine for a small table in a normal, text-based PDF.

1. Open the PDF in a reader or your browser.
2. Use the text selection tool to highlight the table.
3. Copy it (Ctrl/Cmd + C).
4. Click the first cell in Excel and paste (Ctrl/Cmd + V).
5. Clean up columns, alignment and number formats.

If everything lands in one column, use Data → Text to Columns in Excel, choose Delimited, and pick the separator that matches your data, usually Tab or Space.

Which method should you use?

Prepare the PDF for a cleaner conversion

A few minutes of prep often saves a lot of cleanup afterwards.

Clean up the table in Excel

Even a good conversion usually needs a short checkup:

1. Check the headings. Make sure the header row is in the right place and not repeated on every page.
2. Remove stray rows. Delete page headers, footers and subtotals that were repeated by the PDF layout.
3. Fix merged cells. Unmerge any cells that block sorting or filtering.
4. Convert text to numbers. If numbers are left-aligned or show a green warning triangle, convert them to real numbers.
5. Set formats. Apply currency, date or percentage formats to the right columns.
6. Compare totals. Add up a column and compare it with the total printed in the PDF to catch missing or misread values.

Common problems and fixes

Tips for better results

• Tables with visible rows and columns usually convert more cleanly than loosely spaced text.
• Convert only the pages you need; shorter files are faster and easier to check.
• Keep a copy of the original PDF so you can compare it with the spreadsheet.
• Always verify totals and a few random rows against the PDF before using the data in reports or accounting.
• Converting a PDF to Excel gives you an editable approximation of the table. Complex layouts may need some manual tweaking.

Going the other way: Excel back to PDF

Once your data is cleaned and updated, you can turn it back into a polished document with Excel to PDF. Add page numbers with Add Page Numbers, and protect it with Protect PDF if it contains sensitive figures.

If your table is in a text-heavy report, you may prefer PDF to Word to keep the document layout and edit the table in Word.

Free plan and limits

You can try Tools4PDF without signing up. The free plan includes up to 25 tasks a day and files up to 15 MB. Paid plans raise those limits and add OCR text recognition, batch download support and conversion history, which are useful if you regularly handle statements or multi-file jobs. See the plans on the Tools4PDF homepage.

Is it safe to convert financial documents online?

Tables often come from invoices, bank statements and reports, so privacy matters.

• Read how files are handled on the Security page before uploading sensitive documents.
• Remove or black out personal details you do not need with Redact PDF.
• Delete downloaded copies you no longer need from shared computers.

Frequently asked questions

How do I copy a table from a PDF to Excel?
 Convert the PDF with the PDF to Excel tool and open the XLSX file, or select the table in a PDF reader, copy it and paste it into Excel.

Why does my table paste into one column?
 The data was pasted as plain text. In Excel, use Data → Text to Columns and select the right delimiter.

Can I convert a scanned PDF to Excel?
 Yes, but you need OCR first, because a scan contains no real text. Run OCR PDF, then convert the result. Check the numbers afterwards.

Will the formatting stay exactly the same?
 Not always. Text, tables and structure are carried over, but complex layouts, merged cells or unusual fonts may need cleanup.

Why are my numbers not adding up?
 They are probably stored as text. Convert them to numbers and remove extra spaces or symbols.

Can I convert only one page?
 Yes. Use Split PDF or Delete PDF Pages to keep only the page you need, then convert it.

Is there a file size limit?
 Each plan has its own limit, and the one for your current plan is shown on every upload screen. If a file is too large, compress it first.

Final thoughts

Retyping a table from a PDF is slow and easy to get wrong. Convert it, check the numbers, and spend your time on the data rather than the formatting.

Ready to try? Start with PDF to Excel, explore all the Tools4PDF tools, or read more tips on the Tools4PDF blog.