Skip to content

How to copy a table from a PDF into Excel, including a scanned one

Turn the tables in a PDF into an Excel workbook with DocFila's PDF to Excel, and for a scanned PDF make it searchable first. Check every figure afterwards.

Open DocFila free

The short answer

Use PDF to Excel in DocFila's Converter. It finds the tables in a PDF that has selectable text and writes them into an .xlsx, each marked with its page number. If the PDF is a scan, choose Make searchable first, then convert. Always check the numbers against the page.

Works on: PDF to Excel runs on DocFila's conversion service, so you need to be online and signed in. It works in the web app, on iPhone and Android and in the desktop apps. The file is uploaded, converted and then deleted there.

What do you need?

What are the steps?

  1. Open the Converter. In the Tools tab open Converter, described as file format conversion. You can type pdf to excel in the search box.
  2. Choose PDF to Excel. Select the card PDF to Excel, which gives you the PDF's tables in an Excel workbook.
  3. Add the PDF. Choose the file, or drop it on the screen. The screen shows what the conversion accepts and a size limit.
  4. Handle a scan first. If the PDF is a picture, DocFila says it has no selectable text. Choose Make searchable first, let it read the pages, then come back to the converter with the searchable copy.
  5. Convert. Choose Convert. The screen says it is converting on DocFila cloud and notes that your file is uploaded, converted and then deleted.
  6. Save the workbook. Choose Save converted file to put the .xlsx where you want it, then open it in Excel, Numbers or DocFila's spreadsheet editor.
  7. Check the cells. Compare each table with the PDF. Look at merged headers, columns that run together and any value that should be a number.

What is worth knowing?

What DocFila does not do here

Only tables DocFila can detect in the PDF's own text are written. A scan must be made searchable first, and recognition errors in numbers carry through to the workbook, so verify totals by hand. Merged cells and unusual layouts can split into extra columns. The conversion needs a connection and an account, with a size limit shown on the screen, and cloud conversions are not offered where your organisation has blocked cloud features.

Where to go next

More pdf how-to guides

Questions

Can DocFila convert a scanned PDF table to Excel?

Yes, in two steps. Make the PDF searchable so the pages get a text layer, then run PDF to Excel on the result. Check the numbers, because recognition can misread digits.

Is my PDF kept on a server?

Yes, briefly. It is uploaded to DocFila's conversion service, converted, then deleted there. The screen says so before you convert, and you must be signed in and online to use it.

Why is every cell text instead of a number?

DocFila writes PDF cells as text so a value that begins with an equals sign cannot turn into a formula. Change a column to a number format after checking it.

What if the PDF has no tables?

The workbook would be empty, or the conversion would report that nothing was found. In that case use the PDF to Text conversion, or select and copy the text straight from the page instead.

Try it in DocFila

Free to start, no card needed.