Live Connector to Excel or Google Sheets
Export Sightfull's live data and metrics directly into Excel or Google Sheets for seamless analysis and reporting.
Why Use Live Export?
- Automate Processes: Export data to reports or presentations with just a few clicks. No more manual exports before meetings; always have the updated data.
- Stay Updated: Ensure your data is always current and up-to-date, allowing you to create custom analyses wherever you need.
Accessing the Feature
Ensure you have the necessary permissions and have generated an API token (instructions here). Save your Client ID and Secret Key for use in the export process.
The Export button can be found on any metric page within the metric table section.
Exporting to Google Sheets
Steps
- Click the Export button and choose Google Sheets Formula.
- The formula will be copied automatically.
- In Google Sheets, click on the desired cell and paste the formula.
- Replace
[Client ID]
and[Secret Key]
with your token details (remove brackets). - Press Enter to populate the sheet with Sightfull’s data.
Exporting to Excel on a Mac
Steps
- Click the Export button and choose Excel Power Query.
- The query will be copied to your clipboard.
- In Excel, go to Data > Get Data (Power Query).
- Choose Blank Query and paste the copied code.
- Click Next and configure the connection.
- Select Basic authentication and enter your Client ID and Secret Key.
- After the data loads, click Close & Load to import it into your workbook.
Exporting to Excel on a Windows PC
Steps
- Click the Export Live Data button and choose Excel Power Query.
- The file will be copied to your clipboard.
- In Excel, go to Data > Get Data > From Other Sources > Blank Query.
- Paste the copied code and click Done.
- Edit credentials, choose Basic authentication, and enter your Client ID and Secret Key.
- After the data loads, click Close & Load to import it into your workbook.
Conclusion
Thanks to the Live Connector feature, you can now export Sightfull data directly to Excel or Google Sheets, ensuring that your data is always up-to-date and ready for analysis and reporting. This feature streamlines the process of exporting data and ensures that you have the most current data available for your analysis and reporting needs.