How to convert PDF to Excel
- Drop your bank statement, vendor invoice, or price list into the conversion box.
- Select whether to place each page on a separate worksheet or combine the report onto one sheet.
- Confirm that number conversion is checked so currency amounts and totals can be calculated.
- Press Convert to Excel to download your XLSX workbook ready for bookkeeping.
Reconstructing accounting rows, cell boundaries, and ledger columns
Bank statements, payroll summaries, and price lists published as PDF documents contain visual characters placed at coordinates rather than structured cells. To convert these files into usable sheets, the tool groups characters sharing the same vertical baseline into a single ledger row. Words separated by normal spacing merge into one data cell, while wider gaps establish new columns. Single lines such as document titles, company addresses, or memo notes occupy column A completely.
Lines with two or more cells define column bands across the page width. Overlapping coordinate bands merge together, ensuring that right-aligned debit and credit amounts align in their respective columns regardless of character width. Column widths across the spreadsheet are sized to match the longest entry in each column, capped to prevent awkward layouts. This layout reconstruction delivers clean spreadsheets without transmitting confidential client or payroll information outside your office.
Numeric parsing rules, worksheet choices, and office document limits
The built-in number detection option parses accounting values so staff can immediately sum columns with standard formulas. The engine identifies values like 1,234.50, negative numbers like -12, ledger brackets like (45), and percentages like 12%, saving percentages as 0.12 with percent formatting. Leading currency symbols like $, €, £, and ¥ are stripped so calculations work properly. Meanwhile, employee IDs, inventory codes, or account numbers with leading zeros like 007 or 0123 remain text strings so significant digits are never lost.
Administrators can export multi-page files with one sheet per page, labelled "Page 1", "Page 2", and onward, or place all pages on one continuous sheet separated by an optional empty row. The resulting XLSX file opens in Excel, Google Sheets, and LibreOffice. Note that cell borders, background fills, fonts, and formulas are not transferred. Multi-column newsletter layouts produce mixed columns, sideways text is skipped, wrapped text lines produce separate rows, and paper scans must be processed with OCR PDF first.
Questions
Will our company payroll or banking information be uploaded to your servers?
No. Extraction runs locally inside your browser with pdf.js, so your financial paperwork never leaves your workplace computer.
Why did account numbers with leading zeros remain formatted as text?
Codes starting with zero like 0123 are preserved as text strings intentionally so spreadsheet software does not drop significant leading zeros.
Can I convert paper invoices scanned on an office photocopier?
Scanned paper copies contain flat images without selectable text. You must run the OCR PDF tool first before converting them to Excel.
How do I combine an eight-page statement onto a single spreadsheet sheet?
Choose “All pages on one sheet” under Worksheets before converting, and check the empty row option if you want page breaks visible.