Dynamics CRM 2015: A useful side effect of 'Open in Excel Online'

Laptop with USB stick

We always enjoy discovering new features and functionality in Microsoft Dynamics CRM. Recently we discovered a useful side effect of Open in Excel Online, which helps speed up data entry or data importing.

Instead of pasting into an Excel spreadsheet then importing, just go to your list and click 'Open in Excel Online.'


Once in Excel Online you can start pasting away - magic! You will still need to make sure your lookup text will resolve but this saves a huge amount of time! Once finished, click 'Save changes to CRM'. Your data will be submitted for import and CRM will be updated.



Join our Mailing List

Receive our latest technology news and updates straight to your inbox once a month. We will not share your data and you may unsubscribe at any time.