Export part of a Sharepoint List

%3CLINGO-SUB%20id%3D%22lingo-sub-1436104%22%20slang%3D%22en-US%22%3EExport%20part%20of%20a%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1436104%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20a%20large%20Sharepoint%20List%20with%20several%20views.%20Is%20there%20a%20way%20to%20export%20only%20part%20of%20a%20Sharepoint%20List%20or%20export%20a%20View%20that%20is%20filtered%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1436104%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1440192%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20part%20of%20a%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1440192%22%20slang%3D%22en-US%22%3EWhere%20do%20you%20want%20to%20export%20this%20to%3F%20Excel%3F%20To%20another%20list%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1440252%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20part%20of%20a%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1440252%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F532869%22%20target%3D%22_blank%22%3E%40derhallim%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20to%20Excel%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1440286%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20part%20of%20a%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1440286%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F532869%22%20target%3D%22_blank%22%3E%40derhallim%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20needing%20to%20export%20a%20specific%20view%20that%20is%20filtered.%20Example%3A%20I%20am%20only%20wanting%20to%20export%20anything%20with%20a%20day%20of%206%2F1%2F2020.%20Is%20that%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1440301%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20part%20of%20a%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1440301%22%20slang%3D%22en-US%22%3EYou'll%20need%20to%20create%20a%20view%20for%20it%20if%20you%20want%20to%20export%20it.%20Otherwise%2C%20you'll%20need%20to%20do%20something%20with%20Power%20Automate%2C%20pass%20it%20the%20filter%20you%20need%2C%20and%20it'd%20create%20your%20file%20in%20your%20OD4B%2C%20but%20out%20of%20the%20box%20in%20SharePoint%20you%20have%20only%20the%20export%20to%20excel%20button%20which%20only%20works%20on%20the%20current%20view.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1440325%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20part%20of%20a%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1440325%22%20slang%3D%22en-US%22%3EThank%20you%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1440276%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20part%20of%20a%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1440276%22%20slang%3D%22en-US%22%3EIf%20you%20switch%20to%20a%20specific%20view%20and%20click%20on%20%22Export%20to%20excel%22%20in%20the%20command%20bar%20(just%20beside%20quick%20edit)%2C%20it%20will%20only%20export%20that%20view%20(columns%20and%20items)%20to%20excel%20(actually%20it's%20a%20query%20file%2C%20but%20you%20can%20easily%20save%20it%20to%20excel%20since%20it%20opens%20in%20Excel%20by%20default).%3CBR%20%2F%3E%3CBR%20%2F%3ENote%20it%20will%20give%20you%202%20extra%20columns%2C%20but%20that's%20easy%20to%20get%20rid%20of.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

We have a large Sharepoint List with several views. Is there a way to export only part of a Sharepoint List or export a View that is filtered?

 

6 Replies
Highlighted
Where do you want to export this to? Excel? To another list?
Highlighted

@derhallim 

Yes to Excel 

Highlighted
If you switch to a specific view and click on "Export to excel" in the command bar (just beside quick edit), it will only export that view (columns and items) to excel (actually it's a query file, but you can easily save it to excel since it opens in Excel by default).

Note it will give you 2 extra columns, but that's easy to get rid of.
Highlighted

@derhallim 

I am needing to export a specific view that is filtered. Example: I am only wanting to export anything with a day of 6/1/2020. Is that possible?

Highlighted
You'll need to create a view for it if you want to export it. Otherwise, you'll need to do something with Power Automate, pass it the filter you need, and it'd create your file in your OD4B, but out of the box in SharePoint you have only the export to excel button which only works on the current view.
Highlighted
Thank you