Convert PDF to Excel

How to Extract to Excel

1. 1

   Upload your PDF

   A report, invoice, statement or any document with tables, up to 300 MB and 200 pages.

2. 2

   Pick the detection mode

   Auto works for most documents; choose Lattice or Stream yourself if a table has an unusual layout.

3. 3

   Download the workbook

   One sheet per table, with real cells you can sort, filter and calculate on, not a block of pasted text.

Lattice or Stream: two ways to see a table

Lattice looks for tables drawn with visible grid lines, the way most invoices, bank statements and reports lay them out. It is precise and fast when the lines are there. Stream has no lines to go on, so it infers columns from how the text lines up and from the gaps between words, which works on tables that rely on spacing and alignment alone. Auto tries Lattice first, since it is the more reliable of the two when it applies, and falls back to Stream only if the result looks weak.

An accuracy score for every table, before you commit

Each table camelot finds comes with a measured accuracy score, and tables below the threshold you set are left out of the workbook rather than included as garbled data. So you can see whether a table's structure was picked up cleanly before you open the file, instead of discovering broken rows and merged cells afterwards. A photocopy with faint lines or a table that spans an awkward page break will typically score lower, and that low score is useful information rather than a fault.

One sheet per table, or merge the ones that match

By default every table becomes its own sheet, named by page and table number, so a report with several small tables does not collapse them into one confusing block. Turn on merging and tables that share the same number of columns are stitched together into a single sheet with one header row. That suits a report where the same table repeats across several pages and you would rather have it as one continuous range.

Frequently asked questions