How to Turn a PDF into Excel: 5 Methods Compared

Quick Answer: Yes, you can turn a PDF into an Excel file. If you have Microsoft 365 on Windows, use Data > Get Data > From File > From PDF in Excel at no extra cost. Otherwise export it with Adobe Acrobat (or Adobe's free online converter), or use a converter made for your document type. Scanned PDFs need OCR first, and every result needs a quick check against the original.

You can turn a PDF into an Excel spreadsheet in five practical ways: Excel's own PDF import, Adobe Acrobat's export, opening the PDF in Word and copying the tables, Google Drive's Google Docs conversion, or a dedicated converter. Which one works depends on whether the PDF holds real text or a scanned image, and whether the content is a table or flowing paragraphs.

First, what kind of PDF do you have?

Spend thirty seconds on this before choosing a method, because it rules several out.

1. Try to select a word. Open the PDF and drag across a line. If the text highlights word by word, it is a text PDF (exported from software). If you get a box around the whole page, or nothing, it is a scan or an image.
2. Look for a grid. Is the data you want in rows and columns, with or without ruling lines? Or is it running prose with a few numbers in it?
3. Count the pages the table covers. One page and twenty pages are different jobs.
4. Check for a password. Most tools need it removed or entered before conversion.

The combination tells you where to start:

Method 1: Excel's built-in PDF import

If you subscribe to Microsoft 365 and use Windows, the converter is already installed. Microsoft documents it in its Power Query import help: Data > Get Data > From File > From PDF, choose the file, then pick a detected table in the Navigator and click Load.

What it handles well: text PDFs with recognisable tables, including tables that continue onto the next page. It records your cleanup steps so the same import can be refreshed on next month's file. What it cannot do: scanned pages, and it is not offered in Excel for Mac or Excel for the web. The step-by-step guide to importing a PDF into Excel covers the Navigator and combining pages.

Method 2: Adobe Acrobat export

Acrobat converts the whole document (or a page range) into an .xlsx workbook, keeping fonts and cell formatting where it can. Acrobat Pro can also recognise text in scans during the export, which makes it the most common choice when the PDF is an image. Adobe also offers a free online PDF to Excel tool for occasional files. The menus, settings and typical cleanup are in the Acrobat PDF to Excel walkthrough, and the Acrobat comparison covers how it does on statements.

The trade-off is that Acrobat converts everything, so headings, paragraphs and page numbers arrive in the sheet along with the table, and each page may become its own block or worksheet.

Method 3: the Word round-trip

Word can open a PDF directly: File > Open, choose the PDF, and Word makes an editable copy while leaving the original unchanged. Microsoft's page on opening PDFs in Word says this works best on files that are mostly text, such as business or legal documents, and lists tables with cell spacing among the things that do not convert well.

When Word does rebuild a table, you can select it, copy it, and paste into Excel, and because Word puts a proper table on the clipboard, the cells usually stay separate. It is a reasonable free route for a report that has a table or two among pages of text. It is a poor route for a table that runs over many pages, since Word may break it into several tables with page headers between them.

Method 4: Google Drive and Google Docs

With no Microsoft or Adobe software at all, Google Drive's Open with > Google Docs converts a PDF to an editable Doc and runs OCR on scans. Google's Drive help on converting PDFs to text is honest about its limits: it suits files of two megabytes or smaller with clear, upright text, and tables and columns are "not likely to be detected". You get text, which you then paste into a spreadsheet and split into columns. The Google Sheets import guide walks through that splitting step.

This is the free fallback for a scanned page when nothing else is available, not a way to convert a large table.

Method 5: a dedicated converter

Online and desktop converters range from general table tools to ones tuned for a single document type such as invoices or bank statements. A general converter is worth trying when the built-in options produce a mess. A specialised one is worth paying for when you convert the same kind of document repeatedly, because it knows what the output columns should be.

For bank and credit card statements, QuickBankConvert is one such option. Rather than copying the page layout, it reads the transactions: each one becomes a row with date, description, category, a signed amount and the balance when the statement shows it. You upload the PDF (it is processed on our servers, not on your computer), check the preview against the statement's opening and closing balances, and download Excel or CSV from a free account. The bank statement PDF to Excel page shows the columns.

Can you turn a scanned PDF into an Excel file?

Yes, but only through a tool that does optical character recognition, which turns the picture of each character back into text. Acrobat Pro, Google Drive and dedicated OCR tools all do this. Accuracy depends on the scan: straight, sharp, high-contrast pages read well; skewed phone photos, faint print and handwriting do not. Expect to correct some values by hand. The guide to OCR for PDF to Excel covers preparing scans and checking OCR output.

How do you check the spreadsheet after converting?

No converter is right every time, and errors in a spreadsheet are quiet: a missing row looks just like a complete table. Run these checks before relying on the file:

• Row count. Count rows in the original table (or transactions on a statement) and compare.
• Totals. Sum a numeric column and compare it with any total printed in the PDF. For a statement, opening balance plus all amounts should equal the closing balance.
• Numbers are numbers. Select an amount column; if the status bar shows Count but no Sum, the values are text. Remove currency symbols and convert them.
• Dates are dates. Sort by date. Values that sort alphabetically or sit at the bottom are text or have day and month swapped.
• No stray rows. Filter each column for headings, page numbers and "continued" lines that slipped in between pages.
• Long text intact. Spot-check descriptions that wrapped onto two lines in the PDF.

When the problems are layout ones (shifted columns, merged cells, broken dates), the companion guide on converting PDF to Excel without losing formatting lists each symptom with its fix.

So what is the best way to convert PDF to Excel?

For a text PDF with tables and a Windows copy of Microsoft 365: Excel's own import, because it is free and repeatable. For scans or when you need the formatting kept: Acrobat. For a document that is mostly prose: Word. With only a Google account: Drive's Docs conversion plus a split. For bank statements you handle every month: a statement converter, since the cleanup the general tools leave behind is the same every time.

Related guides

• Convert just one PDF table to Excel
• Copy a PDF table into Excel and fix the paste
• Pricing and plan limits