How to integrate Alphacast with Excel for Mac?

You will need the complete URL for the dataset that you want to integrate, which you can find by clicking the Download button and then copying (not downloading!) the URL attached to a TSV file.

imagen1.png

Alternatively, you can use the Data Snapshot link from any pipeline. Remember to choose the TSV link.

imagen_2.png

Step 2. Creating a query file

Open a Word file and paste the URL link. Save the document with the “.txt” extension (text without format), not as a Word file. When asked about text codification, choose MS-DOS.

imagen3.png

After saving the file, manually change its extension from “.txt” to “.iqy”.

Step 3. Integrating with Excel

Open a new spreadsheet, go to “Data”, then “Import External Data” and click on “Execute Web Query”. Excel will require you to choose a query file (those with “.iqy” extension), so search for the file you generated previously and open it.

imagen4.png

That’s it! Excel should have successfully integrated an Alphacast dataset/pipeline to your spreadsheet. Remember to click on “Refresh” to obtain data updates when needed.

imagen_5.png

matias

Written by

matias

Economist. Doing macro research @Seido. Building something different @Alphacast

Related insights

  • 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, 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 Ecuador you'll

  • 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

  • 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

  • Read more...

    A short guide to Mexican macro and financial data

    Interested in activity, prices, monetary, fiscal, external sector, and financial data for Mexico? 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 Mexico you'll

  • Read more...

    A short guide to Peruvian macro data

    Interested in activity, prices, monetary, fiscal, external sector, and financial data for Peru? 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.

    Peru Country Profile Dashboard

    The starting point is