Forum Discussion
List Guidelines
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!
Hello chrisnwhs
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