How to Convert a PDF to Excel: Free and Accurate Methods

Turning a PDF into an editable Excel spreadsheet sounds like it should be one click, but the result depends almost entirely on how the PDF was made. A PDF that was exported from a spreadsheet or an accounting system keeps its numbers as real text, so a good tool can rebuild the rows and columns with very little clean-up. A PDF that is really a photo or a scan of a page has no text at all until software reads the pixels, so it needs optical character recognition (OCR) and almost always needs tidying afterwards. This guide explains how to tell the two apart and then walks through every free and low-cost way to get the data into Excel, from Excel’s own built-in importer to online converters, copy-and-paste and OCR tools, with honest notes on accuracy and privacy.

What does “convert a PDF to Excel” actually mean?

Converting a PDF to Excel means extracting the data from the PDF and rebuilding it as rows and columns in a spreadsheet file, usually the .xlsx format that Excel, Google Sheets and LibreOffice Calc all read. It is not the same as opening a PDF inside Excel: Excel cannot display a PDF, so a converter has to read the page, work out where each table and cell sits, and write that structure into a fresh worksheet.

That is harder than it sounds. A PDF is a fixed, print-style layout — it records where text and lines appear on the page, not which numbers belong in which column. Many tables separate their columns with nothing but white space, so the software has to infer the grid. This is why two PDFs that look identical on screen can convert very differently, and why no tool is perfect every time.

Why some PDFs convert cleanly and others don’t

The single biggest factor in a successful conversion is whether the PDF contains real, selectable text or only an image of text. Before you pick a method, open the PDF and try to select a few words with your cursor or run a text search. If you can highlight individual words, it is a native PDF. If the whole page selects as one block or nothing selects at all, it is a scanned image.

Native (text-based) PDFs

Native PDFs are created digitally — exported from Excel, an accounting package, a bank’s online statement, or a “Save as PDF” command. The characters are stored as text, so a converter can read them directly and usually reconstructs clean columns. These are the files that convert most accurately and are the best candidates for Excel’s own built-in importer.

Scanned (image) PDFs and OCR

Scanned PDFs are pictures of a page, produced by a scanner, a phone camera or a photocopier. There is no text to extract, so the tool must run OCR, which recognises the shapes of letters and digits and turns them into text. OCR on plain paragraphs is mature and reliable, but tables are harder: the software has to solve the layout first — where each column begins and ends — and then read the characters inside. Expect merged columns, the odd misread digit (an 8 read as a 6), and blank cells, especially if the scan is faint, skewed or low resolution. Always proofread figures from a scanned conversion against the original.

How to convert a PDF to Excel for free

There are five dependable routes. Start with the one that matches your file and the software you already have — for a native PDF on a Windows PC with Excel, the first method is usually the fastest and the most private because nothing leaves your computer.

Method 1 — Excel’s built-in “From PDF” importer (Power Query)

Modern versions of Excel can import a PDF directly, with no add-in and no upload. The feature is part of Power Query and is available in Excel for Microsoft 365, Excel 2024, 2021, 2019 and 2016 on Windows (it needs Microsoft’s .NET Framework 4.5 or later, which most PCs already have). Support on Excel for Mac is more limited.

The steps are:

1. Open a blank workbook and go to the Data tab.
2. Choose Get Data > From File > From PDF, then select your PDF and click Open.
3. In the Navigator pane, Excel lists every table and page it found. Click each one to preview it.
4. Click Load to drop the table straight onto a sheet, or Transform Data to open Power Query and clean it first — removing blank rows, promoting the top row to headers or splitting a stubborn column.

Because the file is processed on your own machine, this method is both free and private, which matters for bank statements, payroll or anything personal. Its main limit is that it only reads native text PDFs; a scanned image will import as empty or garbled.

Method 2 — Free online converters

Web converters are the quickest option when you don’t have a recent Excel, or you are on a Chromebook or phone. You upload the PDF, the service rebuilds the tables and you download an .xlsx file. Reputable names include Adobe Acrobat online, Smallpdf and iLovePDF. They are easy and often accurate on clean native PDFs, but note the real free-tier limits:

• Adobe Acrobat online lets you try the conversion free and handles files up to 100 MB, but signed-in free use of its export tools is capped (roughly one premium transaction per 30 days); unlimited exporting needs a paid Acrobat plan.
• Smallpdf allows a couple of free conversions per day before prompting you to upgrade.
• iLovePDF converts native PDFs free with no daily cap, but OCR for scanned files is reserved for its paid Premium tier.

The trade-off is privacy: your document is uploaded to someone else’s servers. Avoid online converters for sensitive or confidential data, and prefer a method that keeps the file on your device.

Method 3 — Copy and paste with Text to Columns

For a small table, or when a converter mangles the layout, manual extraction is reliable and completely free. Open the native PDF in any reader, select the table, copy it, and paste it into Excel. The data often lands in a single column, so then:

1. Select the pasted column.
2. Go to Data > Text to Columns.
3. Choose Delimited, tick the separator that matches (a space, tab or comma) and finish.

Excel then spreads the values across proper columns. It takes a minute of fiddling but keeps your figures exact and nothing leaves your computer. This fallback does not work on scanned PDFs, because there is no text to copy.

Method 4 — Go through Google or a word processor first

If the PDF is mostly prose with one small table, it can be easier to get the text into an editable document and then move the table into a sheet. You can convert a PDF to Google Docs (Google Drive even runs OCR on scans during the upload) or open a PDF in Microsoft Word, tidy the table there, then copy it into Excel or Google Sheets. This two-step route trades a little extra effort for better control over messy layouts.

Method 5 — The LibreOffice and OpenOffice Calc route

Neither LibreOffice Calc nor Apache OpenOffice Calc can import a PDF’s tables automatically — in the OpenDocument world a PDF is treated as a finished output format, not an editable source. The practical workaround is the same copy-and-paste technique from Method 3: open the PDF, copy the table, paste into Calc, then use Data > Text to Columns. If you prefer open-source software end to end, a free command-line tool such as pdftotext or the table-extraction utility Tabula can pull the data out first. Once it is in Calc you can save it as .xlsx for Excel, or keep it as an .ods spreadsheet.

Which method gives the most accurate result?

For a clean, native PDF the most accurate results come from Excel’s built-in From PDF importer or a well-regarded dedicated converter, because both read the real text rather than guessing at pixels. Dedicated PDF-to-Excel tools often edge ahead on complex multi-page tables, where they do a better job of keeping columns aligned. For scanned PDFs, accuracy depends far more on the quality of the scan than on the brand of tool — a sharp, straight, high-resolution scan converts well, while a faded or crooked one will need manual repair whatever software you use.

Whatever route you choose, treat the first output as a draft. Always spot-check totals, dates and decimal points against the original, because a converter that silently merges two numbers into one cell, or drops a leading zero, can look perfectly tidy while being wrong. The more rows and columns a table has, the more worthwhile it is to reconcile the grand total in the spreadsheet against the figure printed on the PDF before you rely on anything.

How do you convert a PDF bank statement or invoice to Excel?

Bank statements, invoices and accounting exports are the most common PDFs people want in Excel, and they are usually native text PDFs, which is good news. Because they also hold personal financial data, the privacy-friendly methods matter most here: Excel’s From PDF importer or copy-and-paste keep the file on your own computer, which is far safer than uploading a statement to a free website. If the statement runs to several pages, Excel’s Navigator pane lets you load each page’s table and then stack them, and Power Query can strip out the repeated page headers in a few clicks. Watch the date and currency columns in particular — reformat them as proper Date and Number cells so that later sorting, filtering and sums behave, rather than leaving them as plain text. Once the data sits in a clean sheet you can analyse it with ordinary spreadsheet tools; our guide to managing data in Microsoft Excel covers the next steps.

Common mistakes when converting a PDF to Excel

Most failed conversions come down to a handful of avoidable errors:

• Using an online OCR tool on a native PDF. If the text is already selectable, you don’t need OCR — a direct importer will be cleaner and faster.
• Not checking the numbers. Converters can misread digits or shift a decimal place. Reconcile at least the column totals before you trust the sheet.
• Ignoring regional number formats. A tool may read “1,234.56” as text, or confuse the comma and full stop used as thousands and decimal separators. Set the cell format and, if needed, use Find & Replace to fix separators.
• Uploading confidential files to a free web service. Bank statements, payroll and medical data should stay on your own device — use Excel’s own importer or copy-and-paste instead.
• Expecting a perfect layout from a messy PDF. Merged cells, footnotes and multi-line headers rarely survive intact. Plan to spend a few minutes cleaning up rather than hunting for a tool that does it flawlessly.
• Converting the whole document when you only need one table. Importing a single table (Method 1’s Navigator pane lets you pick) saves you deleting pages of unwanted text afterwards.

Is it safe to upload a PDF to a converter?

It depends entirely on the file and the service. Reputable converters encrypt uploads and promise to delete files after a short period, which is fine for non-sensitive material such as a public report or a product price list. But for anything personal or confidential, the safest choice is a method that never uploads the file at all: Excel’s built-in From PDF importer, copy-and-paste, or a desktop tool like LibreOffice all process the document locally. If you must use an online service for sensitive data, read its privacy policy, delete the file from the service afterwards, and avoid free tools that are vague about what they do with your uploads.

Who each method suits

Choose Excel’s built-in From PDF importer if you have Excel 2016 or later (or Microsoft 365) on Windows and your PDF has real text — it is free, private and quick. Reach for an online converter if you lack a recent Excel, are on a Chromebook or tablet, and the data is not sensitive. Fall back to copy-and-paste with Text to Columns for small or awkward tables where you want full control. Use an OCR-capable tool only when the PDF is a scan or photo, and budget time to proofread the result. And if you work entirely in open-source software, the LibreOffice or OpenOffice Calc copy-and-paste route keeps everything free and offline.

Frequently Asked Questions (FAQ)

Can I convert a PDF to Excel without any software?

Yes. If you have Microsoft 365 or Excel 2016 or later on Windows, the From PDF importer is already built in under Data > Get Data > From File > From PDF. If you don’t have Excel, a free online converter works in any browser, though you should avoid uploading sensitive files.

Why does my converted spreadsheet have columns all jumbled together?

This usually happens when the PDF separates columns with spaces rather than real table cells, so the tool can’t see the grid. Try Excel’s Text to Columns feature to split the data, or use a dedicated converter that detects table structure. Scanned PDFs jumble more often because OCR has to guess the layout.

Is converting a scanned PDF to Excel reliable?

It can work, but accuracy depends on the scan quality. A sharp, straight, high-resolution scan converts reasonably well with an OCR tool, while a faint or skewed one will produce misread digits, merged columns and blank cells. Always check the figures against the original before using them.

Is it free to convert a PDF to Excel?

Often, yes. Excel’s built-in importer is free with the program, and copy-and-paste costs nothing. Online converters offer free conversions but usually cap them — a couple per day, or OCR only on a paid plan — so heavy or scanned use may need a subscription.

Can LibreOffice or OpenOffice convert a PDF to a spreadsheet?

Not automatically. Calc in both suites treats a PDF as a finished output, so there is no direct import. The reliable workaround is to copy the table from the PDF, paste it into Calc and use Data > Text to Columns, then save as .xlsx or .ods.