This tutorial guides you through the steps to take your Flow data and import it into a Microsoft Excel spreadsheet that you can then analyze .
Export data to a CSV file
Step 1: Open a browser and enter the URL for your desired request, adding format=csv as an argument. For example,L
The format=csv argument causes the API to return CSV formatted results that you can then import into Excel.
Step 2: The data is formatted as a csv file and downloaded to your local system.
Step 3: Open Microsoft Excel.
Step 4: Click Data then Get Data then click From Text/CSV. The data opens in the query window.
Step 5: Locate your downloaded file.
Step 6: Select the Load To… option located at the bottom of the window, as shown below:
Step 7: Select Table from the list of options:
Step 8: The data is loaded in the current workbook:
Step 9: Make your desired changes.
That’s all there is to it!
If you need help, please email firstname.lastname@example.org for 24/7 assistance.