PDFViewerConvert PDF to Excel
To convert PDF to Excel, use Excel's own Get Data From PDF importer (Microsoft 365), Acrobat's Export to Spreadsheet, or the free Tabula tool; a scanned table needs OCR before any of them can read it. PDF Viewer on this site does not export PDF tables to XLSX; it opens, searches and OCRs PDFs in the browser. This page explains which route fits your file and why numbers end up in the wrong cells.
First question: can the table be read at all?
A PDF to Excel converter needs three things: a text layer, consistent column positions, and table lines or enough spacing to tell columns apart. A bank statement exported by the bank has all three. A photographed receipt has none.
Test the text layer: open the file in the viewer, press Ctrl+F and search for a number from the table. No match means it is a scan; run OCR on the PDF first and download the searchable copy. OCR output is good enough for words, but check every digit afterward: 0 and O, 1 and l, 5 and S are classic confusions. See what OCR is for the limits.
Which PDF to Excel method for which case
| Case | Method | Notes |
|---|---|---|
| Microsoft 365 on Windows | Data, Get Data, From File, From PDF | Detects tables per page, loads via Power Query |
| Acrobat Pro | File, Export To, Spreadsheet, XLSX | Keeps formatting and multi-page tables |
| Free, any OS, simple tables | Tabula (open source, runs locally) | You draw the table area, export CSV |
| Small table, one page | Copy from the viewer, paste into Excel, Text to Columns | Fastest for a few rows |
| No Excel | Google Docs open, copy table into Google Sheets | Loses merged cells |
| Command line, many files | pdftotext -layout, then import as fixed width | Scriptable |
| Scanned statement | OCR first, then any of the above | Verify digits |
Main method: Get Data From PDF in Excel
- Open a blank workbook in Excel for Microsoft 365 (Windows).
- On the Data tab choose Get Data, From File, From PDF, and pick the file.
- The Navigator lists Table001, Table002 and each Page. Click one to preview it; tables are what you want, pages are a fallback.
- Click Transform Data if headers are in the first row or columns need types; otherwise click Load.
- The table lands in a sheet as a query. Right-click, Refresh re-reads the PDF if it changes.
Acrobat Pro: open the PDF, File, Export To, Spreadsheet, Microsoft Excel Workbook. Tabula: launch it, open the PDF, drag a rectangle around the table, Preview and Export as CSV, then open the CSV in Excel. For a handful of rows, select the text in the viewer, paste into Excel and use Data, Text to Columns with a space or tab delimiter.
Online services (Smallpdf, iLovePDF, Adobe's web converter) also do PDF to Excel; they are convenient but the statement is uploaded, which is a poor fit for financial documents.
What breaks on the way from PDF to Excel
- Numbers as text. Thousands separators, currency symbols and parentheses for negatives arrive as text; use Text to Columns or VALUE() to fix them.
- Merged and wrapped cells. A cell whose text wraps to two lines often becomes two rows.
- Tables without lines. Columns aligned by spaces get split unpredictably; pdftotext -layout plus a fixed-width import is more reliable than a converter here.
- Multi-page tables. Each page comes in as a separate table with repeated headers; append them in Power Query.
- Formulas. There are none in a PDF. Totals are plain numbers; rebuild SUMs yourself.
Going the other way is far easier; see Excel to PDF.
The copy-paste route, step by step
For a table of a few dozen rows, a converter is overkill. The viewer plus Excel's own text tools is faster and runs entirely on your machine.
- Open the PDF in the viewer. If it is a scan, run OCR first and wait for it to finish.
- Drag to select the table rows, press Ctrl+C.
- In Excel, click a cell and paste. The rows usually land in one column, one line per row.
- Select that column and choose Data, Text to Columns, Delimited, tick Space (or Tab), and Finish. Use Fixed width instead when amounts are right-aligned and names contain spaces.
- Fix columns that merged: Flash Fill (Ctrl+E) separates a value pattern once you type the first result by hand.
In Google Sheets, paste and use Data, Split text to columns, or the SPLIT() function. This route keeps nothing but the characters, so currency formats and bold headers are yours to re-apply, but it never puts a number in the wrong row.
Check the result
Compare the column totals in Excel with the totals printed in the PDF; a mismatch points to a misread digit or a lost row. Keep the original PDF open in the online PDF viewer in a second tab and use search inside the PDF to jump to any value you doubt. Nothing is uploaded, so bank and payroll files are safe to check this way.
Frequently asked questions
How do I convert a PDF to Excel for free?
Tabula is free and runs on your computer: draw a box around the table and export CSV. If you already have Microsoft 365, Excel's Get Data, From PDF is included.
How to convert PDF to Excel without losing formatting?
Acrobat's Export to Spreadsheet keeps the most formatting. Expect to re-apply number formats and column widths in any method.
Can I convert a scanned PDF to Excel?
Only after OCR adds a text layer. Run OCR, download the searchable PDF, then import it. Verify every number by hand against the scan.
How to convert a PDF bank statement to Excel?
Use Excel's Get Data From PDF or Tabula, then check that the closing balance in Excel matches the statement. Avoid online converters for statements.
Does this PDF viewer convert PDF to Excel?
No. It opens, searches, OCRs and annotates PDFs in the browser. Use Excel, Acrobat or Tabula for the XLSX, then verify against the PDF here.
Why are my numbers in the wrong columns after converting?
The converter guessed column boundaries from spacing. Tables without ruling lines are the usual cause; try Tabula with manual column lines or pdftotext -layout.