Can the tool handle tables that span multiple pages?

Yes. Enable "Multi-page table" detection, and the tool checks consecutive pages for matching column structures. When a table continues from page 3 to page 4, both sections are extracted and combined into a single CSV with all rows in sequence. The column headers are taken from the first page only.

What is the difference between CSV and XLSX output?

CSV (Comma-Separated Values) is a plain text format that stores only data — no formatting, no formulas, no multiple sheets. It opens in any spreadsheet app and every programming language can parse it. XLSX is the native Excel format that preserves data types (numbers, dates, text), cell formatting, and supports multiple sheets. Choose CSV for maximum compatibility; choose XLSX for seamless Excel integration.

How does the tool handle empty cells or irregular tables?

Empty cells are preserved as empty CSV fields (two consecutive commas). Irregular tables where some rows have more columns than others use the maximum column count as the CSV width — shorter rows are padded with empty trailing fields. A warning is shown if column counts vary significantly between rows.

Can I convert a scanned PDF table to CSV?

Scanned PDFs require OCR before table extraction. The tool automatically detects image-only pages and runs OCR first, then applies table detection to the recognised text. For best results with scanned tables, use a PDF scanned at 300 DPI with good contrast and minimal skew — these three factors determine 80% of table extraction accuracy from scans.

What happens to formatting like currency symbols and percentages?

Currency symbols ($, EUR, GBP, YEN), percentage signs, and other special characters are preserved as text in the CSV output. Numbers retain their visible decimal places (e.g., "$1,234.56" stays as the string "$1,234.56"). In XLSX output, numeric values with currency symbols are stored as formatted numbers where possible.

PDF Tools2026-05-10

How to Convert PDF Tables to CSV: Extract Structured Data Accurately

Tables trapped inside PDFs are one of the most frustrating data formats to work with. You can see the data — rows and columns of invoice line items, bank transaction records, or survey results — but you cannot sort, filter, sum, or pivot any of it without manually retyping the numbers into Excel. PDF to CSV conversion solves this by detecting table structures within the PDF, extracting the cell contents, and outputting them in a structured format (CSV or XLSX) that spreadsheet applications can read natively. Our free PDF to CSV converter uses a combination of text position analysis, line detection, and whitespace pattern matching to identify table boundaries, rows, columns, and cell contents. It handles multi-page tables that span several pages, detects header rows, preserves numeric formatting, and attempts to resolve merged cells. All processing runs client-side in your browser, so sensitive financial data in bank statements, invoices, and internal reports never leaves your device. The output CSV opens directly in Excel, Google Sheets, LibreOffice Calc, or any data analysis tool.

table_chart

PDF to CSV

Free · No registration

Try this tool for free →open_in_new

Step-by-Step Guide

Upload Your Table-Containing PDF

Drag and drop your PDF (up to 30 MB) onto the upload area. The tool renders a page-by-page preview with detected table regions highlighted in blue overlays. This visual feedback lets you confirm the tool found your tables before conversion. If a table is not detected — common with borderless tables or tables embedded in complex layouts — you can manually draw a table region by clicking and dragging on the page preview.

Review Detected Tables and Configure Extraction

For each detected table, the tool shows a preview grid of the extracted data. Check that columns align correctly and that headers are identified. Toggle options as needed: "First row is header" (maps row 1 to CSV column names), "Detect merged cells" (attempts to expand merged cell values across their span), "Preserve number formatting" (keeps decimal places, thousand separators, and currency symbols), and "Multi-page table" (treats consecutive pages as a single continuous table for extraction).

Download as CSV or XLSX

Click "Extract Table" to finalise the conversion. Choose your output format: CSV (UTF-8, comma-delimited) for maximum compatibility with all tools and programming languages, or XLSX for direct use in Excel with preserved number formatting. Download the file — it is ready to open in your spreadsheet application. For CSV files, numbers, dates, and text are all preserved as strings; apply cell formatting in your spreadsheet app after opening.

Tips & Best Practices

check_circle

PDFs with clearly bordered tables (solid lines around cells) have the highest extraction accuracy — typically 98%+ for well-formed tables. Borderless tables that use only whitespace for column separation average 85-92% accuracy and may require manual column boundary adjustment.

check_circle

Bank statements and financial reports are the most common use case for PDF-to-CSV conversion. A 6-page bank statement with 30 transactions per page converts to approximately 180 rows of structured CSV data in under 10 seconds.

check_circle

Merged cells are the biggest source of extraction errors. If your table has cells that span multiple rows or columns (common in invoice headers and summary rows), enable "Detect merged cells" — this handles roughly 70% of merged cell cases correctly based on internal testing against the UNLV table dataset.

check_circle

Multi-page tables that continue across page breaks are detected automatically when the column structure matches between consecutive pages. The tool merges these into a single continuous CSV output, inserting a blank row or "---page break---" marker between pages (configurable in settings).

check_circle

Numeric formatting in PDFs is notoriously inconsistent — some PDFs store "1,234.56" as a single string while others store it as separate glyphs that get extracted as "1,234.56" or even "1 , 234 . 56". The "Normalize Numeric Values" option cleans up these artefacts, converting them to proper numeric format in the CSV.

check_circle

After conversion, open the CSV in Excel and apply these quick cleanup steps: use Text-to-Columns if columns are not properly delimited, apply number formatting to numeric columns, use Remove Duplicates on row data, and check for trailing/leading spaces with TRIM(). These 4 steps resolve about 90% of post-conversion formatting issues.

check_circle

For PDFs containing multiple different tables on the same page (e.g., a summary table and a detail table), the tool detects each table region separately. Each detected table is exported as its own CSV file, named with the table index and page number (e.g., "table-1-page-3.csv").

check_circle

Header row detection uses font weight analysis (bold text is more likely to be a header) and position analysis (the first row of a bordered table is typically a header). Enable "First row is header" for tables where you are confident the top row contains column names — this makes the CSV immediately usable in pivot tables and database imports.

Frequently Asked Questions

For tables with visible borders, detection accuracy exceeds 98% in our testing. For borderless tables, accuracy is 85-92% depending on column spacing consistency. Tables inside complex multi-column page layouts (like academic papers where text wraps around tables) have the lowest detection rates — roughly 70-80%. The manual region selection tool handles cases where automatic detection misses the mark.

PDF to CSV conversion turns locked-down data into actionable structured information you can sort, filter, analyse, and visualise. Our free converter detects tables automatically, handles multi-page and irregular layouts, and outputs clean CSV or XLSX files — all without your data ever leaving your browser. Upload a table-heavy PDF now and extract usable spreadsheet data in seconds.

Try this tool for free →open_in_new