Feb 04 2019 04:25 PM
Is there a good rule of thumb or guideline for when to use a SharePoint Online List or having an Excel Document in a Doc Library? Asking for a friend....
Thanks!
Feb 04 2019 11:01 PM
Feb 05 2019 06:03 AM
Hello @Chris Gahlsdorf
A SharePoint list can be further leverage for automation events using Flow i.e. sending reminder emails based on a date. The row version history in lists allow for more granularity in restore/compare operations compared to Excel. It might be one less click to get to the list vs the Excel document (I'm grasping with this one).
If the nature of the content (columns) is known I would use a list. Inversely, if the content is not fully known I would use a spreadsheet.
I hope this helps.
Norm