Complete Conversion Reference

PDF to Excel Guide: Extract Tables & Data

PDF data locked in uneditable format? Convert PDF tables to editable Excel spreadsheets with AFFLIGO's free tool -- extract bank statements, invoices, and reports right in your browser.

100% Private Conversion OCR First for Scanned PDFs 50MB, 10 Files Max
By Karan Kumar Updated October 22, 2026 20 min read
Quick Summary

01Why 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 ExcelWhat actually happened in the PDFHow to fix it
One row became twoA 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 AThe 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 orderThe 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 wrongThe 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 vanishedThey 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 textCopied 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 own PDF import has the same blind spot

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.

What a real table-aware extractor does instead

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 youWill copy-paste work?Will a table-aware extractor work?
Bordered table, one page, one header rowUsually — this is the easy caseYes, near-perfectly
Bordered table with merged header cellsHeader lands as one wide cell, data misalignedYes — colspan/rowspan are handled by the lattice
Borderless table, columns aligned by whitespaceNo — everything lands in column AUsually — the clustering pass finds the column gaps
Table spanning two or more pagesNo — you get one page, and a repeated headerYes — pages are merged and the repeat is dropped
Two or more tables on one pageThey merge into one messYes — each ruled region becomes its own sheet
Scanned or photographed PDFNothing at all — there is no text to copyNo — there is no text layer. Run OCR PDF first, then convert the result
Totals row outside the ruled boxPresent, but in the wrong placeMay be missed by the line detector — verify it by eye

02Why 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.

Common Scenario

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.

03How 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.

01

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.

02

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.

03

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.

04

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.

04AFFLIGO 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.

05Step-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.

01

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.

PDF upload dropzone highlighted in the AFFLIGO PDF to Excel converter
02

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.

Convert button with progress ring at 80 percent and converting status highlighted
03

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.

Download button enabled with 100 percent progress ring and done status after PDF to Excel conversion

06Extracting 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.

07Scanned 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.

01

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.

02

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.

03

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.

Scan Quality Tip

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.

08Converting 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.

01

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.

02

Review Extracted Data

The converter extracts transaction dates, descriptions, debits, credits, and running balances into separate columns. Check that all transactions are captured correctly.

03

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.

09Invoices 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.

10Preserving 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:

ProblemCauseFix in Excel
Numbers stored as textPDF stores numbers as text charactersData > Text to Columns > Finish. Or use =VALUE(A1)
Data in one columnNo clear column boundaries detectedData > Text to Columns > Delimited > choose delimiter
Extra spacesPDF padding for alignment=TRIM(A1) formula to remove extra spaces
Merged cells wrongPDF merged cells don't map to ExcelManually unmerge and fill down with data
Headers misalignedMulti-level headers confuse detectionManually adjust header rows after conversion
Currency symbols$, Rs., EUR symbols embedded in textFind & Replace to remove symbols, then format as currency
Post-Conversion Checklist

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.

11Multi-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.

12Batch 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.

01

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.

02

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").

03

Download Results

Download each converted .xlsx file individually. Files are downloaded sequentially with a short delay between each to ensure all downloads complete.

13Using 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.

01

Open Excel's Data Import

In Excel, go to Data > Get Data > From File > From PDF. This opens the Navigator dialog showing detected tables.

02

Select Tables

The Navigator shows all detected tables and pages. Preview each table, select the ones you want, and click Load or Transform Data.

03

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.

FeatureAFFLIGO OnlineExcel Built-In
PriceFreeRequires Microsoft 365
Scanned PDFsOCR first, then convertNo OCR
RefreshableNo (one-time)Yes (Power Query)
File Size50MB, 100 pagesNo limit
InstallationNone (browser)Excel required

14Google 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:

01

Convert PDF to Excel

Use AFFLIGO to convert your PDF to .xlsx format. Download the converted file.

02

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.

15Best Practices and Tips

Getting the best results from PDF to Excel conversion.

01

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.

02

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.

03

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.

04

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.

16Common 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.

17Online vs Desktop vs AI Converters

Comparing different approaches to PDF to Excel conversion.

FeatureAFFLIGO (Online)Adobe Acrobat ProExcel Built-InPython (tabula)
PriceFree$22.99/monthMicrosoft 365Free (open source)
InstallationNoneDesktop appExcel requiredPython required
OCR SupportOCR first, then convertYesNoVia Tesseract
Batch Convert10 filesUnlimitedOne at a timeScriptable
File Size50MB, 100 pagesNo limitNo limitNo limit
PrivacyPrivate (browser)LocalLocalLocal
Ease of UseVery easyModerateModerateTechnical

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.

18Security 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.

Sensitive Documents

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.

19Frequently Asked Questions

Answers to the most common questions about PDF to Excel conversion.

Load your PDF into AFFLIGO's PDF to Excel tool, click Convert, and download the .xlsx file. No signup, no email, no payment required. The tool extracts tables and text automatically.
No — this tool reads selectable text. OCR image-only scans first (try our OCR PDF tool), then convert the searchable PDF here.
The converter extracts table structure and data. Some formatting like colors and fonts may not transfer perfectly. For best results, clean up the Excel file after conversion using Text to Columns and VALUE formulas.
Yes. AFFLIGO supports up to 10 PDF files at once with a 50MB limit per file (100 pages max). Each file is compatibility-scanned, converted individually, and downloaded separately.
XLS is the older Excel format (Excel 97-2003) with limited rows and features. XLSX is the modern format (Excel 2007+) based on XML, supporting over 1 million rows and better compression. AFFLIGO outputs XLSX.
Select the column, go to Data > Text to Columns > Finish. Or use the VALUE formula: =VALUE(A1). This converts text-formatted numbers into actual numbers for calculations.
Merged title rows and colspan cells confuse row detection. The extractor maps merges where the grid is clean, but decorative merged headers may land as separate rows. For bank statements, convert a page range without the letterhead — data tables extract cleanest alone.
Yes. Conversion happens entirely in your browser — files never leave your device. Nothing is uploaded, stored, or tracked.
If your PDF contains multiple tables, the converter extracts all of them. After conversion, delete the unwanted rows/sheets in Excel to keep only the table you need.
You can convert PDFs that have printing restrictions, but if the file requires a password to open, you must enter the password before the converter can process it.
After converting multiple PDFs, open each .xlsx file in Excel, copy the sheets, and paste them into a single workbook. Or use the Consolidate feature (Data > Consolidate) to merge ranges.
Complex layouts, merged cells, and irregular tables may not convert perfectly. Clean up in Excel: use Find & Replace for spacing, TEXT TO COLUMNS for split data, and manually adjust merged cells.
The maximum file size is 50MB per file (100 pages max). For larger files, try splitting the PDF first using AFFLIGO's Split PDF tool, then convert each section separately.
Open the PDF and try to select a number with your cursor. If text highlights and copies, it is digital with a real text layer. If only a box draws with nothing highlighted, the page is an image and needs OCR.
Yes. Amounts export as real spreadsheet numbers you can sum, sort, and format — not text trapped in cells. If a column arrives as text, use Excel's Text to Columns or VALUE function to convert it.
Because a PDF is a layout format, not a data format. It stores each glyph with an x/y coordinate, in paint order, and it has no concept of a cell, a row, or a column — so it never guarantees that a value belongs to exactly one cell of a rectangular grid. When Excel receives the pasted fragments it has to guess the columns from whitespace, and it guesses wrong in predictable ways: a cell whose text wrapped onto two lines becomes two rows, a borderless table collapses into column A, cells painted out of order stay out of order, and a totals row outside the ruled box is never included. A table-aware converter rebuilds the grid from the ruled lines the producer drew instead of from the text stream. Full explanation.
PDF to Excel conversion extracts the tables, text, and data held in a PDF document and writes them into an editable .xlsx workbook, so you can use formulas, sorting, filtering, and charts on data that a PDF cannot support. Text-based PDFs (from Word, Excel or InDesign) contain selectable text and convert cleanly. Scanned PDFs are images of text and need OCR first. The output is a standard .xlsx file supporting over 1 million rows, formulas, charts, and full spreadsheet functionality.

Convert Your PDF to Excel Now

Extract tables, bank statements, and data into editable spreadsheets. Free online, no signup, 100% private.

Open PDF to Excel Tool

Key Takeaways

Karan Kumar, Founder of AFFLIGO

Karan Kumar

Founder & Web Developer at AFFLIGO

Karan built AFFLIGO's PDF to Excel engine with lattice table detection, merged-cell mapping, numeric cells and multi-sheet output — all client-side. He tests every release on bank statements and invoices, checking column alignment cell by cell before calling an extraction clean.

Last reviewed: October 22, 2026