As you probably know, you can export SharePoint lists to Excel. It’s a great way to get the data into other formats for analysis. Microsoft has added a new twist to the Export feature… you can now export to a CSV (comma-separated values) file instead of Excel. Here’s how it works…
The Export to Excel option has been renamed to Export, and there’s a dropdown option to pick either Excel Workbook or CSV:
This may not be something that you want or need to do very often. But sometimes you want to get a text-only data export without all the overhead of Excel formatting. In those cases, a CSV file format is the way to go.
One Minute Office Magic 