How to Convert a PDF File to an Excel Spreadsheet (No Formatting Loss)

PDFs are built for reading, not editing. When the numbers you need are locked inside a PDF table, you have to move them into Excel before you can sort, filter, or run formulas. The challenge is doing that without scrambling the columns. This guide walks through how to convert a PDF file to an Excel spreadsheet while keeping the table structure intact.

Step 1: Check whether the PDF has a text layer

Before anything else, find out what kind of PDF you have. There are two broad types:

• Digital PDFs are generated by software. The text is real, selectable characters sitting in a hidden layer over the page.
• Scanned PDFs are images of a page — a photo or scan. There is no text underneath, only pixels.

To test yours, open the PDF and try to select a row of the table with your cursor. If the text highlights and you can copy it, you have a text layer and the next steps will work directly. If nothing highlights, the file is a scan and you will need the OCR route in Step 5.

This single check determines your whole approach, so do not skip it.

Step 2: Try the direct import in Excel

Modern versions of Excel can pull data from a PDF without any third-party tool. The structure preservation here is often better than a plain copy-paste because Excel tries to read the table as a table rather than as loose text.

1. Open a blank workbook.
2. Go to Data → Get Data → From File → From PDF.
3. Select your PDF and wait for the Navigator window to open.
4. Excel lists the tables and pages it detected. Click each entry to preview it on the right.
5. Choose the table that matches your data and select Load.

The Navigator usually splits content into separate tables per page. If your statement or report runs across several pages, you may see multiple tables that you will need to stack together once they are loaded. Preview each one so you import the right blocks and skip headers or footers you do not want.

This import path keeps columns aligned far more reliably than pasting, which is why it is worth trying first whenever your Excel version supports it.

Step 3: Fall back to copy-paste when import is unavailable

If your Excel version lacks the From PDF option, you can still copy directly from the PDF. Select the table in your PDF reader, copy it, and paste it into a blank sheet. Be prepared for the layout to suffer: copied PDF text often lands in a single column, with dates, descriptions, and amounts crammed into one cell per row. That is normal, and Step 4 fixes it.

Paste into the top-left cell of a clean sheet so you have room to expand columns to the right.

Step 4: Split merged columns with Text to Columns

When pasted data collapses into one column, Excel's built-in splitter rebuilds the structure.

1. Select the column holding the merged text.
2. Go to Data → Text to Columns.
3. Choose Delimited if the values are separated by a consistent character such as a space, comma, or tab. Choose Fixed width if each field starts at the same character position on every row.
4. For delimited data, tick the delimiter that matches your file and watch the preview split into clean columns.
5. Set the column data format — keep dates as dates and identifiers as text so leading zeros are not dropped — then select Finish.

Work one column at a time and check the preview before finishing. If a description contains the same character you are splitting on, fields can shift; in that case Fixed width is often the steadier choice. After splitting, scan a few rows to confirm dates, descriptions, and amounts landed in their own columns.

Step 5: Handle scanned PDFs with OCR

If Step 1 showed no selectable text, your file is an image and neither import nor copy-paste will return anything usable. You need optical character recognition (OCR), which reads the characters off the page image and turns them back into text.

Some PDF tools can run OCR and save a searchable copy of the file. Once the PDF has a recognized text layer, repeat Step 2 or Step 3 to bring the data into Excel. Because OCR is reading imperfect images, accuracy depends on scan quality — faint print, skewed pages, and tight columns all raise the chance of a misread digit, so verification matters more here than with a digital PDF.

Step 6: Verify the result

Conversion is not finished until you have checked it. Run through these before you trust the numbers:

• Row count. Compare the number of rows in Excel against the original PDF so nothing was dropped or duplicated.
• Column alignment. Confirm every value sits under the correct header.
• Number formatting. Make sure amounts are stored as numbers, not text. A quick way to test is to sum a column; if you get an error or a zero, some cells are still text.
• Totals. If the PDF shows a total, total the same column in Excel and confirm they match.

Spot-checking a handful of rows against the source catches most issues that slip past automated table detection.

A faster path for statements you process often

The manual steps above work for one-off conversions. If you regularly turn financial PDFs into spreadsheets, a purpose-built converter handles the table detection, column mapping, and OCR for scanned pages in one pass. For bank and card statements specifically, you can try the bank statement converter to skip the manual cleanup.

For a broader walkthrough that goes beyond statements, see the companion guide on how to convert a PDF to Excel.

Summary

To convert a PDF file to an Excel spreadsheet without losing formatting: check for a text layer first, use Excel's From PDF import when available, fall back to copy-paste plus Text to Columns when it is not, run OCR for scanned files, and always verify row counts, alignment, and totals before you rely on the data.