Hotkey Highlight – Ctrl+Shift+E

Export to Excel – Ctrl+Shift+E

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.

Export progress dialog

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🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s