Skip to content

PDF to Excel & CSV – Extract Tables from PDFs

Try for free

Convert the tables in PDFs to Excel (.xlsx) and CSV: bank statements, invoices, reports and price lists. Bordered and borderless tables, multi-page tables joined, numbers kept as numbers. Paste links or upload files.

📊 PDF to Excel & CSV – Extract Tables from PDFs

Turn the tables in your PDFs into Excel workbooks and CSV files. Bank statements, invoices, financial reports, price lists and statistical releases come out as real rows and columns, with numbers stored as numbers. Paste PDF links or upload files from your computer. No login, no software to install.

✨ Why use PDF to Excel & CSV?

  • 🧾 Tables with and without borders: finds tables with drawn cell lines and tables whose columns are only lined up by spacing, such as most bank statements and statistical tables.
  • 📄 Multi-page tables joined: a table that runs over several pages becomes one table; a header repeated on every page is kept once.
  • 🔢 Numbers stay numbers: 1,234.56, 1.234,56, (1,234), -12.5%, $93.50, 45.00 DR become numeric cells you can sum and chart. Codes such as 00123 and account numbers stay text.
  • 🧠 Headers merged: column titles written over several lines become one header per column.
  • 📁 Ready-made files: one Excel workbook per PDF (one sheet per table, or all tables on one sheet) and, if you want, one CSV file per table.
  • 📤 Uploads or links: upload PDFs, paste direct links, Google Drive or Dropbox share links, or a web page whose PDFs should be converted.

🎯 Use cases

  • 🏦 Bank and card statements: transactions into a spreadsheet for bookkeeping and reconciliation.
  • 🧾 Invoices and receipts: line items, totals and tax into Excel.
  • 📈 Financial and statistical reports: quarterly tables, central bank releases, census tables.
  • 🏷️ Price lists and catalogs: supplier price tables into a sheet you can filter and compare.
  • 🗂️ Bulk conversion: point it at a page that lists many PDFs and convert all their tables in one run.

🚀 How to use

  1. Paste PDF links into PDF links, or upload files in Upload PDF files.
  2. Pick the files you want: an Excel workbook, CSV files, or both.
  3. Optionally limit the Pages (for example 2-10), set a password for protected PDFs, or choose the decimal separator.
  4. Click Start. Download the Excel and CSV files from the links in the results (excelUrl, csvUrl) or from the run's storage. Every table row is also in the results table, which you can export as JSON, CSV or Excel.

📥 Input

FieldWhat it does
urlsPDF links, one per line. Google Drive and Dropbox share links work. A web page link takes the PDFs it links to.
filesPDFs uploaded from your computer.
outputFormatsxlsx (one workbook per PDF) and/or csv (one file per table).
sheetLayoutperTable (one sheet per table) or oneSheet (all tables of a PDF on one sheet).
pageRangee.g. 1-5, 8, 12-. Empty means every page.
mergeMultiPageTablesJoin a table that continues on the next page (on by default).
detectionauto, ruled (bordered tables only) or aligned (borderless tables only).
decimalSeparatorauto, dot or comma.
passwordPassword for protected PDFs.
followPdfLinks, maxPdfsPerPage, maxDocuments, maxFileSizeMb, timeoutPerPdfSecs, maxConcurrencyWeb-page links and limits.
{
  "urls": ["https://slicedinvoices.com/pdf/wordpress-pdf-invoice-plugin-sample.pdf"],
  "outputFormats": ["xlsx", "csv"],
  "sheetLayout": "perTable",
  "mergeMultiPageTables": true
}

📤 Output

Each table row is one result:

FieldDescription
fileName, urlThe PDF the row comes from.
tableNumber, tableTitleTable number in the PDF and its caption when the PDF has one ("Table 2. ...").
pageNumber, pagesFirst page of the table, and every page for a multi-page table.
rowNumberRow number inside the table (header not counted).
columnsThe column titles (or Column 1, Column 2 ... when the table has no header).
cellsThe row's values in column order: numbers as numbers, text as text, empty cells as null.
dataThe same values keyed by column title.
detectionruled (drawn borders) or aligned (columns lined up by spacing).
excelUrl, csvUrlDownload links of the workbook and of this table's CSV file.

Example row:

{
  "fileName": "wordpress-pdf-invoice-plugin-sample.pdf",
  "tableNumber": 2,
  "pageNumber": 1,
  "rowNumber": 1,
  "columns": ["Hrs/Qty", "Service", "Rate/Price", "Adjust", "Sub Total"],
  "cells": [1.0, "Web Design This is a sample description", 85.0, 0.0, 85.0],
  "data": {"Hrs/Qty": 1.0, "Service": "Web Design This is a sample description", "Rate/Price": 85.0, "Adjust": 0.0, "Sub Total": 85.0},
  "detection": "aligned",
  "excelUrl": "https://api.scrape.ly/v2/key-value-stores/.../records/wordpress-pdf-invoice-plugin-sample.xlsx?signature=..."
}

The run's OUTPUT record lists every PDF with its page count, number of tables and rows, the Excel and CSV links, PDFs without tables (with the reason) and links that failed (failedInputs). Download links stay valid for 7 days; the files themselves stay in the run's storage like any run result.

❓ FAQ

Can it read scanned PDFs? Scanned pages are pictures without a text layer, so there is no table text to read. Such PDFs are listed in OUTPUT with the reason "No text layer". Run them through Image to Text (OCR) first.

A column is split in two or two columns are joined. What can I do? Try detection: "aligned" or "ruled" for that PDF, or limit the pages to the table you need. Tables with merged cells over several columns keep the text in the first column of the merge.

Are my files stored? Uploaded files are read only inside the run. The created Excel and CSV files are kept in the run's storage like any run result.

Which number formats are understood? Thousands separators with commas, dots, spaces or apostrophes, decimal dot or comma (detected per PDF, or set by you), negative numbers with a minus, in parentheses or with a trailing minus or DR, percentages, and currency symbols or codes. Dates stay text.

⚠️ Limits

  • PDFs need a text layer (see the scanned PDF question above).
  • An Excel sheet holds at most 1,048,576 rows (an Excel limit); longer tables are cut there and the full rows stay in the results table.
  • Files larger than maxFileSizeMb (100 MB by default, at most 500 MB) are skipped and listed in failedInputs.

💬 Support

Questions or a PDF that does not convert well? Write to hello@scrape.ly with the link and the page, and we will look at it.

//From the blog\\

Latest articles

All articles

The internet is full of data.
Start owning yours.

Scrape.ly gives you the infrastructure, the tooling, and the team to extract, process, and operationalize web data at any scale. Setup takes minutes.

No credit card. No setup calls.