How to use PDF to Excel

Extract tables and data from a PDF into an Excel spreadsheet.

What this tool is for

This tool helps convert PDF tables into Excel files so you can sort, filter, and analyze your data more easily.

Check whether your PDF contains a real table

PDF to Excel is intended to move table-like information into an XLSX workbook so that you can inspect rows and columns in a spreadsheet. Before uploading, zoom in on the PDF and see whether the text is selectable and whether the values line up consistently. A digitally created statement or price list with clear rows is a more promising starting point than a photograph of a printed page. A tidy-looking scan can still be only an image, and this conversion does not guarantee OCR of image-only text. If the figures cannot be selected in a reader, use a suitable OCR step first, then verify every extracted value.

Run the conversion and open the workbook

Choose the PDF to Excel tool, select the document, and start processing. The PDF is uploaded for conversion, so avoid sending highly sensitive material and use documents you are allowed to process. When the result is ready, download the XLSX file and open it in Excel or a compatible spreadsheet application. Treat the first workbook as extracted data, not as a finished financial model. Keep the source PDF open beside the spreadsheet so you can compare the original labels and values as you review. If the workbook does not open as expected, download it again and confirm that your spreadsheet application supports XLSX files.

Clean up rows, headings, and number formats

PDF pages are arranged for reading and printing; they do not always contain spreadsheet cells that can be copied directly. Extraction has to infer where a row ends, which values belong in a column, and whether a heading applies to one section or the whole table. Look for titles repeated at the top of each page, totals separated from the body, blank rows inserted between sections, and notes that have landed among the data. After comparing the contents, rename column headings if needed and apply appropriate date, currency, or number formats. Formatting a value as currency does not verify that the extracted amount is right, so check the underlying digits first.

Validate the figures before using formulas

A conversion can save time on data entry, but a spreadsheet makes errors easier to propagate if nobody checks it. Compare a sample from the first, middle, and last rows, then check every important total against the PDF. Watch for minus signs, decimal points, leading zeroes, dates that were interpreted in a different order, and account numbers split across cells. If the table continues over several pages, confirm that no rows were omitted or repeated at the page boundary. Only after the source values are right should you sort, filter, calculate, or create charts. Keep the original PDF available as an audit reference.

Handle multi-page and irregular tables

Tables with repeated column headings, footnotes, merged cells, or separate subtotals can be difficult to turn into one clean data range. Decide in advance whether you want each page kept as a separate section or whether you plan to combine the rows yourself after conversion. A report might place explanatory notes directly beside its figures; those notes are useful context but do not belong in a numeric column. For a small table, manual correction may take less time than trying to force inconsistent source formatting into a uniform structure. For a large or consequential dataset, compare the whole output systematically rather than checking only a few convenient rows.

Questions to ask before relying on the sheet

If the workbook is blank or missing values, check whether the source PDF has selectable text and a clear table structure. If the original page contains only a scan, OCR may be needed before extraction. Do not expect an Excel sheet to reproduce the PDF design: the goal is usable rows and columns, not a page-perfect layout. A converted workbook is a starting point for analysis, not proof that each value is accurate. Review totals, units, and date ranges before sharing results with a colleague or using them in a report. For confidential statements or records, check the service's privacy terms and your organization's rules before uploading them.

Keep a clean, auditable source

When the extracted data will be used for work, keep the original PDF and the untouched converted workbook together. Add a note to your working copy about the source document and the date you extracted it, especially if statements or reports are updated regularly. This helps distinguish a checked version from a later, similar-looking file. Avoid editing the original PDF or changing figures during cleanup without recording why. If another person needs to review the spreadsheet, they can compare specific rows against the page that produced them. That small bit of organization saves time when somebody asks where a value came from.

A practical example: checking an invoice table

For an invoice, compare the supplier name, invoice number, dates, line descriptions, quantities, unit prices, tax, and final total. A subtotal might be printed beside or below the main table and can be confused with another row if the page uses irregular spacing. Check a multiplication or sum independently where the amount matters. Keep currency symbols and units clear; a number without its unit can be misleading even when every digit is correct. If the workbook will feed another system, check that identifiers have not lost leading zeroes and that dates use the format that system expects.

Before you filter or share

Sort and filter only after removing repeated page headings and separating explanatory notes from the actual records. Otherwise, a heading can be treated like data and appear in the middle of a sorted list. If you add formulas, test them on a small sample whose correct answer you can calculate from the PDF. When sharing a workbook, consider whether it contains more extracted rows than the recipient needs. Store a reviewed version separately from your cleanup copy and label it clearly. These habits do not make extraction infallible, but they make your work easier to check and reduce avoidable spreadsheet mistakes.