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.