Google Sheets - Import XML

Owned by Thomas Sherman (Deactivated)
Jun 26, 2017

Instructions for importing Projector report data into Google Sheets.

We recommend using CSV instead of XML if possible. CSV is much lighter weight than XML. See

 

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

  1. Make sure that you have a working report URL that is retrieving XML
  2. Add the querystring parameter dateformat=googledocs
  3. Add the querystring parameter columnheaders=firstrow if you want each column to be named
  4. Test your URL by cutting and pasting it into your web browser. The browser should display the XML.
  5. Select the first cell in the Google Docs spreadsheet.
  6. In the value field, enter the following, replacing "url" with your own URL
Google Spreadsheet
=importXml("url", "Report/Rows/Row")