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

   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

=importData("url")