How to Convert PDF to Excel Without Losing Formatting
How to turn PDF tables into editable Excel spreadsheets: the best free and paid methods, how to handle scanned PDFs, and how to clean up numbers, dates and merged cells afterwards.
Bank statements, price lists, sales reports and research data often arrive as PDFs, but you can't sort, filter or add up a PDF. Converting the tables to Excel saves hours of retyping and avoids copying errors. This guide covers the main methods, what to expect from each, and how to clean up the result.
First, Check What Kind of PDF You Have
Text-based PDFs were exported from a program such as Excel, Word or accounting software. Try selecting a number in your PDF viewer: if you can highlight it, the PDF contains real text. These convert well.
Scanned (image) PDFs are pictures of paper pages. There's no text inside until OCR (optical character recognition) reads it, and OCR can misread characters, so expect to check every number.
Layout matters too. A simple grid with one header row converts cleanly. Merged cells, multi-line headers, tables spanning pages and footnotes inside tables all need more tidying.
Method 1: Our Free Online PDF to Excel Converter
For simple, text-based tables, our PDF to Excel tool is the quickest option:
- Open the tool and choose your PDF.
- It reads the text on each page and arranges it into rows and columns.
- Download the .xlsx file and open it in Excel, Google Sheets or LibreOffice.
The conversion runs in your browser, so your file isn't uploaded, which matters for bank statements and other private documents. It works best with clean, text-based tables. Merged cells and scanned PDFs may need tidying in Excel afterwards.
Method 2: Excel's Built-In PDF Import
Excel for Microsoft 365 on Windows can import tables directly from a PDF using Power Query:
- Go to Data → Get Data → From File → From PDF.
- Choose your PDF. Excel lists the tables and pages it found.
- Click each one to preview it, and select the tables you want.
- Click Load, or Transform Data to clean the table first in Power Query.
Good for: text-based PDFs with clear tables, especially recurring reports. Power Query remembers your cleaning steps, so next month's report can be refreshed in one click.
Limitations: it isn't available in every Excel version (check your Data menu), and it can't read scanned PDFs.
Method 3: Adobe Acrobat Pro
Acrobat Pro (paid) has a strong PDF-to-Excel export with built-in OCR:
- Open the PDF and choose Export PDF → Spreadsheet → Microsoft Excel Workbook.
- Choose whether to export all pages or a selection.
- Click Export, then review the file.
Good for: complex layouts and scanned documents, where its table detection and OCR are among the best available. Other desktop editors, such as PDFelement, Foxit PDF Editor and Nitro PDF Pro, offer similar exports.
Method 4: Copy and Paste
For a single small table, copying can be fastest:
- Select the table in your PDF viewer and copy it.
- Paste into Excel.
- If everything lands in one column, select it and use Data → Text to Columns, splitting by spaces or another delimiter.
This works best with text-based PDFs and short tables. Columns with spaces inside, such as "New York", may split in the wrong place, so check carefully.
Method 5: Scanned PDFs
For scanned tables you need OCR:
- Acrobat Pro and similar desktop editors run OCR during export.
- Our Image to Text tool extracts the text from a scanned page image, which you can then paste into Excel and split into columns.
To get better OCR results, scan at 300 DPI or higher, keep pages straight, and use good contrast. Always compare the totals in Excel with the totals on the original document.
Cleaning Up the Result
Even the best converter leaves some tidying. These are the most common problems and fixes:
Numbers stored as text
Signs: numbers align to the left, sums return 0, or a green triangle appears in the corner of cells.
- Select the cells, click the warning icon and choose Convert to Number.
- Or use =VALUE(A2) in a helper column.
- Remove currency symbols, spaces or thousands separators that block conversion, using Find and Replace.
Dates in the wrong format
A date like 03/04/2025 could be 3 April or 4 March depending on the country it came from. Use Data → Text to Columns → Date and choose the correct order (DMY or MDY), or rebuild the date with the DATE() function.
Negative numbers in brackets or with trailing minus
Financial reports often show −500 as (500) or 500-. Use Find and Replace, or a formula, to convert these to true negative numbers before doing calculations.
Merged cells and multi-line headers
Unmerge cells, give every column a single clear header, and fill in values that only appeared once for a group of rows. Tables with one header row and no merged cells work much better with sorting, filters and PivotTables.
Tables split across pages
Repeated header rows from each PDF page end up in the middle of your data. Filter the column for the header text and delete those rows.
Lost formatting
Colours, borders and fonts often don't survive conversion. That's usually fine: apply Format as Table in Excel for clean, consistent styling in one click.
Final Checks Before You Use the Data
- Row count matches the original
- Column totals match the PDF's totals
- No numbers stored as text
- Dates parsed in the right order
- No stray header or footer rows in the data
A Note on Privacy
Bank statements, payslips and customer lists are sensitive. Before using an online converter, check whether it uploads your file and how long it's kept. Browser-based tools like ours, and desktop software, keep the file on your computer.
Which Method Should You Use?
Situation · Best method
Simple text-based table, quick job · Our PDF to Excel tool
Same report every month · Excel's Get Data → From PDF
Complex layout or scanned document · Adobe Acrobat Pro or a similar desktop editor
One small table · Copy, paste and Text to Columns
Confidential data · Browser-based or desktop tools, not upload services
Conclusion
Converting PDF to Excel is easiest when the PDF is text-based and the table is simple. For harder cases, use a tool with strong table detection and OCR, then clean up numbers, dates and headers in Excel. Whatever method you choose, always check the totals against the original before relying on the data.
Try our free PDF to Excel converter. It runs in your browser, so your file stays private.