How to integrate Alphacast with Excel for Mac?
Step 1. Getting the URL link from the dataset or pipeline
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.
Alternatively, you can use the Data Snapshot link from any pipeline. Remember to choose the TSV link.
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.
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.
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.
Related insights
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
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
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
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 (
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