How to copy a PDF table to Google Sheets™ - The Easy Way

Trying to copy a table from a PDF into Google Sheets™ can be tricky.

Our Text To Table Converter Add-On for Google Sheets™ simplifies this process.

Example: EUROSTAT Table

We’ll use this table from a EUROSTAT PDF (Link to PDF):

(Source table in the PDF)

Steps to Copy the Table:

1. Copy from PDF: Select the table data in your PDF viewer and copy it (Ctrl+C / Cmd+C).

2. Paste into Google Sheets™: In your Google Sheets™ document, right-click and choose Paste without formatting. You’ll get plain text like this:

3. Convert to Table: Select the pasted text. Go to Extensions > Text To Table Converter > Text To Table.

Result:

The Add-On instantly creates a proper table:

(Clean table created by the Add-On)

Optional Formatting:

For quick styling, select the table, then go to Extensions > Text To Table Converter > Table Quick Format (Blue) (or another style).

(Table after applying a quick format)

---

提示

Works in Slides™ and Docs™ too!

The same easy process demonstrated here for Google Sheets™ also works seamlessly in Google Slides™ and Google Docs™.

Simply copy the text from your PDF, paste it without formatting into your Presentation or Doc, select the text, and run the Text To Table Converter Add-On to create your clean table.

Get the Add-On:

Haven’t installed it yet? Get the Text To Table Converter free

Install Here