Free · Fast · Privacy-first

PDF to Excel with Formatting Preserved

Converting a PDF to Excel and getting unformatted plain text in every cell is a frustrating half-result: the data is there but it does not look like the source, and you have to spend ten minutes reapplying number formats before the spreadsheet is actually usable.

⚡

Preserves currency and date formats

🔒

Detects percentage columns

✨

Keeps column headers and alignment

⚡

Output ready to use immediately

Cost: Free tier
Sign-up: Not required
Processing: Tool-specific
Privacy: Clearly disclosed

IframeResponsiveAttribution included

Add this PDF to Excel to your website

Drop the PDF to Excel into a blog post, product docs, intranet, or school portal with one iframe. Processing, privacy, and usage limits are the same as on the full tool page.

One copy-ready line of HTML
Responsive — adapts to any container width
No API credentials are placed in the snippet

Embed code

<iframe
  src="https://www.fixtools.io/pdf/pdf-to-excel?embed=1"
  width="100%"
  height="780"
  frameborder="0"
  style="border:0;border-radius:16px;max-width:900px;"
  title="PDF to Excel by FixTools"
  loading="lazy"
  allow="clipboard-write"
></iframe>

<iframe
  src="https://www.fixtools.io/pdf/pdf-to-excel?embed=1"
  width="100%"
  height="780"
  frameborder="0"
  style="border:0;border-radius:16px;max-width:900px;"
  title="PDF to Excel by FixTools"
  loading="lazy"
  allow="clipboard-write"
></iframe>

Attribution-friendly: a small "Powered by FixTools" link appears in the embed footer.

What formatting preservation actually means in PDF-to-Excel conversion

There are several distinct meanings of preserve formatting in PDF-to-Excel conversion and confusion between them leads to mismatched expectations. The strictest meaning is visual fidelity: making the Excel output look pixel-identical to the source PDF including fonts, colours, cell borders, and shading. This is rarely achievable and rarely useful because the goal of conversion is usually to enable analysis, which requires data structure not visual layout. A looser and more practically useful meaning is data formatting preservation: ensuring that numbers display with appropriate decimal places, currencies show with currency symbols, percentages show with percent signs, and dates show in recognisable date formats. This is what FixTools targets.

Currency detection works by recognising currency symbols (USD, GBP, EUR, JPY) and standard ISO currency codes in the source PDF cells. When a column contains predominantly currency-formatted values, the entire column is set to Currency or Accounting format in the output workbook. The currency symbol used matches the source so a Euro column shows with EUR rather than USD regardless of your system locale. Decimal places match the source (typically 2 for currencies, but the converter respects 4-decimal precision for currencies like Bitcoin or for forex applications where the source uses higher precision).

Date detection recognises common date patterns: 12/31/2024, Dec 31 2024, 2024-12-31, 31/12/2024 (UK), and several others. When a column is predominantly dates, the underlying Excel cell values are set to date serial numbers and the column format is set to a date format that matches the source pattern. This means you can sort, filter, and do date arithmetic on the column immediately without first having to convert text-format dates to real date values, which is one of the most common manual cleanup steps after most PDF conversion tools.

Header row detection identifies the first row of a table as containing column labels rather than data. Headers are formatted in bold in the output and frozen at the top of the sheet so they remain visible as you scroll, just like a properly-formatted spreadsheet would have. Identifier columns (SKUs, employee IDs, invoice numbers) are detected by their alphanumeric pattern and set to Text format to preserve leading zeros and avoid Excel's default tendency to interpret numeric-looking identifiers as numbers, which is the leading cause of subtle data corruption after PDF conversion.

Microsoft: Number formats in Excel Microsoft: Excel date and time functions

How to use this tool

💡

Upload your PDF and the converter automatically detects currency, date, and percentage columns. Download an Excel that opens ready to use.

How It Works

Step-by-step guide to pdf to excel with formatting preserved:

1
Upload your formatted PDF
Open FixTools and upload your PDF. The tool inspects column contents during extraction to detect formatting patterns. Currency symbols, percent signs, and date patterns are recognised automatically. The detection runs on each column independently, so a mixed-format table (currency in one column, dates in another, percentages in a third) is handled correctly.
2
Confirm detected formats
On the preview, formatted columns are highlighted with their detected format type indicated in the column header. Verify the formats match your expectations: currency columns should show currency, date columns should show date, percentage columns should show percentage. Adjust manually if any column was misidentified, which is rare but possible for unusual layouts.
3
Convert with formatting applied
Click Convert. The tool applies the detected number formats to each column in the output XLSX workbook. Currency, date, and percentage formats are encoded in the XLSX structure using standard Excel format codes that all modern spreadsheet applications recognise. The file generates and downloads.
4
Open and use immediately
Open the downloaded Excel. Currency columns show currency, dates show as dates, percentages show as percentages, all without any manual reformatting work. You can immediately sort, filter, calculate, and chart without the cleanup step that most PDF conversions require. This saves real time on every conversion, especially for ongoing reporting workflows where you convert similar PDFs repeatedly.

Real-world examples

Common situations where this approach makes a real difference:

Financial analyst building monthly reports

An FP&A analyst converts monthly P&L PDFs from regional offices into a consolidated reporting workbook. With formatting preservation, the converted files open with currency formatting intact, ready for immediate consolidation. Without formatting preservation, the analyst would spend several minutes per file reformatting columns before each consolidation cycle, which adds up to significant time over a year.

Operations manager tracking KPIs

An ops manager tracks weekly KPIs from a system that outputs PDFs with mixed format columns (counts, percentages, currency, dates). Formatting preservation means the converted Excel feeds directly into the manager's KPI dashboard without column-by-column reformatting. The KPI history accumulates cleanly week over week without manual format intervention.

Sales analyst running compensation reports

A sales operations analyst converts compensation report PDFs containing currency, percentage, and date columns into Excel for plan calculations. Formatting preservation ensures the converted data displays correctly to sales managers reviewing the reports, eliminating questions like are those numbers in dollars or cents that would arise from unformatted output.

Auditor reviewing historical financial PDFs

An auditor receives historical financial PDFs from a client and needs to load them into Excel for substantive testing. Formatting preservation makes the converted data immediately recognisable to the auditor, who can spot anomalies more quickly when amounts display in expected currency format rather than as raw decimal numbers without context.

Pro tips

Get better results with these expert suggestions:

Verify detected formats match source visually

After conversion, do a quick visual side-by-side check with the source PDF: do currency values show the right symbol, do dates display in the same format, do percentages show with the percent sign? Catching format misdetection at this stage takes seconds and prevents downstream confusion. Misdetected columns can be corrected via Excel's Number format dropdown on the Home tab.

Use Text format for identifier columns explicitly

Even with formatting preservation, identifier columns with leading zeros (like 00123 or SKU-0042) are sometimes misinterpreted by Excel when you sort or filter. After conversion, explicitly select identifier columns and apply Text format via the Number group. This locks in the leading zeros and prevents accidental numeric interpretation that would silently corrupt the data.

Lock the header row with freeze panes

The converted output already formats headers in bold, but explicitly freeze the header row via View then Freeze Panes then Freeze Top Row. This keeps headers visible as you scroll through long extracted tables, which is essential for navigating data with many rows. The combination of bold headers and freeze panes makes the workbook feel like a proper analysis-ready spreadsheet rather than a raw extract.

Apply table formatting for sortable analysis

After conversion, select the data range and press Ctrl-T to convert to an Excel Table. This applies sortable column headers, alternating row colours, and automatic range expansion as you add data. Combined with the format-preserved columns, the table presentation makes the converted data far more usable for analysis than a raw range, and the table structure handles new data appending cleanly.

FAQ

Frequently asked questions

Currency formatting (with the original currency symbol), date formatting (matching the source date pattern), percentage formatting, and identifier column text format (preserving leading zeros). Column headers are formatted in bold. Decimal precision matches the source. Cell colours, fonts, and borders from the source PDF are not preserved because those are visual layout properties rather than data formatting, and reproducing them is generally not useful for analysis workflows.

Yes. EUR, GBP, JPY, CHF, AUD, CAD, and other major currency symbols are recognised. The detected currency is preserved in the output formatting, so a Euro column shows with EUR symbol regardless of your system locale. ISO currency codes (USD, EUR, GBP) in column headers or footer rows are also recognised and used to confirm the column currency where the symbol alone might be ambiguous.

Yes. Detected date columns are stored as Excel date serial numbers (the underlying value), with a date display format applied. This means you can sort chronologically, filter by date range, calculate date differences with subtraction, and use date functions like YEAR or MONTH on the column values immediately. Text-based date columns from poor conversion tools would not support any of these operations without first being converted to real dates.

Yes. Columns where values consistently appear with percent signs are detected as percentage columns. The underlying values are stored as decimals (0.125 for 12.5%) per Excel convention, with percentage display format applied so the cells show 12.5% to the user. This is the format that lets you do percentage math correctly (multiplying 0.125 by another number gives the right product, where 12.5 would give a wildly wrong result).

Identifier columns are detected based on alphanumeric patterns (like SKU-0042 or 00123) and set to Text format in the output. This preserves leading zeros and prevents Excel's default tendency to interpret numeric-looking identifiers as numbers, which would silently strip leading zeros and corrupt the data on first sort or filter operation. Always verify identifier columns retained their full original strings after conversion.

No. The converter focuses on data formatting (number formats, date formats) rather than visual layout (colours, fonts, borders). These visual properties are not generally useful for analysis workflows and reproducing them perfectly would require significant additional complexity for little practical benefit. The output uses standard Excel default visual styles with the data formatting applied to make the spreadsheet immediately usable for analysis.

Yes. After conversion, select any column in Excel and apply a different number format via the Number group on the Home tab. The underlying cell values remain the same; only the display format changes. This lets you correct any misdetection quickly. Most well-formatted source PDFs auto-detect correctly, so manual overrides are usually only needed for unusual layouts where the detection heuristics did not have enough signal.

Slightly, because the converter has to inspect column contents to detect format patterns. The extra time is typically under a second for most files, even large ones. The time saved by not having to manually reformat columns after conversion vastly exceeds the small extra processing time. For high-volume batch conversions where every second counts, you can disable format detection in advanced settings if needed, but most users keep it on for the time savings.