While some D365 data has Open in Excel functionality, allowing users to interact with the data through the Excel Data Connector add-in, every list page in D365 can be exported to excel, creating a static download of the data.
Ctrl+Shift+E gets you that excel export in fewer clicks. As a bonus, this shortcut places the selection on the Download button in the following screen, so you can use the Enter button to execute the download.
Ctrl+Shift+E…Enter for a mouse-free excel export of your data.
Export Selected Rows
Only want to export a few selected rows to Excel? Check the desired rows prior to clicking Export to Excel and only those rows will be included in your data.
Export to Excel Power User Tip
The D365 platform now supports exporting up to one million rows of data to excel. With this great power, exercise great responsibility.
Need to export more than a million rows? You should probably look into using a different tool. Excel itself can only handle 1,048,576 rows🙂