
Announcements
Hi,
When drawing data, what are the pro's and con's of using excel or sharepoint lists?
Do you have a preference for either??
I use excel, based on the large amount of data I have to draw in.
Andy.
The differences are vast and the reasons for using one over the other, depend on what you plan to do, more than those differences.
It is easier to read, update, filter and pretty much do anything in SharePoint than an Excel file, and it supports better scale by far.
But if you have a small app, with little data changes, then Excel is fine. Personally I do not default to Excel unless its a small app.
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey