About ExportZen

Export SharePoint List Data to CSV/Excel.

Export SharePoint Lists to any CSV/Excel format. ExportZen is customizable, workflow-ready, can be scheduled and is batch-capable, respecting Views and filters. Comma-Separated Values (CSV) is a widespread, cross-platform file format for exchanging structured data sets. Microsoft Office Outlook imports contacts stored in CSV format (only Outlook calls them "DAT data files"). Microsoft Office Excel offers bi-directional (read and write) support for CSV spreadsheet files. ExportZen allows your users to export SharePoint Lists to csv from SharePoint (2010 or 2007).

All SharePoint Lists and Document Libraries are essentially structured data sets. The ROXORITY ExportZen solution package for SharePoint (2010 or 2007) lets you export data from any list into any CSV format:

  • Design and customize multiple different CSV data file exports for various SharePoint List types.
  • Offer users, programs and systems an always-up-to-date, decoupled CSV view on your business data.
  • Streamline highly customizable asset management, data transformation, integration and migration tasks and processes.

How ExportZen CSV Data Exports work for SharePoint Lists
ExportZen integrates one or more Export actions into the Actions menu of SharePoint List Views. Clicking the menu item will let users download the SharePoint List data as a CSV file. To set up that menu item, you need to tell ExportZen just four things:

  • The title of the Export menu item,
  • The description of the Export menu item,
  • The Columns to be included in the exported CSV data file and
  • The types of Lists compatible with this export.

ExportZen lets you create and automate customizable CSV exports of SharePoint List data easily.

CSV exports from List Actions menu
WSS 3.0 and SharePoint 2007 users can download an entire SharePoint List as a CSV data file easily from the Actions menu.

CSV exports from the List ribbon
SharePoint 2010 users can download an entire SharePoint List as a CSV data file easily from the List ribbon.

Download of CSV-exported SharePoint List data
ExportZen creates the SharePoint List data CSV export on-the-fly, so the "file download" is in fact always up-to-date. The file download opens in Excel by default for most users who don't choose to Save the CSV file.

Customizable CSV List Export Actions
Administrators can design and fine-tune different SharePoint List data CSV exports in a central "Export Action Definitions" List.

Customizable CSV List Export Actions
Full control over the List ribbon or Actions menu item, the types of Lists to target and the SharePoint List Columns to be included in the CSV data file, as well as their order.

Advanced Configuration Settings
While the detailed CSV export settings are set when defining an export action, farm administrators and Site Collection administrators can still fine-tune global ExportZen defaults.