Google Drive and Docs Tips

Click for larger image and screenshots

Data import wizard for PDF to Google spreadsheet

A handy tool to help you copy and paste table data from a PDF into a Google Spreadsheet.

Copying a table from a PDF and trying to paste it into a Google Spreadsheet is not straightforward. If you have tabular data from a PDF that you want to paste into a Google Speadsheet, it will all end up as a single column.

This tool turns a table in a PDF - which uses space or tab delimited text - into an HTML table which will show correctly in a Google Speadsheet.

Simply copy and paste the table content from your PDF into the box below and click Clean. Then copy the Table Markup content into your Google Spreadsheet.

Comments/Feedback

Thierry Vanoffe

merci ! Thierry

08 April at 18:37 • Reply to this comment • Edit

Anne Johnstone

This still didn't work for me...

07 April at 05:05 • Reply to this comment • Edit

Anne Johnstone

This still didn't work for me...

07 April at 05:05 • Reply to this comment • Edit

Lark Lindig

The clean version is still a mess and table is not in proper lines. What am I doing wrong?

13 December at 09:32 • Reply to this comment • Edit

Miguel Plaza

how do I copy the table markup into a google spreadsheet? Tried to copy/paste but nothing happens

02 November at 14:01 • Reply to this comment • Edit

Mark Williams Hi Miguel - it will work if you use the keyboard copy/paste - ctrl-c and ctrl-v.

02 November at 14:08 • Edit