How to get tables out of a PDF and into Excel

Why PDF tables are hard to extract

A spreadsheet knows that a value belongs to row 12, column D. A PDF does not. It stores each piece of text with an x and y position on the page and draws lines separately, if at all. When you see a neat table in a PDF, you are looking at text that happens to be lined up. Any tool that extracts tables has to infer the rows and columns from those positions.

Understanding this explains most of the problems people meet: columns that shift by one, values that merge, headers spread over two rows, and totals that land in the wrong place. None of these mean the extraction failed; they are the normal starting point for a quick clean-up.

How MyFileNest PDF to Excel works

PDF to Excel reads the selectable text of each page and splits each line into cells wherever there are clear gaps of whitespace between pieces of text. The result is an .xlsx workbook that you can open in Excel, LibreOffice Calc, Google Sheets or Numbers.

This works very well for simple, evenly spaced tables such as price lists, transaction lists and parts schedules. It is not full geometric table recognition, so complex tables with merged cells, wrapped text in cells or multi-line headers will need manual tidying. Scanned PDFs have no selectable text, so run OCR PDF first.

Choose the right route for your document

Step-by-step: from PDF to a usable spreadsheet

1. Check the PDF has selectable text by highlighting a row in a viewer. If it does not, run OCR PDF first.
2. If you only need some pages, extract them first with Extract PDF Pages. Less data means less clean-up.
3. Convert with PDF to Excel and open the workbook.
4. Delete rows that are not data: page headers, footers, logos, addresses and page numbers.
5. Check column alignment. Where a row has shifted, select the misplaced cells and move them into the right column.
6. Convert text to real numbers and dates. Use your spreadsheet's Text to Columns, VALUE or DATEVALUE features, or Find and Replace to remove currency symbols and thousands separators.
7. Add a total row and compare it with the PDF's printed total. If they match, the extraction is complete.
8. Save the cleaned workbook under a new name and keep the PDF as the source.

Cleaning numbers and dates

Values extracted from a PDF arrive as text. A cell showing "1,250.00" may look like a number, but sums ignore it until it is converted. Common fixes are removing currency symbols and spaces, removing thousands separators, and handling negative numbers shown in brackets or with a trailing minus sign. Check the decimal separator too: European statements often use a comma for decimals and a full stop for thousands.

Dates need similar care. A statement may print 03/04/2026, which means 3 April in the UK and March 4 in the US. Confirm the format by finding a date where the day is greater than 12. Once you know the format, convert the column consistently and format it as a date.

Worked example: categorising a year of card spending

A sole trader wants to separate business and personal spending from twelve monthly card statements downloaded as PDFs from their bank. Each statement lists date, description and amount in three evenly spaced columns.

They merge the twelve PDFs into one with Merge PDF, then convert it with PDF to Excel. The workbook has every transaction line, plus page headers and the bank's address repeated on each page. Filtering on the description column makes those non-transaction rows easy to select and delete. They convert the amount column to numbers, add a Category column, and use a filter to tag business purchases. The final check, comparing the sum of each month with the statement total, confirms nothing was lost. A job that would have taken hours of retyping is done in an afternoon.

Common problems and fixes

Privacy for financial documents

Bank statements, payslips and invoices are among the most sensitive files people convert. Many online converters upload the PDF to a remote server, and some keep files for a period after processing. MyFileNest PDF to Excel reads the PDF and builds the workbook in your browser, so the statement does not leave your device. After you finish, store the spreadsheet with the same care as the original statement.

Building a repeatable monthly routine

If you extract the same kind of statement every month, invest a few minutes once in a template workbook. Create a sheet with the columns you want, such as Date, Description, Amount and Category, with the correct number and date formats already set. Each month, convert the new PDF, paste the cleaned rows into the template and let formulas do the rest: totals by category, a running balance or a check against the statement total.

Keep a short note in the workbook describing the clean-up steps for that bank or supplier: which header rows to delete, how negative amounts appear and which date format is used. After a couple of months, the whole process takes minutes, and the checks catch any month where the statement layout has changed.

Checking accuracy before you rely on the numbers

A spreadsheet looks authoritative, which makes errors easy to miss. Before using extracted data for tax, accounting or reporting, reconcile it with the source. Compare the count of transactions with the statement, compare each page's subtotal where one is printed, and make sure the opening balance plus transactions equals the closing balance.

For data that came through OCR, scan the amount column for values that look out of place, such as 1O5.00 with a letter O, a missing decimal point that turns 12.50 into 1250, or a minus sign that did not survive. Sorting the column from largest to smallest is a quick way to spot outliers worth checking against the PDF.

Asking for better data at the source

PDF extraction is a workaround for data that should have been delivered in a spreadsheet in the first place. Before setting up a monthly extraction routine, check whether the source can export directly. Most online banking services offer CSV, OFX or spreadsheet downloads of transactions alongside PDF statements, often under an Export or Download transactions option. Many accounting systems, e-commerce platforms and suppliers can send price lists or reports as CSV or Excel files on request.

Data exported directly is exact, already split into columns and includes proper numbers and dates, so it removes most clean-up steps and the risk of misaligned values. Use PDF to Excel when the PDF really is the only format available, such as historic statements, documents from third parties or archived reports.

Summary

Check that the PDF has selectable text, extract only the pages you need, convert, then delete non-data rows, fix shifted columns and convert text to real numbers and dates. Finish by reconciling totals with the PDF. With a template workbook and a short note of the clean-up steps, a recurring statement becomes a routine task of a few minutes rather than an afternoon of retyping, and the reconciliation step gives you confidence that the numbers in the spreadsheet match the document. Keep the source PDFs alongside the workbook so anyone checking your figures later can trace each row back to its original statement.

Frequently asked questions

Can I export straight to CSV? Open the .xlsx and save it as CSV from your spreadsheet application.

Does it keep cell formatting, colours or formulas? No. You get the text values in cells; formatting and formulas are added in your spreadsheet.

Why not just copy and paste? For a few rows, copying from the PDF viewer is fine. For many pages, conversion keeps lines separate and saves a lot of manual work.