Skip to main content

How to import a PDF table into Google Sheets

By January 18, 2019Video

In less than 12 minutes, learn how to take a PDF table and import it into Google Sheets in order to change the data, create charts, or reconvert it to another format such as Microsoft Excel .xlsx. Note that it’s a complicated workaround involving other tools in the Google Suite (including Google Drive and Google Docs and text and CSV files), and will only work with simple PDF tables – complex tables, or mixed tables and other content on the PDF page can’t easily be converted to PDF using this method. This video also shows how to handle errors in the import process, such as mismatched columns and rows. The PDF to Sheets tutorial is a huge time-saver for power users, accountants, bookkeepers, MBA students, and others who want to save time with Google Sheets. This short G Suite video is narrated by the author of Google Drive and Docs In 30 Minutes.