How To Export Data From a SharePoint Online List To Excel

This tutorial will show you how to export a Sharepoint List to Excel. Specifically, it will show you how to export a Sharepoint Online list to a Microsoft Excel spreadsheet from the classic Sharepoint experience and the modern SharePoint experience. It will also show you how to export a Sharepoint List as a CSV file and how to export a filtered SharePoint list to excel.

Timeline
0:00 - Start
0:35 - Export a SharePoint List From Classic Experience
3:05 - Export a SharePoint List From Modern Experience
4:35 - Export a Filtered SharePoint List

🚩 Connect with me on social:

🔔 Subscribe to my YouTube channel:

This video was created using Camtasia 2020. You can download your free trial at the following links:



The audio in this video was recorded using a Blue Yeti Nano. You can purchase yours at the following links:

Note that I may earn a small commission at no additional cost to you from purchases made using these links.

#SharePoint #Microsoft365 #SharePointOnline

[markobe]

I have 35 columns and one column is not exported in excel I don't understand why. I have imported table from excel to sharepoint list and made some modifications. That column was created additionaly but so are few others and with them I didn't have problems. Only with that particular one

[kTN]

Hi Lui,
Why it export twoextra columns Items type and the path.. I have the same but not in sharepoint list

[niravbamrotiya]

how to achive this for a list consisting 10000 records

[subhraghosh]

Any idea how to get url for export to excel for specific item ? ? just Url I am looking for ..Thee are ways to do from Power Automate

[raventrophy]

Hello! thank you for the tutorial- it was helpful. But can ou show how to export such file with information about VERSIONING?

[AbbyRani]

Hi i do have a question i have sharepoint list where a view called 2020 hold 1633 items but when i export to excel it only download 441 items and if export to csv it downloads all 1633 items is there any blocker in export to excel

[vishaljhaveri]

It was a nice video explanation sir. Can you please show how to disable Export Data from a SharePoint online list to excel button? So that no one can download the list. Can you please guide me, sir?

[shivamgautam]

Hi sir

i have list with images and i want to export the images also.(currently it is shoeing me the path for the image not the image)

[jl]

I am missing the From Excel button option, do i need to turn on a feature for it to display?

[LipeAnna]

Can I import an excel spreadsheet to Sharepoint?

[Loremaster]

You didn't show how to create the view, all's I want to do is export SOME data from my list to Excel