Forum Discussion
How many columns can a list have in SharePoint?
- Aug 17, 2023
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
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