SOLVED

How many columns can a list have in SharePoint?

Copper Contributor

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!

1 Reply
best response confirmed by Xiaohu_Liu110 (Copper Contributor)
Solution

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 best response

Accepted Solutions
best response confirmed by Xiaohu_Liu110 (Copper Contributor)
Solution

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

View solution in original post