Google Sheets - Import CSV

Owned by Thomas Sherman (Deactivated)
Last updated: Sept 07, 2018

Instructions for importing Projector report data into Google Sheets.


You can import your data into a Google spreadsheet by using Google's importData feature.

  1. Make sure that you have a working report URL that is retrieving CSV

  2. Add the querystring parameter dateformat=googledocs

    Your final URL should look something like this:

    https://app2.projectorpsa.com/report/code/variance?format=csv&UserName=YOUREMAIL&AccountCode=MYACCOUNTCODE&AuthToken=AAAAAAAA-BBBB-CCCC-DDDD-EEEEEEEEEEEEE&columnheaders=firstrow&dateformat=googledocs

  3. Test your URL by cutting and pasting it into your web browser. The browser should download a csv file.
  4. Select the first cell in the Google Docs spreadsheet.
  5. In the value field, enter the following, replacing "url" with your own URL


Google Spreadsheet
=importData("url")