DataMimiDataMimi

Convert a PDF table to Excel

Tables from invoices, reports and statements as spreadsheet rows.

Want it to work exactly your way?

Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.

✦ Make your own app

How to use Convert a PDF table to Excel

  1. 1Select your files, or drop them on the page
  2. 2Run it — nothing to set up
  3. 3Download tables.xlsx

Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.

Questions

How do I convert a table in a PDF to Excel?

Upload the PDF and download the .xlsx. Each table becomes a sheet, and a table that continues onto the next page is joined into one.

Does it work when the table has no lines?

Yes. Ruled tables are read first; tables whose columns are lined up with spaces, like most bank statements, are read by their headings and alignment.

Can it read a scanned PDF?

No: a scan is an image with no text in it. Use the PDF the software or website produced.

Are the numbers usable in formulas?

Yes. Thousands separators and currency signs are removed, so the amounts are numbers, not text.

More Excel tools

See all