Export Flow data to Microsoft Excel

Tags: Flow

Overview

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


https://flow.pluralsight.com/v3/customer/core/users/?limit=5&format=csv

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!

back to top


If you need help, please email support@pluralsight.com for 24/7 assistance.