Skip to main content
CanaryPDF

Extract Tables from PDF to Excel or CSV — Methods Compared

Financial statements, lab results, invoices, price lists — the data you need is so often locked inside a PDF table. Retyping it is slow and error-prone. Here are the practical ways to get PDF tables into Excel or CSV, and when each one works best.

Method 1: extract tables in your browser (free, private)

The CanaryPDF table extractor detects tables automatically and exports them as CSV (which opens directly in Excel) or JSON:

  1. Open the tool and select your PDF.
  2. Click Autodetect to find tables on every page, or draw a selection box around any table manually.
  3. Review the detected columns — the tool also infers column types (numbers, dates, text).
  4. Export to CSV — with a comma, tab or semicolon delimiter — and open it in Excel, or export JSON for scripts and web apps.

Everything runs locally in your browser — the PDF never leaves your device. For bank statements, payroll data or anything confidential, that's the whole ballgame: no upload means no server ever holds a copy.

Method 2: copy and paste

Select the table in your PDF reader, copy, and paste into Excel. Sometimes this just works. More often, every row lands in a single column, merged cells scramble the layout, and numbers arrive as text. Worth trying for a small, simple table; frustrating for anything real.

Method 3: Excel's built-in PDF importer

Recent Excel versions (Microsoft 365) can import PDFs directly: Data → Get Data → From File → From PDF. Excel's Power Query engine lists the tables it detects and lets you load one into a sheet. It's decent for well-structured tables, but it struggles with tables that span pages, have irregular headers, or sit close to other page elements — and it requires a Microsoft 365 subscription.

Method 4: scanned PDFs need OCR first

If your PDF is a scan (a photo of a page rather than digital text), regular extraction finds no text at all — that's true for every table tool, because there is no text layer to read. Run the scan through an OCR (optical character recognition) tool first to produce a searchable PDF — many scanner apps can do this at scan time, and most desktop PDF suites offer it. Once the PDF contains real text, open it in the table extractor and extract as normal. OCR accuracy depends on scan quality: a straight, high-contrast 300 DPI scan converts far better than a skewed phone photo.

Tips for cleaner results

  • Extract page by page when a table continues across pages, then combine in Excel — automatic multi-page stitching is where most tools guess wrong.
  • Check numeric columns after export: European decimal commas (1.234,56) and negative numbers in parentheses are the classic silent errors.
  • Pick the delimiter to match your Excel locale: comma for US-style Excel, semicolon where the system uses decimal commas (much of Europe).

Frequently asked questions

Can I extract a table from a password-protected PDF? Yes — unlock the PDF with its password first, then extract normally.

Multiple tables in one document? Autodetect finds each of them; you can export them separately or together.

Is there a file size limit? Processing happens on your machine, so the practical limit is your device's memory — hundred-page documents are normally fine.