Exporting to a CSV file in SharePoint Online lists

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s