Google Sheets - Import CSV

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

3. Add the querystring parameter columnheaders=firstrow if you want each column to be named
   
   

   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

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

=importData("url")