Data export allows you to quickly draw data from tables and lists to excel file. This mechanism allows for easy integration with other systems using this popular file format, to create external reports, etc.
To start exporting data to excel file go to the designer object repository:
and then select a table or a list from which you want to export the data:
After moving to the list or the table editor, select an option to export data from the list or the table:
After you clicking export data button your browser will immediately start downloading the excel file that contains the data from the table or the list along with the headings.