When you export the property values of the items in a particular list, the information is saved as a .csv file, which opens in your default application for .csv files.
Before performing this procedure, make sure your browser’s security settings allow file downloads.
To export information displayed in a list:
Navigate to list.
Select Tools > Export to CSV.
Select the columns to export as metadata.
Click OK.
Select whether to view or save the .csv file.
If you chose to save, select the location to which to save.
Do one of these:
If using a browser other than Internet Explorer (IE), click OK.
If using IE, press, and hold down Ctrl, and click OK.
If have exported columns that contain special characters, and if you open the .csv file in Microsoft Excel but Excel does not display them correctly, then save the file to your computer, and close it, and then use the Data > Import External Data > Import Data menu option to import the .csv file.