PDF tables to Excel without retyping: bank statements, price lists, reports
How a PDF table becomes a spreadsheet: what the converter can read, why some tables come out as one column, how to handle Indian number formats and multi-page statements, and a free browser tool that keeps the file on your device.
· 3 min read · 683 views · by the Cortex Digital Hub team
Columns detected from the PDF's own text positions. Numbers come out as numbers. Nothing is uploaded. Free.
Convert PDF tables to Excel → Opens PDF to Excel · runs in your browser
A bank statement, a supplier price list, a tender schedule, a lab report: the numbers are in a PDF and you need them in Excel to add them up. Retyping is the usual answer and the worst one. Here is how PDF-to-Excel conversion works, when it will not, and how to get clean numbers.
How the conversion works
A real PDF (not a scan) stores every word with its exact position on the page. A table is just words whose x-positions line up in columns and whose y-positions line up in rows. The converter reads those positions, finds the vertical gaps that run the whole height of the table, calls them column boundaries, and groups words into cells. Then it decides whether each cell is a number, a date or text.
That is why conversion quality depends on the PDF, not the tool: a table with consistent column gaps converts perfectly, and a table with ragged alignment does not.
The five-second check
Select text in the PDF with the mouse. If words highlight, it has a text layer and will convert. If nothing selects or the whole page selects as one block, it is a scan and needs OCR first, which is a different and much less reliable process for tables. Bank statements downloaded from net banking always have a text layer; statements photographed or scanned at a branch never do.
Settings that change the result
The Cortex PDF to Excel tool exposes the choices that matter:
- Page range. Convert only the pages with the table. Cover pages and terms produce junk rows.
- One sheet per page, or one sheet for all. For a 12-page statement with the same columns, one sheet; for a report with a different table on each page, one per page.
- First row as header. On for statements and price lists; off when the header is on the cover page only.
- Numbers as numbers. Converts "1,23,456.00", "₹ 4,500", "(2,300)" and "2300-" into numeric cells so SUM works. Indian lakh/crore grouping is understood; Dr/Cr suffixes are kept as text in a separate column where the PDF has them.
Common problems and fixes
One column of everything. No usable gaps. Try a narrower page range (sometimes a wide header merges the columns), or convert to Word and use Word's text-to-table on the lines.
Columns split in the wrong place. A column with long descriptions that wrap close to the next column. Set the first row as header, then merge the two description columns in Excel with =A2&" "&B2.
Amounts as text. The converter did not recognise the format, usually because of a currency symbol glued to the number or a trailing "Cr". Select the column in Excel, Data → Text to Columns → Finish, or use =VALUE(SUBSTITUTE(A2,",","")).
Dates as text. Indian "31/03/2026" is read as US "March 31" or as text depending on the Excel locale. Set the column format to date with the right order, or split with Text to Columns and rebuild with DATE().
Rows out of order. The PDF placed totals or notes between rows. Sort by the date column after conversion.
Bank statements specifically
Download the PDF from net banking rather than requesting it by e-mail; the e-mailed version is sometimes a password-protected scan. If the PDF is password protected, open it with the password and re-save (Print to PDF) before converting; converters cannot read encrypted files. Convert with one sheet for all pages, first row as header, numbers as numbers, and check that the closing balance on the last row matches the statement before you trust the sum.
Privacy
A bank statement is the last file to upload to an unknown server. The Cortex converter runs in your browser: the PDF never leaves your device and nothing is stored. The same applies to the PDF to Word and compress PDF tools.
Frequently asked questions
Why did my table come out as a single column?
The PDF had no gaps the converter could use to separate columns, usually because the text was placed with tabs that were dropped at export, or because it is a scan with no text layer. Try the page range for one page and check whether text is selectable in the PDF.
Will Indian number formats like 1,23,456.00 become numbers?
In a converter that understands Indian grouping, yes: 1,23,456.00 becomes 123456. Many converters built for US formats treat it as text or mis-split it. Check one number after conversion.
Can I convert a scanned bank statement?
Not directly. A scan has no text; it needs OCR first, and OCR on tables is unreliable. Download the statement as a PDF from net banking instead, which always has a text layer.
One sheet per page or one sheet for everything?
One sheet for everything for a multi-page statement with the same columns, so you can total it. One sheet per page for reports where each page is a different table.