Forum Discussion
How many columns can a list have in SharePoint?
Thanks for watching.
I'm now trying to create a data with 1000+ columns within a list in SharePoint, not sure if it's possible to line it up, thanks a lot!
Hi Xiaohu_Liu110 ,
The maximum total sum of all columns in a SharePoint list is 8,000 bytes. Different column types cost different byte sizes.
See a complete list here
https://learn.microsoft.com/en-us/sharepoint/install/software-boundaries-and-limits#Column
For example:
You can add 1000 "Yes/No" Columns, but only 255 text columns to a list.
But that list would look very wierd.....
It would be best to re-think your data-model.Try to change that so you use much fewer columns but more rows.
Best Regards,
Sven
1 Reply
Hi Xiaohu_Liu110 ,
The maximum total sum of all columns in a SharePoint list is 8,000 bytes. Different column types cost different byte sizes.
See a complete list here
https://learn.microsoft.com/en-us/sharepoint/install/software-boundaries-and-limits#Column
For example:
You can add 1000 "Yes/No" Columns, but only 255 text columns to a list.
But that list would look very wierd.....
It would be best to re-think your data-model.Try to change that so you use much fewer columns but more rows.
Best Regards,
Sven