How to integrate Alphacast with Excel?
Excel allows 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 TSV/CSV/XLS download links from the Dataset
When you navigate through Datasets in Alphacast, you will find a Download link. If you filter variables, download links will consider variables selection, and only filtered variables will be downloaded. You will now find an option to download Tab Separated Values (TSV), which can make it easier to embed data into Excel:
Right-click on the TSV, CSV, or Excel Download link, and choose "Copy Link Address". You will notice the URL already has your personal api_key, and should not be shared publicly with other users, outside your team.
Step 1 BIS. Getting TSV/CSV/XLS download links 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 that link and follow Step 2
Step 2. Now go to Excel, select Get Data -> From Other Sources -> From Web, and enter the URL you copied from the Alphacast website.
The Excel team published a super easy video, describing how to do it:
How to connect Alphacast data to Google Sheets?
It is VERY easy to connect any Alphacast dataset to Google Sheets and leave it connected to update itself.
Step 1. Find the data that interests you.
For example, the following dataset has the blue dollar of Argentina
Step 2. Filter the information you want to use. Google Sheet limits the information that can be downloaded to a maximum, so it is convenient to apply the filters you need.
Step 3. In Download press the right button where it says CSV and copy the address.
It will look like this
Step 4. In google sheets type +IMPORTDATA() and paste the URL the URL you copied earlier.
Step 5. Change the format of the date column to date