Someone emails you a financial report. The numbers you need are right there on page four, neatly arranged in a table — but it is a PDF, so you cannot sort, filter, or sum anything. You could retype everything into a spreadsheet, but that takes time, it is error-prone, and it is honestly just tedious when the data is sitting right in front of you in a format you cannot work with.
Converting a PDF to Excel extracts that table data directly into a spreadsheet, so you can start working with the numbers immediately. It takes seconds and requires no software, no account, and no cost.
When to convert a PDF to Excel
Converting a PDF to Excel makes sense any time you need to work with the data rather than just read it:
- Financial reports — extracting revenue, cost, or budget figures from a quarterly or annual report so you can build your own analysis or charts
- Invoice line items — pulling itemised charges from supplier invoices into a spreadsheet for reconciliation or cost tracking
- Survey or research results — extracting response data from a PDF report produced by a survey tool or research firm
- Price lists and catalogues — getting product names, SKUs, and prices out of a supplier catalogue so you can compare options or import them into another system
- Bank or brokerage statements — extracting transaction history or portfolio data into a spreadsheet for personal accounting or tax preparation
- Government or regulatory data — many agencies publish statistical tables in PDF format; converting saves hours of manual data entry
How to convert PDF to Excel for free
Filero's PDF to Excel converter uses purpose-built table extraction to pull structured data from PDF files accurately. No account required.
- Open the PDF to Excel tool.
- Upload your PDF by clicking or dragging it onto the page.
- Click Convert and wait a few seconds while the tool scans the document for tables.
- Download your Excel (.xlsx) file.
- Open it in Microsoft Excel, Google Sheets, or LibreOffice Calc and start working with the data.
Each table found in the PDF is placed on its own sheet in the Excel workbook, labelled by page number. If your PDF has three tables across two pages, you will get three separate sheets in the output file.
How the table extraction works
Under the hood, the converter uses tabula-py, a Java-based table extraction library developed specifically for pulling structured data out of PDF files. It is the same technology used in data journalism and government data analysis workflows around the world.
Tabula recognises two types of table structures. Bordered tables — where cells are separated by visible lines or boxes — are straightforward to detect because the grid provides clear boundaries between data. Borderless tables — where data is aligned by whitespace alone without any visible lines — are more challenging but tabula handles them using a separate detection algorithm that identifies column alignment patterns. Filero runs both detection modes automatically and uses the result that captures more of the data from your file.
This two-mode approach means you do not need to know what kind of table is in your PDF. The tool figures it out and gives you the best output it can produce.
Getting the best results from PDF to Excel conversion
The cleaner the source data, the better the extraction result. Here is what works well and what does not:
- Works best — digital PDFs with clearly structured tables, consistent row and column alignment, and data that was originally generated from a spreadsheet or database
- Also works well — government reports, financial statements, and research tables that follow a standard grid format, even without visible borders
- May need cleanup — tables with merged cells where one header spans multiple columns, tables that continue across multiple pages, or tables embedded inside text-heavy layouts
- Does not work — scanned PDFs where the table is an image rather than text data. If you cannot highlight the numbers in your PDF, it is scanned and Excel extraction will not work. Use PDF to Word with OCR as an alternative and then paste the data into Excel manually.
- Does not work — tables that are images or screenshots embedded in an otherwise digital PDF (same limitation as scanned pages)
Cleaning up the Excel file after conversion
Even a good conversion usually benefits from a few minutes of tidying. Here are the most common things to address:
- Numbers stored as text — cells may contain numbers formatted as text strings, visible as a small green triangle in the corner of the cell. Select the column, click the warning icon, and choose "Convert to Number" to make them usable in formulas.
- Column widths — auto-fit your columns by selecting all cells and double-clicking any column border so the content is readable without scrolling horizontally.
- Merged header rows — if a table had a multi-row or merged header in the PDF, it may come through as separate rows. Clean these up manually to create a single, consistent header row.
- Extra blank rows or columns — borderless table detection sometimes picks up whitespace as a column separator. Delete any empty columns and rows that are not part of your actual data.
- Currency symbols — values like "$1,234.56" may arrive as text. Use Find & Replace to remove the dollar sign and commas, then convert to numbers.
Most of these fixes take under a minute once you know what to look for. For a clean, well-structured financial table, you may not need to do anything at all.
PDF to Excel vs PDF to Word — which should I use?
The answer depends on what you want to do with the content. Use PDF to Excel when your PDF contains tables, numbers, or structured data you want to calculate, sort, filter, or chart. The whole point is to get data into cells you can work with programmatically.
Use PDF to Word when your PDF contains paragraphs of text, headings, and prose that you want to edit or reuse — and it handles scanned PDFs with OCR, making it the right choice when Excel extraction cannot read the content. If your PDF is a mix of tables and narrative text, you can run both conversions and combine what you need from each output.
Frequently asked questions
Does it work on scanned PDFs?
Scanned PDFs — where each page is an image rather than real text — are not supported for Excel conversion, because the table extraction library needs actual PDF text data to work with. If your PDF is scanned, you have two options: try PDF to Word with OCR to at least extract the text, or use a dedicated OCR tool that specifically supports table detection in images.
Will all tables from the PDF appear in the spreadsheet?
The converter scans every page and extracts all tables it can detect, placing each on a separate sheet in the Excel file. Very small tables, tables without clear column alignment, or decorative table-like layouts may not be detected. If a table is missing from the output, it usually means the structure was not consistent enough for the extraction algorithm to identify reliably. In those cases, you can often copy the data from the PDF and paste it into Excel, though the formatting will need manual adjustment.
Is my file kept private?
Your file is uploaded to a secure server for processing and deleted immediately after you download the result. It is not stored, shared with third parties, or used for any other purpose. Financial and business data is often sensitive, and Filero handles it accordingly — your file exists on the server only for the duration of the conversion process.
The numbers came out as text — how do I fix this?
This is one of the most common things to clean up after conversion. In Excel, select the column containing the problem values — you will likely see a small green triangle in the top-left corner of affected cells. Click on one of those cells, then click the yellow warning icon that appears and choose "Convert to Number." If that option does not appear, use the Text to Columns feature (Data tab > Text to Columns > Finish), which forces Excel to re-evaluate the cell contents. For values with currency symbols or commas, use Find & Replace (Ctrl+H) to remove the symbols before converting.
Can I convert just one page of a multi-page PDF?
The tool processes the entire PDF and extracts all tables from all pages. There is not currently an option to select specific pages before converting. If you only need data from one page, the simplest approach is to delete the sheets you do not need from the Excel output after conversion. Alternatively, you can extract a single page from the PDF first — most PDF readers let you print or save individual pages as a new PDF — and then convert that single-page file.
What types of PDFs give the best Excel conversion results?
The best results come from PDFs that were originally generated from a database, spreadsheet, or reporting tool — think annual report PDFs exported from financial software, government statistics downloads, or research firm reports. These files have clean, consistent column alignment and real underlying text. PDFs created by scanning physical documents, or PDFs that are essentially design files with tables drawn as graphics rather than real text, will not produce usable Excel output. A quick test: if you can click on a number in the PDF and highlight it, the data is real text and should convert well.
Ready to try it?
Use Filero's free PDF to Excel tool. No account needed, works on any device.
Open PDF to Excel