How to integrate Alphacast with Excel and Google Sheets
Excel and Google Sheets allow you to add data from various sources. Below, we show you how to integrate Alphacast datasets into both tools.
Step 1. Getting the URL link from the dataset or pipeline
From a Dataset
First, filter the information you want to use from the Filter Data section and select the variables you need. Then, click on the Download button
Select the XLSX format to integrate into Excel, and choose Copy Link
You will notice that the URL you copied already contains your personal API key, which should not be shared publicly or with 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!
When new data is updated, you just need to click on "Refresh". To ensure the date format is not lost during the update, make sure the "Preserve Cell Formatting" option is enabled.
After you loaded the query into the sheet, go into the "Table Tools" tab and click "Properties":
The important setting is this one:
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")