Sunday, February 20, 2022

importing data from pdf to google sheet

This page has lots of methods listed for importing tables from pdf documents to google sheets. To summarize:

  1. First use Google Docs to open the PDF, then copy-paste if data is seen to be in a table.
  2. If data is seen as delimited text in the Google Doc, save as text, find/replace the delimiter if needed, save as CSV and then upload to Google drive and open with Google sheets. 
  3. Using third-party tool PDF table extractor - in Google Drive, choose open with -> Connect more apps -> search for PDF table extractor
  4. Using online service online2pdf.com - using convert to Excel
  5. Other online services - pdfchef.com/pdf-to-excel.html , altoconvertpdftoexcel.com

No comments:

Post a Comment