Suggestion:
We can export any transaction (e.g. Sales order) to excel by clicking on three dots quick add button(three dots at the right side) near add new button in the list/table/doc view screen. After clicking on quick add button, we get a menu which is called the scroll panel menu bar. Here we get the options to ‘Export To Excel’ the records. Once we click on this button an excel sheet gets downloaded automatically (File name starts with HDR_DATA…..xls format) with the all records header data, along with the column heading of each field .
Note : Only header data of searched records will be exported
Please see the snapshot below: export to excel.png