Import / Export Configuration Files

Importing and exporting configuration files for the API Connector add-on for Google Sheets allows you to share or duplicate your requests by copying request configurations from one sheet to another. The request configuration includes API URLs, headers, and output options.

Please note: importing is available on all plans, but exporting is a pro feature; please upgrade to access.


Import File

To import a configuration file, please click on Add-ons > API Connector > Import/Export > Import File

You will be prompted to select a configuration file to import. Note that this file must be a valid API Connector export file.

All requests must have an output sheet, or they won’t be imported. If you’d like to automatically create these sheets during the import process, check the box saying ‘Automatically create new destination sheets’.

Export File

To export a configuration file, please click Add-ons > API Connector > Import/Export > Export File.

June 2020 update: Google Chrome now blocks downloads from iframes as described here, which interferes with the original Export File functionality of API Connector. Therefore please follow the updated instructions below.

This will produce a new sheet containing a JSON-formatted API Connector file of all the requests in your sheet.

A modal will appear prompting you to download this file to your computer. For Chrome, this download link will no longer work, so please click File > Download > Tab Separated Values to download the new sheet to your computer instead. (The file will only be recognized if it uses tab-separated values).

You can then import this file into other Sheets to re-create your requests.

Tips and Troubleshooting

  • As noted above, all requests must have an associated sheet. Requests without a sheet will not be imported. This means that you can restrict which requests get imported by not creating sheets for them.
  • If you want to create an exact duplicate of an existing sheet, click File > Make a copy in your existing sheet, and then import the request file into the copy. If you instead want to duplicate only the request configurations without existing data, start with a fresh, empty worksheet, and tick the ‘Automatically create new destination sheets’ checkbox before importing.
  • If your sheet already has a request with the same name, new requests will be imported in with a ‘_2’ appended to the name.

Leave a Comment