Miguel Saez
- 2 minutes to read

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:

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.

dow 4.png

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).

dow 1.png

dow 2.png

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.

image.png

image.png

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!

chrome_uyIGgkuxvn.gif

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")

image.png

Change the format of the date column to date.

image.png

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")

Step 3. There is no step 3. Enjoy!

Related insights

  • martinamas
    - 5 minutes to read

    Read more...

    Alphatour: Navigating Global Financial Data with Alphacast

    Prepare for our worldwide data availability!

    Check out all Global Datasets here.

    Alphacast has become a crucial tool for those seeking up-to-date and high-quality information on global economy, market fluctuations and financial trends, as it provides easy and fast access to a wide variety of large-scale data sources, allowing for

  • martinamas
    - 3 minutes to read

    Read more...

    A short guide to US Inflation data

    Highlights of the Dynamic of US Inflation

    The United States has been struggling with a significant inflationary acceleration since the serie of international events, including the outbreak of the COVID-19, war between Ukraine and Russia, the global rise in energy prices, and the collapse of Silicon Valley Bank, among others. All

  • MaiaM
    - 3 minutes to read

    Read more...

    A short guide to Ecuadorian macro and financial data

    Interested in activity, prices, monetary, fiscal, external sector, and financial data for Ecuador? There are loads of datasets, available in both the Central Bank of Ecuador (BCE) and **National Institute of Statistics (

  • flor
    - 4 minutes to read

    Read more...

    A short guide to Chilean macro data

    Interested in activity, prices, monetary, fiscal, external sector, and financial data for Chile? There are loads of datasets, see for example this Repository which has official statistics from INEI and BCRP. However, this short guide will help you find the our "must-see" datasets.

    Chile Country Profile Dashboard

    The starting point is

  • MaiaM
    - 3 minutes to read

    Read more...

    A short guide to Uruguayan macro and financial data

    Interested in activity, prices, monetary, fiscal, external sector, and financial data for Uruguay? There are loads of datasets, see for example this Repository which has oficial statistics from from different sources, including both government statistics and datasets produced by private entities. If you are looking for data about Uruguay you'll