How to copy a PDF table to Google Sheets™ - The Easy Way
Copying tables from PDFs to Google Sheets™ often breaks formatting. Learn how to easily convert PDF table data into a clean Google Sheets™ table using the Text To Table Converter Add-On.
Maikki
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:
- Copy from PDF: Select the table data in your PDF viewer and copy it (Ctrl+C / Cmd+C).
- Paste into Google Sheets™: In your Google Sheets™ document, right-click and choose Paste without formatting.
You'll get plain text like this:
- 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 Styles and choose a preset.
*(Table after applying a quick format)*
Tip: 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
Supercharge your Google Docs™ experience even further! If you work with tables and text frequently, our Add-On can save you countless hours.
Get the Add-On - Free
Text To Table Converter
Convert PDF tables for free: Use the free Text To Table Converter add-on to turn pasted PDF text into clean tables.
Next Step: Create Documents Even Faster
- Create New Google Documents in Seconds with this Shortcut - Learn a super-fast browser shortcut to instantly open new Google Docs, Sheets, and Slides, saving you clicks every time you start fresh.