PDF to Excel Converter Online Free: Complete 2026 Guide
You have a PDF with data trapped in it. Maybe a bank statement with three months of transactions you need to categorise for accounting. Maybe a supplier invoice with line items you need to enter into bookkeeping. Maybe a research paper with data tables you want to analyse. Maybe a quarterly financial report you need to model. Maybe an inventory PDF from a vendor that needs sorting and filtering. Whatever the source, copying data row by row by hand is slow and error-prone. You need that PDF data in Excel, fast and accurate, with numbers as actual numbers (not text), and column structure intact.
iHatePDF PDF to Excel converter handles it in seconds. The engine reads every page, finds the tables and rebuilds them as proper rows and columns in an editable .xlsx spreadsheet, one sheet per table plus a summary sheet. Advanced mode adds OCR for scanned pages. Numbers such as 1,234.56, $99 or (250) are stored as real numbers, ready for SUM, AVERAGE and pivot tables. The header row is bold and frozen, so you can identify columns immediately. Works in Microsoft Excel, Google Sheets, Apple Numbers, and LibreOffice Calc. Free, no watermark, no signup needed for single conversions, and a free account converts up to 3 PDFs at once. This guide covers the full conversion workflow, what gets detected (and what does not), bank statements and invoices, batch and mobile workflows, and common PDF-to-Excel fixes.
- Open iHatePDF PDF to Excel and upload your PDF
- Preview to confirm the right document
- Choose Basic for a digital PDF or Advanced for a scan, then click Convert to Excel
- Download your .xlsx and open in Excel, Google Sheets, Apple Numbers, or LibreOffice Calc
- Sort, filter, add formulas, build pivot tables
Why convert PDF to Excel?
PDFs are great for delivering data. They are terrible for actually working with it. The moment you need to do anything beyond reading (sort, filter, calculate, aggregate, pivot, chart, cross-reference, search), you need the data in a spreadsheet. PDF to Excel is the bridge from "here is the document" to "here is data I can actually work with."
Six concrete reasons people convert PDF to Excel:
- Run calculations. SUM transactions, AVG monthly spending, COUNT entries, find min/max values, build running totals.
- Sort and filter. See largest expenses first, filter by date range, isolate one vendor, find duplicates.
- Categorise transactions. Auto-tag bank statement entries by description, summarise spending by category for budgeting or tax prep.
- Build pivot tables. See spending by month by category, sales by region by quarter, performance by team by metric.
- Cross-reference data. VLOOKUP or XLOOKUP between this PDF data and your master spreadsheet, merge customer lists, match invoices to payments.
- Visualise as charts. Turn rows of numbers into bar charts, line graphs, pie charts for reports, presentations, and decision-making.
How to convert PDF to Excel: step-by-step
- Open the converter. Visit iHatePDF PDF to Excel in any web browser. Works on Windows, Mac, Linux, Chromebook, iPhone, Android, and tablets.
- Upload your PDF. Drag and drop the file onto the upload area, or click to browse. Cloud import works from Google Drive, Dropbox, and OneDrive.
- Preview before converting. The sidebar shows a thumbnail of your PDF. Confirm it is the correct document and that tables are visible. The engine then scans every page for tabular structure.
- Pick Basic or Advanced. Basic reads digital PDFs where you can select text. Advanced also runs OCR on pages that are only an image, such as scans, and detects the scan's language automatically.
- Click Convert to Excel. Tables, rows and columns are detected and rebuilt as proper Excel cells. Each table goes on its own sheet, and numbers such as 1,234.56, $99 or (250) are stored as real numbers.
- Wait for conversion to finish. Digital PDFs usually take seconds. Scans in Advanced mode take longer, because every page is read with OCR.
- Download your .xlsx. Save the spreadsheet to your device, or send it back to your cloud (Google Drive, Dropbox, OneDrive) with one click.
- Open and start working. Microsoft Excel (any version), Google Sheets (upload to Drive), Apple Numbers on Mac, or LibreOffice Calc. Sort, filter, add formulas, build pivot tables, create charts.
What gets detected and how it appears in Excel
Transparency on what the engine handles cleanly versus what may need light cleanup after conversion:
| Element in PDF | How it appears in Excel |
|---|---|
| Tables with clear borders | Real rows and columns in .xlsx |
| Tables on several pages | Each page's table on its own sheet (P1, P2 and so on) |
| Column headers | First row of each sheet, bold and frozen |
| Plain numbers (123, 1234.56) | Detected as numbers, ready for SUM |
| Currency values ($1,234.56) | Stored as numbers, the symbol kept as the cell format |
| Dates (various formats) | Kept as text, exactly as written |
| Percentages (12.5%) | Stored as a real percentage (12.5%) |
| Decimal commas (1.234,56 €, 12,50) | Read correctly, in any national number style |
| Arabic and Hebrew tables | Text in reading order, sheet set right to left |
| Scanned/image-only tables | Read with OCR in Advanced mode |
| Text labels and descriptions | Preserved as text cells |
| Hyperlinks in cells | Kept as plain text |
| Bullet or numbered lists | Each item as a separate cell |
| Multi-row complex headers | May need a quick tidy-up in Excel |
| Merged cells in PDF | May split into multiple cells |
| Images embedded in PDF | Excluded (data-focused conversion) |
| Charts and graphs | Excluded (extract underlying data instead) |
Specific use cases: bank statements, invoices, reports
PDF to Excel comes up in very specific real-world scenarios. Each has its own quirks and benefits:
Bank statements to Excel
Monthly statements with transaction tables (date, description, amount, running balance) convert cleanly to Excel. Use cases include budget categorisation by month, expense tracking for self-employment, tax preparation, mortgage applications, and reconciliation against accounting software. Statements downloaded from online banking work in Basic mode; if the bank protected the file with a password, enter it when asked. Scanned statements work in Advanced mode. Each page's table lands on its own sheet, ready for SUMIF by category and pivot tables by month.
Invoices to Excel
Supplier invoices with line items (description, quantity, unit price, total) convert directly into spreadsheet rows for bookkeeping, accounts payable workflows, and expense audits. Useful for accountants entering data into QuickBooks, Xero, or Sage, or for small business owners building monthly expense reports. With a free account you can convert 3 invoices at once.
Financial reports and quarterly statements
Annual reports, 10-K filings, quarterly earnings statements: when you need to actually model the data rather than just read it, conversion to Excel is the first step. Income statements, balance sheets, and cash flow statements come through as proper numeric tables ready for ratio analysis, year-over-year comparisons, and forecasting models.
Research data and academic tables
Scientific papers, market research reports, and statistical analyses often publish data tables embedded in PDFs. Converting to Excel lets you re-run analyses, build visualisations, or combine data with your own datasets. Citations and source references can be tracked separately while the numerical data sits in proper Excel format for re-analysis.
Inventory, sales, and operations reports
Supplier inventory lists, monthly sales by region, operational KPI reports, payroll summaries, customer lists: any tabular business data delivered as PDF becomes actionable when in Excel format. Pivot tables and filters reveal patterns that are invisible in the static PDF view.
Common PDF to Excel issues (and fixes)
Table not detected, data dumped as plain text
Happens when the PDF lacks clear table structure (no visible row or column borders, inconsistent spacing). Fix: If the PDF is scanned, convert it in Advanced mode so OCR can read it. If the original PDF has true tabular data but no border lines, the engine still detects most tables based on alignment. For ambiguous layouts, the conversion may need light manual restructuring in Excel using Text-to-Columns.
Numbers showing up as text in Excel
Sometimes individual cells contain stray characters (extra spaces, non-breaking spaces, hidden symbols) that prevent Excel from recognising them as numbers. Fix: Select the column in Excel, use the "Convert to Number" option that appears when you click the warning icon, or use the VALUE() function. For currency columns, you can also use Find & Replace to strip currency symbols and re-format the cells as Currency.
A long table split across several sheets
Each page's table goes on its own sheet, so a statement that runs over five pages gives you five sheets. The summary sheet at the front shows where each one went. Fix: In Excel, paste the rows from the following sheets underneath the first, delete the repeated header rows, and you have one continuous table.
Merged cells causing weird splits
PDFs with merged cells (one logical value spanning multiple columns or rows) sometimes split into multiple Excel cells with duplicated or empty values. Fix: In Excel, you can re-merge the cells (Home tab, Merge & Center) or fill empty cells with the value from above using Ctrl+G, Go To Special, Blanks, then formula = reference to cell above.
Currency symbols breaking number detection
Unusual currency symbols or formatting (such as "USD 1,234.56" vs "$1,234.56") may stay as text instead of numbers. Fix: Use Find & Replace to standardise the currency notation, then format the column as Currency from the Home tab.
Scanned PDF returns blank or garbled cells
Low-quality scans (blurry, skewed, or low resolution) can confuse the OCR. Fix: Re-scan at a higher resolution (300 DPI is the OCR sweet spot), straighten the page, and ensure good lighting if photographing rather than scanning. You can also run OCR PDF first to add a text layer (it supports many languages), then convert the result in Basic mode.
Extra blank rows or columns
Some PDFs have visual whitespace that the engine interprets as separator rows or columns. Fix: In Excel, select the empty rows or columns and delete them. For many empty rows, use Filter, uncheck (Blanks), and copy the visible rows to a fresh sheet.
Batch PDF to Excel (free account)
Single conversions work without an account. For converting multiple PDFs at once, sign in to your free iHatePDF account: up to 3 PDFs convert simultaneously, each becoming its own .xlsx file.
Batch is the right choice when:
- Quarterly bank statements. Three months of statements at once for budget review and tax preparation.
- Multi-vendor invoice processing. Three supplier invoices converted in parallel for monthly accounts payable.
- Multi-period financial reports. Q1, Q2, Q3 reports converted at once for year-to-date comparison.
- Inventory across categories. Three vendor inventory PDFs (one per supplier) converted together for unified stock view.
- Survey or research data sets. Three published PDFs with related datasets converted for combined analysis.
- Sales by region. Three regional sales PDFs converted in parallel for consolidated reporting.
Each PDF converts independently in parallel. A problem with one does not affect the others. You receive a clean .xlsx for each successful conversion. Free account creation takes about 30 seconds.
Converting PDF to Excel on mobile (iPhone and Android)
Convert from your phone with no app installation. The browser-based converter works on Safari, Chrome, Firefox, Edge, and Samsung Internet.
On iPhone or iPad:
- Open Safari and visit ihatepdf.com/pdf-to-excel
- Tap the upload area and choose your PDF from the Files app
- Choose Basic or Advanced, tap Convert to Excel and wait a moment
- The .xlsx saves to Files under Downloads, ready to open in Excel for iPhone, Numbers, or Google Sheets app
On Android:
- Open Chrome and visit ihatepdf.com/pdf-to-excel
- Tap the upload area and select your PDF from phone storage or Google Drive
- Tap Convert to Excel
- The .xlsx downloads to your Downloads folder, ready to open in Google Sheets, Microsoft Excel for Android, or share via Gmail
Conversion quality on mobile is identical to desktop because all processing happens on our servers, not on your phone. Useful when you receive a PDF invoice or bank statement on your phone and need it in spreadsheet form before reaching a desktop.
Tips for the cleanest PDF to Excel conversion
- Use the original PDF when possible. Re-saved or re-printed PDFs lose structure. Source PDFs (direct exports from banking apps, accounting software, or original publishers) convert cleanest.
- Higher resolution scans convert better. 300 DPI is the OCR sweet spot. Anything below 200 DPI degrades accuracy.
- Verify number columns after conversion. Select each numeric column and check the Excel status bar for SUM and COUNT (bottom right). Numbers written with a decimal comma, such as 12,50, are not always read correctly, so compare a few totals with the PDF.
- Standardise currency notation before conversion. Decks with mixed notations ($, USD, dollars) work better when standardised to a single symbol first.
- For bank statements, check date formats. Some banks use DD/MM/YYYY, others MM/DD/YYYY. Confirm Excel parsed dates correctly by sorting the date column.
- Scans in other languages: just choose Advanced. Advanced mode detects a scan's script and language, such as Cyrillic, Arabic, Devanagari or Chinese, and reads it with the matching OCR model. Clear, straight scans of printed tables give the best results.
- Save as .xlsx (not .csv) for type preservation. CSV loses Excel cell types (numbers, dates, currency formats). Always download as .xlsx, then export to CSV in Excel if needed.
- For very complex layouts, split the PDF first. Use Split PDF to extract just the table pages, then convert. Cleaner input means cleaner output.
Workflow chaining
PDF to Excel is often the first step in a longer workflow. Common chains:
- OCR first, then convert. OCR PDF to extract text from scans, then convert to Excel for editable cells. Best for low-quality scans.
- Split, then convert. Split PDF to isolate just the table pages from a long report, then convert only those pages to Excel.
- Convert, then export back to PDF. Edit the data in Excel, then Excel to PDF for a clean final deliverable with your updates.
- Convert, then merge multiple results. Convert several PDFs to Excel, copy the data into a single master spreadsheet for combined analysis.
- Unlock first if password-protected. Use Unlock PDF to remove protection, then convert to Excel.
- Convert and then chain into Google Sheets. Upload the .xlsx to Google Drive, open with Google Sheets, share with collaborators in real time.
Privacy and security
Bank statements, invoices, financial reports, salary data, customer lists: most PDF-to-Excel conversions involve sensitive content. Files upload over HTTPS, are converted on our server and are deleted automatically within one hour. Nobody looks at them, and they are never shared or used for AI training. Full picture in the privacy and security guide.
Frequently asked questions
What is the difference between Basic and Advanced mode?
Basic is fast and reads the text and tables already stored in a digital PDF, the kind where you can select text. Advanced does the same and also runs OCR on pages that are only an image, such as scans or photographed documents. Pages that already have text are read directly in both modes.
Will tables in my PDF be detected automatically?
Yes. The engine scans every page for tabular structure: rows separated by lines, consistent column alignment, repeated headers across pages. When it finds tables, it rebuilds them as proper Excel rows and columns. Most standard tables (bank statements, invoices, financial reports, inventory lists) are detected automatically with no configuration. For PDFs with unusual or very complex layouts, light cleanup in Excel may be needed after conversion.
Can it handle scanned PDFs?
Yes, in Advanced mode. Pages without selectable text are read with OCR and turned into rows and columns. The scan's language is detected automatically, from English, German or Russian to Arabic, Hebrew, Hindi or Chinese, and Arabic and Hebrew tables come out right to left. It works best with clear scans of printed tables; check the figures afterwards.
Will numbers be detected as numbers, not text?
Yes, for common formats. Numbers written like 1,234.56, 1.234,56, 1 234,56, $99, 12,50 € or (250) are stored as real numbers, so SUM, AVERAGE and pivot tables work straight away. Currency symbols and percent signs are kept as the cell's format, so 12.5% stays a real percentage, and dates stay as text. A value such as 1.500, which can be read either way, follows the decimal style used in the rest of the document.
What about multi-page tables?
Each page's table is placed on its own sheet, named after its page (P1, P2, P2-T2 and so on), and the first sheet summarises where everything went. To get one continuous list, paste the rows from the following sheets under the first and delete the repeated header rows.
What file format do I get?
.xlsx, the modern Microsoft Excel format used since Excel 2007. It opens in Microsoft Excel, Google Sheets, Apple Numbers, LibreOffice Calc and most other spreadsheet software, where you can add formulas, conditional formatting, pivot tables and charts.
Can I batch convert multiple PDFs at once?
Yes, with a free account: up to 3 PDFs at once, 40 MB each and 100 MB in total. Each PDF becomes its own .xlsx file, and they download together in one ZIP. Without an account you can convert one PDF of up to 20 MB at a time. Batch is ideal for a quarter of bank statements or several supplier invoices.
Will column headers be preserved?
Yes. The header row of each table is placed in the first row of its sheet, in bold and frozen at the top, so filters, pivot tables and lookups work straight away. Tables with two or three lines of header text may need a quick tidy-up in Excel.
Can I convert bank statement PDFs?
Yes, this is one of the most common uses. Statements downloaded from online banking convert in Basic mode; if the bank protected the file with a password, enter it when asked. For a paper statement you scanned, choose Advanced. Each page's table lands on its own sheet, ready for SUMIF and pivot tables. Check the closing balance against the PDF afterwards.
Can I import from Google Drive, Dropbox, or OneDrive?
Yes. Open the menu in the upload box, pick Google Drive, Dropbox or OneDrive, sign in once and select your PDF directly. When the spreadsheet is ready, you can save it straight back to Google Drive, Dropbox or OneDrive.
Are my files kept private?
Yes. Files upload over HTTPS, are converted on our server and are deleted automatically within one hour. Nobody looks at them, and they are never shared or used for AI training. The converter itself uses no generative AI: your figures are copied from the PDF, not guessed.
Can I convert PDF to Excel on my phone?
Yes. It works in any modern mobile browser (Safari on iPhone, Chrome on Android, Firefox, Edge, Samsung Internet). Upload the PDF from your phone's storage or from Google Drive, Dropbox or OneDrive. The .xlsx downloads to Files (iOS) or your Downloads folder (Android), ready to open in Excel, Google Sheets or Numbers.
Does the converted .xlsx work in Google Sheets and Apple Numbers?
Yes. .xlsx is the universal spreadsheet format. Google Sheets accepts .xlsx upload to Drive (right-click the file in Drive, Open with Google Sheets) and converts automatically. Apple Numbers opens .xlsx with a format conversion prompt and full editing support. LibreOffice Calc also handles .xlsx natively. Formulas, formatting, and table structure are preserved across all four applications.
Can I convert password-protected PDFs?
Yes, if you know the password. The file is marked as locked when you add it; enter the password and the conversion continues. Passwords are never cracked or bypassed. To protect the resulting .xlsx too, use File > Info > Protect Workbook > Encrypt with Password in Excel.
Can I convert PDF to Excel inside Excel itself?
In Excel for Microsoft 365 on Windows, Data > Get Data > From File > From PDF imports tables from a PDF. Use this converter when you don't have that version, when you're on a Mac, phone or tablet, or when a scanned PDF needs OCR.
How do I insert a PDF into an Excel sheet?
To attach the PDF itself, use Insert > Object > Create from File in Excel for Windows and choose the PDF; it is embedded as an icon or a preview of the first page. To get the PDF's data into cells you can work with, convert it here instead.
Is there a watermark on the spreadsheet?
No. The spreadsheet has no watermark and no sign-up is needed for single conversions. You download a clean .xlsx with only your data in it.
Smart table detection, built-in OCR, numbers as numbers. Bank statements, invoices, reports. Batch 3 with free account. No watermark.
Convert PDF to Excel →Use other tools
Free, fast, private PDF tools.
Show all tools →