Importing data on Excel for Mac
How to integrate Alphacast with Excel for Mac?
Step 1. Getting the URL link from the dataset or pipeline
In the dataset, click on the Download button. Select the TSV format and choose Copy Link
Alternatively, you can use the Data Snapshot link from any pipeline. Remember to choose the TSV link.
Step 2. Integrating with Excel
Open Excel on your Mac, go to the Data tab in the top menu bar.
Click on Get Data (Power Query) and Select Get Data (Power Query) from the dropdown menu.
Choose data source: Blank query from the options
In the Connect to the data source tab, you need to paste the dataset URL and then run the following query. After that, press Next to visualize the table.
Csv.Document(Web.Contents("CSV link"))