ShreePrati logoShreePrati
PDFFile

PDF to Excel

Reconstruct rows and columns from a PDF’s positioned text and export a genuine .xlsx workbook, one worksheet per page. Works best on digitally generated, table-like PDFs.

Drag & drop your PDF

or choose a file below

PDF · up to 50 MB

How to convert PDF to Excel

Upload a PDF. The tool reads the positioned text on each page, reconstructs rows and columns, and builds an .xlsx workbook with one worksheet per page.

Works best on digital PDFs

Table detection relies on selectable text. Scanned or image-only PDFs contain no text to extract — run OCR first for those.

Step-by-step: PDF to Excel

  1. Select or drop a PDF into the upload area. The file opens in your browser and its page count is shown.
  2. Click Convert to Excel. A progress bar advances as the text on each page is extracted.
  3. When the conversion finishes, check the number of sheets and the file size on the result card.
  4. Click Download .xlsx to save the workbook. It keeps your original file name with an .xlsx extension.
  5. Choose Convert another PDF to start again with a different file.

How rows and columns are rebuilt

A PDF does not store tables as cells; it stores pieces of text at exact positions on the page. The converter reads those positions and groups pieces that sit on the same line, within about 4 points vertically, into one row. Each row is then ordered from left to right. Text fragments separated by a narrow gap are joined into a single cell, while a wider gap starts a new column. Clearly spaced columns therefore become separate cells, and words that belong to the same phrase stay together.

What the Excel file contains

  • One worksheet per PDF page, named Page 1, Page 2 and so on, so a 12-page PDF produces 12 sheets.
  • Cell values as plain text exactly as they appear in the PDF, including numbers, dates and currency symbols.
  • No formatting, merged cells, colours, images, charts or formulas — only the text content.
  • Pages without any text become an empty sheet, so sheet numbers stay aligned with page numbers.

Where PDF to Excel helps most

  • Bank and credit card statements, where each transaction sits on its own line with date, description and amount columns.
  • Invoices, price lists and order summaries exported from accounting or billing software.
  • Reports and timetables that were saved as PDF but now need sorting, filtering or totals.
  • Data tables from research papers or official publications that you want to chart or analyse.
  • Less suitable: forms, letters and multi-column articles, where the text is not arranged in a grid.

Tidying the result in Excel

Because every value is written as text, numbers may need converting before you can total them. In Excel, select the column and use Data → Text to Columns, or multiply the values by 1, to turn text into numbers. A header that wraps onto two lines in the PDF may appear as two rows; combine them by hand. When a value lands in the wrong column, the PDF usually used uneven spacing, and a quick cut and paste fixes it. Finally, delete repeated headers and page footers captured from each page.

Troubleshooting

  • "No selectable text was found": the PDF is a scan or image. Run it through OCR PDF first, then convert the result.
  • Several columns merged into one: the table is very tightly spaced, so neighbouring values were joined into one cell. Split them with Text to Columns.
  • Password-protected files: remove the password with Unlock PDF before converting.
  • Long documents: every page is processed in your browser, so large files take longer. Keep the tab open until the download appears.

Frequently Asked Questions

Digitally generated, table-like PDFs where the text is selectable. Scanned documents will not produce usable tables.

Related Tools