You can import or export a connection using the Import Connection and Export Connection menus from the Manage Connections drop-down field on the Connections panel.

• Import Connection: Click Import Connection from the Manage Connections drop-down icon and select a connection file from your local device. Once you import the connection file, you can view the connection in the Connection panel with a check box beside it. Select the check box and click Import to add the connection to the list of connections in the panel. The add-in copies the connection information you can use as a new connection. With the import feature, you do not have to enter the connection information to add a new connection.
• Export Connection: The export connection button exports an existing connection which you can import later. Clicking Export Connection opens a check box beside each connection in the connections list. You can select the connection you wish to export. Multiple selections are allowed. After you select the connection, click Export. Once the connection file is exported, you can view that the add-in for Excel downloads the connection file (*.json file) to your local device. The exported connection file is named spreadsheet_addin_connections.json.