Exporting the Contents of a List

you can export the contents of a list and save the contents in the following file formats microsoft excel 2007 and later ( xlsx) microsoft excel 2003 and earlier ( xls) comma separated values ( csv) xml ( xml) the export to excel quick action performs the export function to obtain the desired results, you must choose the file format before you export a list for any field name that contains a space, the quick action removes the space when you export to xml choosing the export file format from the application, click action menu > edit actions to open the actions manager workspace the list of business objects that have quick actions appears under the your actions tab, expand the form actions menu and choose export the application displays the export to microsoft excel quick action click edit to start editing the quick action from the export format drop down menu, select the export file format to use click save for each column header, you can export a field or a value expression, but not both exporting to an external connection by default, the application exports data to your browser however, if you have an external data connection, for example to a remote host, you can export to that connection from the application, click action menu > edit actions to open the actions manager workspace the list of business objects that have quick actions appears under the your actions tab, expand the form actions menu and choose export the application opens the export to microsoft excel quick action click edit to edit the quick action in the advanced option section, from the export to drop down list, select the remote host connection to use click save exporting the list contents before you export, choose the file format you want within the workspace with the records to export, from the action menu choose form actions > export in the confirm dialog box, click yes to export all the records or click no to export a single selected record in the file download dialog box, click save to save the exported file and then navigate to a download location if you click open , the xlsx, xls, and csv files open in microsoft excel the xml files open in your default xml editor the file name indicates the date and time the file was exported for example, export2018 29 8 14 05 37 xml means that the file was exported at 2 05 pm, plus 37 seconds, on august 29, 2018