You can now export data from Microsoft Lists as CSV files

What you need to know

• Microsoft Lists now lets you export data as CSV files.
• The new feature was announced through the Microsoft 365 Admin Center.
• You should be able to export Microsoft Lists data as CSV files within all environments.

Microsoft recently rolled out an update that allows you to export data from Microsoft Lists as comma-separated values (CSV) files. This should make it easier to compile and share data, especially with people using different apps. CSV files work well with Excel, Google Sheets, and many other programs, so being able to export Microsoft Lists data as them is a welcome change.

The update was announced through the Microsoft 365 Admin Center (via OnMSFT). On the Lists app for Windows, you'll now see an export dropdown menu with options to export data as a CSV file or as an Excel workbook. At least for now, Lists on macOS only shows an option to export data as a CSV file.

Microsoft explains that the Export to CSV option is only supported within Lists, not within document libraries, "Unfortunately, when the feature was rolled out, the changes were visible in both document libraries and lists, and we are working to correct this issue by late May, and only show the new CSV option inside lists."

Microsoft Lists can be used to track a wide range of data, including inventory, itinerary, assets, issues, and more. The ability to export data as a CSV file makes it much easier to handle.