XML, or Extensible Markup Language (XML), is markup language that is used for data transfer between parties.
It has never been more simpler to convert XML to Google Sheets and display the data in a spreadsheet. Use the Google Sheets Add-on KPIBees and with just a few clicks, you can import XML.
Go to the KPIBees Gsuite Marketplace listing and install the Google Sheets Add-on.
STEP 2
Grant access to KPIBees on your Google account – we are GDPR compliant!
STEP 3
Open any google spreadsheet and go to Add-ons in the page menu and click on Launch.
STEP 4
Click on the XML integration.
STEP 5
Add a Name to the XML query and add the XML data source url in the Data Url field.
STEP 6
Add a Name to the query and add the XML data source url in the Data Url field. If require a simple XML query, this setup should be enough to get your result by pressing Save!
STEP 7 (optional)
If your XML url is not accessible via url – so basically behind a login wall – you need to add Request Header parameters. To test whether your url is accessible, open it in an incognito browser and check whether your XML is displayed.
STEP 8
Run the query and import the XML into Google Sheets. The XML query result will be placed starting with your selected spreadsheet cell as illustrated below.
XPath is a query language that can be used to extract data from an XML file. It should be used to fetch only certain parts of your XML and import those parts into Google Sheets. To find out more about XPath syntax, check out this resource.
Combine JSON data in spreadsheet reports with:
Google Spreadsheets
