- PDF to Excel converts tables and text from PDF files into editable .xlsx spreadsheets
- The grid is rebuilt from the ruled lines the producer drew, not from the text stream — 5-stage detection with colspan/rowspan and borderless-table clustering
- Tables continuing across pages are merged and the repeated header row is dropped automatically
- Body cells that look like numbers are written as real numbers, so SUM works on open
- AFFLIGO converts entirely in your browser — no uploads, no server queues
- Maximum file size is 50MB per file (100 pages max), up to 10 files at once
- Supports Google Drive and Dropbox import for cloud-based workflows
- Output is always .xlsx format compatible with Excel, Google Sheets, and LibreOffice
- A compatibility scan scores every file and blocks scanned, rotated, or form PDFs before conversion
- Invoices auto-detect: header fields plus validated line items with a Needs Review column
- After conversion, use Excel formulas to clean up formatting and data types
Why Copy-Paste From a PDF Scrambles Your Table (And What to Do Instead)
A PDF is a layout format, not a data format. That one sentence explains every broken table you have ever pasted.
When you copy a table out of a PDF and paste it into Excel, Excel receives a stream of text fragments and has to guess where the columns begin and end. It guesses from whitespace, tab stops, and the order the fragments arrive. Meanwhile a spreadsheet has a hard requirement the PDF never met: every value lives in exactly one cell, and the cells form a strict rectangular grid. A PDF makes no such promise. It stores each glyph with an x/y coordinate and a font, and it stores them in paint order — the sequence the authoring program happened to draw them in, which is often not reading order.
So the scramble is not a bug in your copy-paste. It is the paste faithfully reproducing what the PDF actually contains, which is a pile of positioned fragments, not a table.
| What you see in Excel | What actually happened in the PDF | How to fix it |
|---|---|---|
| One row became two | A cell whose text wrapped onto a second line was drawn as two separate text objects. There is no line-break character in a PDF — the wrap is pure geometry, so the extractor cannot tell a wrapped cell from a new row. | Re-extract with a converter that reconstructs the grid, then merge the split rows. In Excel, a Data → Text to Columns pass will not fix this — the damage happened at paste time. |
| Everything landed in column A | The table had no borders and its columns were separated only by spaces. A space is not a delimiter Excel can act on, so the whole row arrived as one string. | Extract with a borderless-table-aware converter, or use Data → Text to Columns → Delimited → Space and accept the loss of any multi-word cell. |
| Cells are in the wrong order | The producer drew the table column-by-column, or drew a totals row before the body. Paint order followed the drawing, not the reading. | Only a positional re-alignment fixes this — you have to reconstruct which x-range each fragment belongs to, not trust the sequence. |
| Header row is missing or wrong | The header is on a different page, or it is a single merged banner cell spanning every column, so it has no clean column boundaries to align against. | Use a converter that merges cross-page tables and drops the repeated header automatically. |
| Totals and tax rows vanished | They are real rows, but they sit outside the ruled box that defines the table, so a line-based detector never includes them. | Check the original PDF against the output before you rely on it. Totals rows are worth verifying by eye every single time. |
| Numbers arrived as text | Copied cells carry no type information — a PDF has no notion of "number". Excel imports them as strings, so SUM returns 0 and sorting puts 10 before 9. | Data → Text to Columns → Finish coerces them. A dedicated converter should already have done this for you. |
Excel's built-in Data → Get Data → From File → From PDF is a genuinely good tool, and for a simple bordered table it is the right answer. But it reads the PDF the same way any extractor must — positionally — so it inherits the same limits. The most common complaints are all on the list above: a wrapped description splitting into two rows, a subtotal line dropped because it sits outside the ruled box, and a tax row that never appears. If a table is on a page after the one you selected, it is not in the output at all. A dedicated converter is worth it exactly when the table is irregular, multi-page, or has a shape Excel's Navigator does not model.
AFFLIGO's PDF to Excel tool does not rely on the text stream at all for the grid. It walks the PDF's drawing operators with the transform matrix tracked, so it sees the ruled lines themselves — the boxes and lines the producer drew — and rebuilds the cells from those.
The pipeline runs in five stages: 1) read the operator list to recover every stroked rectangle and line segment; 2) group those rules into separate table regions, which is what stops a page title or a second table on the same page from being swallowed into one; 3) build a rectangle lattice per region, giving exact cells including merged rows and columns; 4) fall back to a line-segment lattice, and then to a column-clustering pass for borderless tables (the detection algorithm from pdftables-ts v1.2.2); 5) merge tables that continue onto the next page, dropping the repeated header row so your data does not gain a phantom row every time a table breaks. Body cells that look like numbers are then written as real numbers — up to 15 digits or 12 digits with 10 decimals — so =SUM(B2:B500) works the moment you open the file, with no Text to Columns pass. Merged cells survive as real Excel merges, and column widths are set to fit the widest value.
| The PDF in front of you | Will copy-paste work? | Will a table-aware extractor work? |
|---|---|---|
| Bordered table, one page, one header row | Usually — this is the easy case | Yes, near-perfectly |
| Bordered table with merged header cells | Header lands as one wide cell, data misaligned | Yes — colspan/rowspan are handled by the lattice |
| Borderless table, columns aligned by whitespace | No — everything lands in column A | Usually — the clustering pass finds the column gaps |
| Table spanning two or more pages | No — you get one page, and a repeated header | Yes — pages are merged and the repeat is dropped |
| Two or more tables on one page | They merge into one mess | Yes — each ruled region becomes its own sheet |
| Scanned or photographed PDF | Nothing at all — there is no text to copy | No — there is no text layer. Run OCR PDF first, then convert the result |
| Totals row outside the ruled box | Present, but in the wrong place | May be missed by the line detector — verify it by eye |
Why Convert PDF to Excel
The real-world problems that PDF to Excel conversion solves.
PDFs are great for sharing documents, but terrible for working with data. Here is why you need to convert PDF to Excel:
PDF Data Is Not Editable
You cannot use formulas, sort, filter, or create charts in a PDF. Converting to Excel unlocks full spreadsheet functionality for data analysis.
Bank Statements and Receipts
Bank statements come as PDFs but accounting software needs Excel. Converting lets you import transactions directly into Tally, QuickBooks, or spreadsheets.
Financial Reports
Annual reports, financial statements, and audit data in PDF format need to be analyzed in Excel for calculations, comparisons, and visualizations.
Research Data
Academic papers, surveys, and research reports contain tables that need to be extracted for statistical analysis in Excel or Google Sheets.
You receive a 20-page bank statement PDF and need to analyze spending patterns. Without Excel, you are manually copying numbers. With conversion, all transactions appear in organized columns ready for pivot tables and charts.
How PDF to Excel Conversion Works
Locked tables don't volunteer their cells — here is the four-stage path from positioned glyphs to live spreadsheet rows.
PDF Parsing
The converter reads the PDF structure, extracting text objects, their x/y coordinates, font information, and any drawn lines or borders that indicate table boundaries.
Table Detection
The engine identifies table regions using two methods: Lattice detection finds tables with visible borders/lines. Stream detection finds tables separated by whitespace. The best tools use both approaches.
Column Alignment
Text objects within detected table regions are aligned into columns based on their x-coordinates. Headers, data rows, and footer rows are identified and separated.
Spreadsheet Generation
The aligned data is written into an .xlsx file with proper cell references, sheet names, and formatting. The output file is ready to open in Excel, Google Sheets, or LibreOffice.
AFFLIGO PDF to Excel Tool Features
Lattice plus stream detection that rebuilds locked tables as real .xlsx cells — parsed and reassembled on your own machine.
AFFLIGO's PDF to Excel tool extracts tables and text from PDFs entirely in your browser — lattice and stream detection running on your own machine, with zero uploads.
Text-Based PDFs Only
Scanned (image-only) PDFs contain no selectable text, so OCR them first with our free OCR PDF tool — then upload the searchable PDF here and convert.
Multi-File Support
Convert up to 10 PDF files at once with a 50MB limit per file (100 pages max). Each file is compatibility-scanned, processed individually, and downloaded separately.
Cloud Import
Import PDFs directly from Google Drive and Dropbox without downloading first. Select files from your cloud storage instantly.
XLSX Output
Output is always modern .xlsx format with proper cell references, compatible with Excel 2007+, Google Sheets, and LibreOffice.
Progress Tracking
Real-time progress ring shows upload percentage and processing status. Know exactly where your conversion stands.
100% Private Processing
Conversion runs entirely in your browser, not on a server. Nothing is uploaded, stored, or tracked — safe for sensitive statements.
Step-by-Step: How to Convert PDF to Excel
Upload the PDF, extract the tables, and open the .xlsx — three moves from locked pages to live cells.
Upload Your PDF
Drag and drop your PDF file into the upload zone, or click to browse. You can also import directly from Google Drive or Dropbox. Maximum file size is 50MB (100 pages max), up to 10 files.
Convert to Excel
Click Convert to extract tables right in your browser. The progress ring tracks reading page by page. Scanned (image-only) PDFs show a clear message asking you to OCR them first. If the ring finishes in a blink with an empty sheet, the PDF was scanned images — as shown in Step 2 above, the tool says so plainly instead of guessing, so OCR first.
Download Your Spreadsheet
Download your converted .xlsx file. Open in Microsoft Excel, Google Sheets, or any spreadsheet application. The file contains editable tables with all extracted data.
Extracting Tables from PDFs
How table detection works and tips for getting clean extractions.
Table extraction is the most valuable feature of PDF to Excel conversion. The converter must identify where tables begin and end, detect columns, and align data correctly. The reason this is harder than it sounds is that a PDF has no grid to find — it only has positioned glyphs and drawn rules. Why copy-paste fails covers that gap in detail.
Bordered Tables
Tables with visible lines and borders are easiest to detect. Lattice detection finds the grid lines and uses them as column boundaries. These convert with near-perfect accuracy.
Borderless Tables
Tables without visible borders rely on whitespace alignment. Stream detection looks for consistent gaps between text elements to identify column boundaries. Accuracy varies.
Complex Layouts
Multi-level headers, merged cells, and irregular layouts challenge all converters. For best results, simplify the PDF layout before converting if possible.
Multiple Tables
PDFs with multiple tables on one page are detected as separate tables. Each table typically gets its own sheet or section in the output file.
Scanned PDF to Excel (OCR)
Image-based PDFs need OCR first — here is the two-step workflow.
Scanned PDFs are images of text, not actual text data. Without OCR, the converter cannot read any content, so run the scan through OCR first, then convert the searchable PDF here.
Check for a Text Layer
Try selecting text in your PDF. If nothing highlights, it is image-only — run it through AFFLIGO's free OCR PDF tool first.
OCR First, Then Convert
Run the scan through an OCR tool to recognize characters and build a text layer. For tables, good OCR preserves column positions and row boundaries.
Extract and Convert
Upload the OCRed, searchable PDF to the PDF to Excel tool. It goes through the same table extraction pipeline as text-based PDFs. The output is an editable .xlsx file.
For best OCR results, scan at 300 DPI or higher with clean, high-contrast black-and-white output. Skewed or blurry scans produce more recognition errors.
Converting Bank Statements to Excel
Extracting transaction data from bank statement PDFs for accounting.
Bank statement conversion is one of the most common PDF to Excel use cases. Banks provide statements as PDFs, but accounting software and personal finance analysis require Excel format.
Upload Statement PDF
Upload your bank statement PDF. Most bank statements are text-based and convert directly. Scanned statements need OCR first — the tool shows a clear message if no text is found.
Review Extracted Data
The converter extracts transaction dates, descriptions, debits, credits, and running balances into separate columns. Check that all transactions are captured correctly.
Clean Up in Excel
Use Excel features to finalize: Text to Columns for split data, VALUE formula for text-numbers, TRIM for extra spaces, and formatting for currency columns.
Tally Prime Import
Indian users can import converted bank statements into Tally Prime for automated accounting. Clean up the Excel file first to match Tally's import format.
Spending Analysis
Once in Excel, create pivot tables to analyze spending by category, month, or vendor. Build charts to visualize cash flow and budget adherence.
While preparing this guide I extracted a 3-page bank statement: dates, descriptions, debits, credits and balances landed in separate columns with numeric cells intact — but the merged letterhead row came through as its own row above the table. Excluding page 1's header via page range gave a clean table on the second run.
Invoices and Financial Reports
Extracting structured data from business documents.
Invoice Processing
Convert vendor invoices to Excel for bulk data entry, expense tracking, and accounts payable workflows. Extract invoice numbers, dates, amounts, and line items.
Financial Statements
Annual reports, balance sheets, and income statements convert to Excel for financial analysis, ratio calculations, and year-over-year comparisons.
Expense Reports
Employee expense reports in PDF format convert to Excel for approval workflows, reimbursement calculations, and budget tracking.
Tax Documents
Tax forms, 1099s, and W-2s convert to Excel for tax preparation, deduction tracking, and audit documentation.
Preserving Formatting During Conversion
Why formatting breaks and how to fix it after conversion.
PDF to Excel conversion is never 100% perfect because PDFs and spreadsheets store data fundamentally differently. Here are the common issues and fixes:
| Problem | Cause | Fix in Excel |
|---|---|---|
| Numbers stored as text | PDF stores numbers as text characters | Data > Text to Columns > Finish. Or use =VALUE(A1) |
| Data in one column | No clear column boundaries detected | Data > Text to Columns > Delimited > choose delimiter |
| Extra spaces | PDF padding for alignment | =TRIM(A1) formula to remove extra spaces |
| Merged cells wrong | PDF merged cells don't map to Excel | Manually unmerge and fill down with data |
| Headers misaligned | Multi-level headers confuse detection | Manually adjust header rows after conversion |
| Currency symbols | $, Rs., EUR symbols embedded in text | Find & Replace to remove symbols, then format as currency |
1. Text to Columns for split data. 2. VALUE formula for text-numbers. 3. TRIM for extra spaces. 4. Find & Replace for currency symbols. 5. Go To Special > Blanks for fill-down. 6. Format Painter for consistent styling.
Multi-Page Tables and Large Documents
Handling tables that span multiple pages and large PDF files.
Some PDFs contain tables that continue across multiple pages. The converter must stitch these back together into a single table in Excel.
Table Continuation Detection
Advanced converters detect when a table on page N continues on page N+1 by matching column positions and header patterns. The pages are merged into one table.
Repeated Headers
Multi-page tables often repeat the header row on each page. The converter should detect and remove duplicate headers, keeping only the first occurrence.
Large File Handling
PDFs over 50MB (or 100 pages) are blocked before conversion. Use AFFLIGO's Split PDF tool to break the file into smaller sections, then convert each section separately.
Consolidating in Excel
After converting split PDFs, use Excel's Consolidate feature (Data > Consolidate) or Power Query to merge the separate sheets into one unified table.
Batch Converting Multiple PDFs
Converting multiple PDF files to Excel in one session.
AFFLIGO supports converting up to 10 PDF files at once. Each file is processed individually and the results are downloaded separately.
Upload Multiple Files
Select up to 10 PDF files using the file picker, or drag multiple files into the upload zone. The stats bar shows file count and total size.
Convert All
Click Convert to process all files. The progress ring shows which file is currently being processed (e.g., "File 2 of 5: statement.pdf").
Download Results
Download each converted .xlsx file individually. Files are downloaded sequentially with a short delay between each to ensure all downloads complete.
Using Excel Built-In PDF Import
Excel's native PDF import feature as an alternative method.
Microsoft Excel has a built-in feature to import data directly from PDF files. This works well for text-based PDFs but has limitations. It reads the PDF positionally, exactly like any other extractor, so it inherits the same blind spots — wrapped cells splitting into two rows, totals outside the ruled box, and tables on later pages not being included at all. Why those failures happen is explained in full above.
Open Excel's Data Import
In Excel, go to Data > Get Data > From File > From PDF. This opens the Navigator dialog showing detected tables.
Select Tables
The Navigator shows all detected tables and pages. Preview each table, select the ones you want, and click Load or Transform Data.
Power Query Editor
Use Power Query to clean and transform the data before loading it into Excel. This is the most powerful method for recurring conversions because you can refresh the query when the PDF updates.
| Feature | AFFLIGO Online | Excel Built-In |
|---|---|---|
| Price | Free | Requires Microsoft 365 |
| Scanned PDFs | OCR first, then convert | No OCR |
| Refreshable | No (one-time) | Yes (Power Query) |
| File Size | 50MB, 100 pages | No limit |
| Installation | None (browser) | Excel required |
Google Sheets Integration
Importing PDF data into Google Sheets for cloud-based workflows.
Google Sheets does not have a native PDF import feature, but you can use AFFLIGO's converter as an intermediate step:
Convert PDF to Excel
Use AFFLIGO to convert your PDF to .xlsx format. Download the converted file.
Import into Google Sheets
Open Google Sheets, go to File > Import, upload the .xlsx file, and choose "Replace spreadsheet" or "Insert new sheet(s)".
Alternatively, convert the PDF to Excel first, then use Google Sheets' Import functionality to work with the data in the cloud.
Best Practices and Tips
Getting the best results from PDF to Excel conversion.
Start with the Best PDF Quality
Use the highest quality PDF available. Text-based PDFs from digital tools convert better than scans. If scanning, use 300 DPI minimum.
Clean Up After Conversion
Always review and clean up the Excel output. Use Text to Columns, VALUE formula, and TRIM to fix common data type issues.
Convert Before Analyzing
Convert first, then analyze. Trying to extract specific data from a PDF is much harder than converting the whole document and filtering in Excel.
Use Power Query for Recurring Jobs
If you convert the same type of PDF monthly (like bank statements), use Excel's Power Query to create a refreshable connection. Just update the PDF and refresh the query.
Common Problems and Fixes
Solutions for the most frequent conversion issues.
Numbers Appear as Text
Most numbers arrive as real numbers — the converter writes numeric body cells as numbers, not strings, so SUM works immediately. A column can still land as text when the source format is not a plain number: a thousands separator (1,234.56), a currency symbol ($45.00), a trailing percent sign, an accounting negative in brackets ((45.00)), a leading zero (007), or a value with more than 15 digits. Fix: select the column, go to Data > Text to Columns > Finish, or use =VALUE(A1). Strip the separators first if the value cannot be parsed.
Data in Single Column
All data appears in column A. Fix: Use Data > Text to Columns > Delimited > choose Tab, Space, or Comma as delimiter.
File Too Large
Your PDF exceeds 50MB (or 100 pages) and is blocked before conversion. Fix: Use AFFLIGO's Split PDF tool to break it into smaller sections, then convert each section.
No Text Found in PDF
The tool shows a clear message when a PDF has no selectable text (scanned or image-only). Fix: Run AFFLIGO's OCR PDF tool first, then convert the OCR'd result to Excel.
Conversion Error
The tool could not extract tables from this PDF. Fix: Check the PDF has selectable text (not a scan). If the problem persists, try a different browser or a smaller file.
Online vs Desktop vs AI Converters
Comparing different approaches to PDF to Excel conversion.
| Feature | AFFLIGO (Online) | Adobe Acrobat Pro | Excel Built-In | Python (tabula) |
|---|---|---|---|---|
| Price | Free | $22.99/month | Microsoft 365 | Free (open source) |
| Installation | None | Desktop app | Excel required | Python required |
| OCR Support | OCR first, then convert | Yes | No | Via Tesseract |
| Batch Convert | 10 files | Unlimited | One at a time | Scriptable |
| File Size | 50MB, 100 pages | No limit | No limit | No limit |
| Privacy | Private (browser) | Local | Local | Local |
| Ease of Use | Very easy | Moderate | Moderate | Technical |
AFFLIGO wins on cost, convenience, and privacy -- free, no installation, 100% in-browser. Desktop tools win on file size limits. Python wins on automation for developers.
Security and Privacy
How AFFLIGO handles your files during conversion.
Conversion happens entirely in your browser — your PDF is read into memory and its tables rebuilt as .xlsx locally. Here is what that means for security:
No Upload
Files are never sent anywhere. There is no server copy to intercept, leak, or retain — the data in transit problem does not exist.
Nothing Stored
There is no server, so nothing is stored, cached, or used for any other purpose. Close the tab and nothing remains.
No Registration
No account, no email, no personal information required. Use the tool completely anonymously.
Transparent Process
The tool shows real-time progress while reading each page. Everything happens in front of you, on your device.
Even highly sensitive financial documents are safe here, because the bytes you drop in are the bytes that stay in your tab — that is the advantage of in-browser conversion over upload-based tools.
Frequently Asked Questions
Answers to the most common questions about PDF to Excel conversion.
Want to explore more?
Key Takeaways
- PDF to Excel converts locked PDF tables into editable .xlsx spreadsheets with formulas, sorting, and charts
- A PDF is a layout format, not a data format — no cells, no rows, no columns. Copy-paste scrambles because the paste is faithfully reproducing positioned fragments
- A table-aware extractor rebuilds the grid from the ruled lines the producer drew, so merged cells, multi-page tables and borderless layouts survive
- Scanned (image-only) PDFs need OCR first -- this tool reads selectable text, nothing uploads anywhere
- Numbers are written as real numbers, so SUM works on open. Only odd formats (separators, currency symbols, brackets) still need Text to Columns
- Bank statements, invoices, and financial reports extract into organized columns for accounting and analysis
- For recurring conversions, use Excel's Power Query to create refreshable PDF connections
- Text-based PDFs convert cleanly; for scans, use clear 300 DPI output and OCR before converting
