How to convert PDF to Excel

PDFs are great for sharing, but when you need to sort, filter or calculate with the data inside them, a spreadsheet is far more practical. This guide explains how PDF-to-Excel conversion works, which PDFs produce the best results, and what to do with scanned documents — all using a free tool that runs entirely in your browser.

Try the PDF to Excel Converter

How to convert PDF to Excel

PDFs are the standard for sharing documents, but when you need to sort, filter, total or reformat the data inside them, a spreadsheet is far more practical. Converting a PDF to an Excel file gives you rows and columns you can manipulate, pivot and analyse — something a fixed-layout PDF was never designed for. This guide explains how the conversion works, which PDFs produce the best results, and what to do when a document is scanned.

Convert PDF to Excel online

A PDF stores text as positioned characters on a page — it knows where each letter sits but has no concept of rows, columns or cells. An Excel spreadsheet, by contrast, stores data in a grid of rows and columns that you can sort, filter and calculate with.

The PDF to Excel converter bridges this gap by analysing the position of every piece of text on each page, grouping text into rows by its vertical position, splitting those rows into columns by horizontal gaps, and then writing the result as a standard .xlsx workbook you can open in Excel, Google Sheets or LibreOffice Calc.

Everything runs in your browser — your PDF is never uploaded to a server. For digital PDFs the converter reads the embedded text layer directly. For scanned PDFs it can use built-in OCR to recognise text from the page images. If you need to go the other way, use the Word to PDF converter for documents or JPG to PDF for images.

How to convert PDF to Excel

  1. Upload your PDF. Drag and drop your file or click to browse. The maximum file size is 50 MB.
  2. Choose the conversion options. Select a conversion mode (Automatic is recommended for most documents) and a worksheet layout. Enable OCR if your PDF is scanned.
  3. Click Convert to Excel. The converter analyses each page, detects tables and structured data, and builds an Excel workbook.
  4. Download your XLSX file. Your file is named originalfilename-converted.xlsx and opens in any spreadsheet application.

What types of PDFs can be converted?

The converter works best with PDFs that contain structured, tabular data:

  • Invoices — line items, quantities, prices and totals arranged in columns convert cleanly.
  • Financial reports — balance sheets, income statements and cash-flow tables with aligned columns.
  • Tables — any data presented in a grid with consistent column boundaries.
  • Spreadsheets saved as PDFs — documents originally created in Excel or Google Sheets and exported to PDF.
  • Business reports — sales figures, inventory lists and performance data in tabular form.
  • Statements — bank and credit card statements with date, description and amount columns.
  • Lists — any structured list with consistent column alignment across rows.
  • Data reports — research data, survey results and statistical tables.

Digital PDFs (exported from an app, not scanned) produce the best results because the text layer is already present. Scanned PDFs need OCR, and the quality depends on the scan resolution and clarity.

Can I convert a scanned PDF to Excel?

Yes, but with caveats. Scanned PDFs are images of pages — they contain no selectable text, only pixels. The converter detects this and offers to use built-in OCR (optical character recognition) to recognise text from the page images.

OCR results depend on:

  • Scan quality — a clear, high-resolution scan produces far better results than a blurry or skewed one.
  • Table structure — OCR recognises individual words and their positions, then the converter reconstructs rows and columns. Well-separated columns with clear borders work best.
  • Text clarity — printed, high-contrast text is recognised more accurately than handwritten or low-contrast text.

For the best results with scanned documents, enable the "Use OCR" option before converting. If the OCR output is poor, try a higher-quality scan or use the OCR PDF tool first to create a searchable PDF, then convert that.

Tips for best results

  • Digital PDFs convert best. If you have the original spreadsheet or document, export it directly to Excel rather than going through PDF.
  • Check the output. Table detection is heuristic — review the converted file and adjust column widths in Excel if needed.
  • Use the right mode. "Automatic" works for most documents. Choose "Tables only" if you only want detected tables, or "All pages" to capture everything.
  • Combine large documents. Use "Combine tables into one worksheet" to put all detected tables in a single sheet for easy sorting and filtering.
  • Need to merge PDFs first? Use the Merge PDF tool to combine multiple reports before converting.
  • Need to split a large PDF? Use Split PDF to extract the pages with tables before converting.

Try these tools

Frequently asked questions

Why can't I just copy and paste from a PDF into Excel?+

PDFs store text as positioned characters, not as rows and columns. Pasting usually produces a single column of text or jumbled data. The converter analyses text positions to reconstruct the table structure, giving you properly aligned rows and columns.

Does it preserve all formatting?+

The converter preserves table rows, columns, headers and basic structure. Complex formatting like merged cells, colours and fonts is not carried over — the goal is editable data, not a pixel-perfect copy.

What about scanned PDFs?+

Scanned PDFs are images, not text. The converter detects them and offers built-in OCR to recognise text from the page images before extracting tables. Results depend on scan quality and clarity.