Importing data on 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("https://api.alphacast.io/datasets/[datasetId]/data?apiKey=[YourAPIKEY]&$format=csv")) Finally, set up your table by selecting the first row as headers. Step 3. There is no step 3. Enjoy!