When creating reports in Ariba, it is often useful to export the data to a file for storage and further manipulation of the data.
The default format for exporting reports is an Excel spreadsheet, however, sometimes a different format is preferable. For example, sometimes it is preferable to have a format that can hold an infinite number of lines of data, and sometimes the user simply does not need the extra material that the Excel spreadsheet contains.
An option exists to export the data in .csv format. To use this option, after creating a report in Ariba, instead of selecting the “Export” button, select the “Actions” button and select “Configure Export” from the drop-down menu. You will then have the option to select “Excel Template” or “Comma-separated value (CSV) format”.
Selecting CSV format will export the data in a simple, straightforward format, without any additional tabs containing pivot tables and charts. Both export formats can be useful, and it is helpful to be aware of both options.