You can export a list or a library to Excel. This can be very useful for reporting purposes.
In the Classic Experience, in the List or Library tab, click on the Export to Excel button:
In the Modern Experience, in the action bar, click Export to Excel:
If you are prompted to confirm the operation, click OK.
In the File Download dialog box, click Open:
You may be prompted to enable data connections on your computer. If you think the connection is safe, click Enable.
There are few things to note here:
- I recommend exporting the All items view and then filtering the list or removing columns in Excel.
- An Excel table is created with a data connection based on a web query file (.iqy). Save the file as a .csv or .xslx file to prevent issues that can arise from the .iqy file type.
- The columns in the export are determined by the current list view.
- Filters will not...