Showing results for 
Search instead for 
Did you mean: 
Not applicable

MS Flow - Export Sharepoint List content to Excel

Hello together,


Its really pitty, that there is no easy solution to create simple Excel table from content of Sharepoint List items.


My approach is generating no desired outcome:


1. When an item is created (In Sharepoint list)

2. Get Items (from Sharepoint List)

3. Create CSV Table (no option to create Excel table with the content from Connector Get Items 😞 ...)

4. Create File (In Sharepoint directory)


Outcome is messy File without formatting, which is just generating additional work to me...


Any Idea How to export such Excel table the easy way to the Sharepoint  ?

e.g. same as is Export to Excel button on the top of the Sharepoint List...


I think Im not the only one asking for this basic functionality, any hint shall be really valuable. Thanks.



Advocate V
Advocate V



This is possible.

Created a quick example. In this example I trigger with button

Microsoft Flow Community - 01.png

I will get all the files located in the Document library. Select your SharePoint site address and library name.

Next we will put this in a excel file in OneDrive. Prepare first your excel with a table and table name.

Microsoft Flow Community - 03.pngMicrosoft Flow Community - 04.png

Adding for each item a rows to your table in excel

Microsoft Flow Community - 02.pngAdd the corresponding value to your column items in you table.


This is an example result.

Microsoft Flow Community - 05.png



I hope this can help you.




Frederik Bisback



Community Support
Community Support

Hi @Anonymous,


Are you trying to create an Excel file on SharePoint library using Flow?

In the action Create CSV table, we could enable Custom Columns to customize the table. After getting the CSV table, create a CSV file in SharePoint library. On SharePoint site, we could select open the csv file in Excel Online or Excel.

I have made the following test, please check it for a reference.


If you need the feature to create an Excel file directly, please feel free submit a request on Flow Ideas Forum at here:


Best regards,


Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not applicable


Hello! Now, how would this look if I wanted 3 Sharepoint lists to fit into one Excel Sheet?

@v-yamao-msft  Hi Mabel Mao,

I've been using this since there was no faster choice,

However the issue with csv is when I open the data into Excel, it always breaks at the "delimiter" that I dont want 

Like sometimes I might note something with a comma, but import csv to exel with commo in tour data does not feel like a good solution

@Anonymous ,


You can use "Microsoft Graph" to approach it.

The way is to use the connector "Invoke an HTTP request", you can get/paste/delete the data from the worksheets.

John Liu has a tutorial of this, you can refer to below video:


Microsoft Graph explanation:



Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,498)