PDF2Excel

How the PDF to Excel conversion works

PDF2Excel turns the tables in a PDF into an Excel workbook. Everything below happens inside your browser.

1. Reading every word and where it sits

A normal PDF already contains its text, so each word and its position are read directly. A scanned page or a photo is a picture: it is turned upright if it is sideways, straightened, its ruling lines are noted and erased, and the words are read with OCR (Tesseract).

2. Rows and columns

Words at the same height form a row. A column is found as a vertical strip of white space that no word crosses on any row, so tables without borders work. Where a table has drawn cell borders, the cells are taken from those lines. Titles above a table are set aside, and a heading that spans several columns is copied into each.

3. Wrapped text and long tables

A line that only continues the text of the cell above (a long description) is joined back into its row. A table that continues over several pages becomes one table: the repeated heading and "carried forward" lines are removed, and a row split by a page break is joined.

4. Real numbers and dates

Amounts such as 1,23,456.50, (500), 12% and 1,200/- become numbers Excel can add up, and dates become real dates. IDs, PIN codes and numbers with leading zeros stay as text so they are not changed.

5. Checks

Totals are compared with the rows above them, running balances with debits and credits, and quantity × rate with the amount. Serial numbers and dates are checked for order. Every problem is listed with its page and row, and the cell is coloured in the Excel file with a comment.

6. Your choices

Below the results is a checklist of common PDF-to-Excel problems - for example group names written once like merged cells, ALL-CAPITAL text, Dr/Cr balances or European number formats. Tick what applies and the workbook is rebuilt instantly.

Limits

  • Up to 100 pages and 60 MB per file.
  • Handwriting is not supported; very blurry scans may be misread, and such cells are flagged.
  • Password-protected PDFs must be unlocked first.

Advertisement