/
Google Sheets - Import CSV

Google Sheets - Import CSV

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

  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")

Related content

Report Web Services
Report Web Services
More like this
Web Services
More like this
Getting Started with Web Services 2.0
Getting Started with Web Services 2.0
Read with this
Excel - Import CSV
Excel - Import CSV
More like this
Google Sheets - Import XML
Google Sheets - Import XML
More like this
Power BI - Import CSV
Power BI - Import CSV
More like this