Convert PDF to Excel without losing formatting

A PDF is a set of drawing instructions — “place this glyph at coordinate (x, y)” — not a data file. It has no concept of rows, columns, or cell types. When a converter rebuilds a table, it has to infer structure from the positions of characters on the page.

That inference works well when the PDF has clear whitespace corridors between columns and consistent row heights. It struggles when columns are tightly packed, rows span multiple lines, or the PDF was generated from a scanned image rather than a digital source.

Understanding this helps set realistic expectations: no tool can perfectly reproduce the visual look of a PDF in Excel, because the information simply is not there. But you can get the data — the numbers, dates, and labels — into the right cells with the right types. That is what “preserving formatting” really means in practice.

The single biggest factor in conversion quality is whether the PDF has a text layer. Open it in any viewer and try to select a word. If you can highlight individual characters, you have selectable text and a converter can work with the glyph coordinates directly. If selecting grabs the whole page as an image, it is a scan — and you will need OCR before conversion.

OCR adds a layer of uncertainty (misread characters, lost column boundaries) that compounds with the table-reconstruction step. Whenever possible, export the PDF from the source application (your accounting system, ERP, or report builder) as a digital PDF rather than printing and scanning.

Many free converters dump every value into the spreadsheet as a text string. That means “1,250.00” looks right but Excel treats it as text — SUM and AVERAGE return zero or an error, and sorting is alphabetical instead of numeric.

A better converter detects numeric patterns, dates, and percentages during extraction and writes them as the corresponding Excel cell type. The converter on this site does exactly that: integers, decimals, negative numbers in parentheses, and percentages are all written as numeric cells in the output .xlsx file.

Financial statements, inventory reports, and bank transaction lists often run across many pages. By default, most converters create one worksheet per page, which means your data is split into fragments with repeated headers.

If the converter supports a “combine pages” or “merge sheets” option, turn it on. The PDF to Excel tool here has a “Combine pages” toggle that stacks all pages into a single worksheet, strips duplicate headers, and gives you one continuous table ready for pivot tables and filters.

A three-second preview catches problems a ten-minute cleanup cannot. Look for these common issues before you hit download:

• Merged columns. Two columns collapsed into one, usually because the PDF had no whitespace gap between them. If you spot this, check whether the converter offers a column-detection sensitivity setting.
• Split rows. A single data row broken across two spreadsheet rows, often caused by wrapped text in the original PDF. Some converters let you increase the row-merge tolerance.
• Header misalignment. The first row is not recognised as a header, or the header ended up on row 2 because of a title line above the table. You can fix this in Excel by deleting the extra row and applying filters.

CSV is a flat text format. It cannot store column widths, frozen header rows, numeric cell types, or multiple worksheets. If you care about keeping the table usable in Excel, always choose .xlsx output.

CSV still has its place — feeding data into a database, a Python script, or an import wizard that expects delimited text. But for the “open it in Excel and start working” use case, .xlsx preserves far more of the original structure.

Even with the best converter, some manual cleanup is normal. A few Excel operations that fix the most common issues in under a minute:

• Text to Columns (Data tab) — splits merged columns by a delimiter or fixed width. Select the merged column, run the wizard, and pick the separator.
• Find & Replace (Ctrl+H) — removes unwanted characters like currency symbols, thousand separators in the wrong locale, or trailing whitespace that prevents matching.
• Format as Table (Ctrl+T) — applies banded rows, filter arrows, and auto-expanding ranges in one click. This is the fastest way to make raw conversion output look presentable.
• Paste Special → Values — if a column stubbornly stays as text, multiply it by 1 in a helper column and paste the result as values back over the original.

Some formatting is inherently lost in the PDF-to-Excel conversion because the source file does not contain the information:

• Cell background colours — PDFs draw coloured rectangles behind text, but there is no mapping from rectangle to cell.
• Bold, italic, and font faces — stored as glyph references in the PDF, not as spreadsheet cell styles.
• Formulas — a PDF shows the computed result, not the formula behind it. The output spreadsheet will contain static values.
• Merged cell ranges — the PDF renderer places text visually; it does not record which cells were merged in the original spreadsheet.

Accepting these limits upfront saves time. Focus on getting the data into the right cells with the right types — that is the part a good converter handles well.