You can export selected items in a list from the repository to a comma-separated values (.csv) file. When you choose specific items from a search result list and export the items, the data is exported to a .csv file.
To export selected rows:
Navigate to a list.
Select the items to export as comma separated values.
Right-click and select Export To CSV or select Tools > Export to CSV.
The Export Contents To CSV dialog box is displayed.
Move the columns you want to export from the Select columns list to the Selected columns list.
Click OK. You are prompted to open or save the .csv file.