Overview

You can export your data into any XML compatible application, including Microsoft Excel or Google Sheets, using FogBugz XMP API in just three easy steps.

Solution

1. Create an API token.
2. Create a URL for listing your data using the search XML API. You might need to set your filter first.
3. Feed this URL to your target application.
   1. In the case of Microsoft Excel: File -> Open, paste the URL. Excel will download the XML for you.
   2. In the case of Google Sheets use the IMPORTXML function.