I have been using the Open with Excel Online Feature for a while now and find it saves me sooooo much time.
Yesterday I had a user create records in Excel Online and Edit others.
I could not believe it and was shocked I never read about it so I thought I would share.
We just went into the Excel Online to view /edit the existing records and added some to the bottom.
Simple as that.
We did find on one table that if one column was entered it caused it to fail.
But generally this worked.
I created hundreds of records yesterday so thought I would share incase someone else did not know this was possible now.
Wonder how long it has been possible??
yep just like everything I read, this says edit records, not create new.
Hi Partner,
Thanks for sharing!:)
The feature has been around for a long time,since CRM Online 2015 Update 1 or later.
You can refer following document for more details about the feature:
Open your model-driven app data in Excel Online - Power Apps | Microsoft Docs
Adis
136
Super User 2025 Season 1
Sohail Ahmed
81
Jonas "Jones" Melgaard
77
Super User 2025 Season 1