How to copy PDF tables to Excel

How to copy PDF tables to Excel

Have you ever tried to copy a PDF table to Excel? Then you know it can be a time-consuming process. You might need to manually copy each cell or spend a lot of time fixing formatting issues. If the document is scanned you might not be able to copy anything at all!

Thankfully there’s an easier option. With DocuClipper you can quickly extract tables from PDF documents and copy them to Excel or Google Docs Spreadsheets automatically.

Step 1

  • Go to docuclipper.com.
  • If you don’t have an account, create one.
  • Click on “Add Document” on the left sidebar.
  • Select “Generic”.
  • Give the template a name, e.g. “tables”.
  • Drop the PDF, click “Next”.
DocuClipper | Copy PDF tables to Excel - Step 1

Step 2

  • Click and drag to draw a box around the table you want to extract.
DocuClipper | Copy PDF tables to Excel - Step 2

Step 3

  • Select table.
  • Optionally, give the table a name.
  • Click “Next”.
DocuClipper | Copy PDF tables to Excel - Step 3

Step 4

  • Select the number of columns.
  • Click and drag the blue bars to mark the start of each column.
  • Click “Next”.
DocuClipper | Copy PDF tables to Excel - Step 4

Step 5

  • Specify whether the first row is the header.
  • Optionally change the type of each column. Supported types are text (default), number, currency and date. Choosing the right type can improve extraction accuracy, especially for low-quality scans.
  • Click on “Save Field”.
DocuClipper | Copy PDF tables to Excel - Step 5

Step 6

  • Download the table as an Excel file.
  • Or create a Google Docs Spreadsheet.
DocuClipper | Copy PDF tables to Excel - Step 6

Get product announcements
and automation tips

Infrequent updates. Unsubscribe at any time.