How to integrate Alphacast with Excel and Google Sheets?
How to integrate Alphacast with Excel and Google Sheets?
Excel and Google Sheets allow adding data from different sources. Here you can find an alternative way to embed data into Excel, by using our TSV data source:
Step 1. Getting the download link
From a Dataset
First of all, filter the information you want to use. Excel and Google Sheet limit the information that can be downloaded to a maximum, so it is convenient to apply the filters you need.
Once you've done the filter, click on the Download button. Then select the format you want: TSV (for integrations with Excel for Mac), CSV, or Excel and choose Copy Link. You will notice the URL already has your personal API key (which should not be shared publicly with other users, outside your team).
From a Pipeline
Within any pipeline, you can create a Data Snapshot to get a Download Link for the data up to that point. Use the XLSX Download link and follow Step 2.
Step 2. Integrating to Excel or Google Sheets
Excel
Now go to Excel, select Get Data > From Other Sources > From Web, and enter the URL you copied from the Alphacast website. The following GIF guides you through a successful Excel integration!
Google Sheets
It is VERY easy to connect any Alphacast dataset to Google Sheets and leave it connected to update itself. In Google Sheets type =IMPORTDATA() and paste the URL (the one copied earlier) inside the formula.
=IMPORTDATA("LINK CSV")
Change the format of the date column to date.
If the regional settings of your spreadsheet are in Spanish, you have to type =IMPORTDATA() and paste the URL (the one you copied earlier) inside the formula, and add ;",";"en-US" at the end.
=IMPORTDATA("LINK CSV";",";"en-US")