How to integrate Alphacast with Excel for Mac
In the dataset, click on the Download button. Select the XLSX format and choose Copy Link Alternatively, you can use the Data Snapshot link from any pipeline. Remember to choose the XLSX 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. Excel.Workbook(Web.Contents("XLSX link")) Alternatively, you may choose to use a CSV Link provided by Alphacast. To do so, you should use: Csv.Document(Web.Contents("CSV link")) Then, double-click on "Table" to open the data in the Power Query editor: Finally, set up your table by selecting the first row as headers. Step 3. There is no step 3....
