none
SharePoint 2013 document library maximum columns allowed RRS feed

  • Question

  • Hi All,

    I have a document library. I need to add around 700 columns to the library with all different datatypes.

    I have followed Microsoft limits for each datatype allowed in library and see to it that it does not exceed above the permissible limit for each data type. https://technet.microsoft.com/en-us/library/cc262787.aspx

    I have created different content types and added them in the library.

    But my library does not accept columns more than 344.

    Please help me in this regard as I need to add 700 columns.

    Please suggest me options on how to do this.

    NOTE:-  No customization is allowed by my client.

    Your help is highly appreciated.

    Thanks & regards,

    Manish

    Thursday, August 13, 2015 6:30 AM

Answers

  • Hello Manish,

    Limit per list item is 8000 bytes of which 256 bytes are reserved for built-in SharePoint columns:

    https://technet.microsoft.com/en-us/library/cc262787.aspx  

    In my test environment I received “The column cannot be added because the total size of the columns in this list exceeds the limit. Please delete some other columns first” error  while I was creating 261th Choice column.

    Adding all columns to a one list/library might not be the best idea. You can create couple lists, each having 200-250 columns (Max. amount they can hold). Using lookup field you can try to display all the columns in one list. For example in the first list you can add a lookup field and get the columns you want from the other lists you created.

    Here are some links about how to use lookup field in lists and libraries:

    https://support.office.com/en-za/article/Create-list-relationships-by-using-unique-and-lookup-columns-80a3e0a6-8016-41fb-ad09-8bf16d490632

    http://stackoverflow.com/questions/18186174/how-to-make-a-list-view-with-multiple-columns-from-single-lookup-column

    http://sharepoint.stackexchange.com/questions/24110/can-a-list-item-point-to-the-column-value-in-another-list

    Thank you

    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Monday, August 17, 2015 11:31 AM
    Moderator
  • I have made all efforts to see that my different datatype columns are below SharePoint allowed limits.

    E.g. I have Choice 240 columns which is below allowed 276.

    Hi Manish,

    It's important to understand that the limit of 276 choice columns is assuming you don't have any other columns on the list. Every column, no matter its type, contributes toward reaching the limit.

    Because different columns require a different amount of space, Microsoft has provided examples of the maximum number of columns for each type, assuming no other columns exist on a list. 700 columns will definitely exceed the allowable size.

    Consider Patrick's advice to use lookup columns to distribute the information into multiple lists. You might also explore using InfoPath or some other custom form tool that would store the information in another format (such as XML) instead of in SharePoint columns. Depending on the resources available to you, you might even consider setting up a SQL Server table and connecting to it via an external content type, which you can then expose on SharePoint via an external list.

    Monday, August 17, 2015 3:46 PM

All replies

  • Column limit depend which type of column you are using in it. Inserting the items will not be an issue, but real issue will be how you retrive it in a view. There is list view threshold limit, which cause performance issue.

    Below the list column limit per type:

    Column Name Limit

    Single line of text 276

    Multiple Lines of Text 192

    Choice 276

    Number 72

    Currency 72

    Date and Time 48

    Lookup 96

    Yes / No 96

    Person or group 96

    Hyperlink or picture 138

    Calculated 48

    GUID 6

    Int 96 Managed

    metadata 94

    http://technet.microsoft.com/en-us/library/cc262787(v=office.15).aspx#Column

    Please mark it as answer if it helps you solving your problem


    Amit Kotha

    Thursday, August 13, 2015 6:54 AM
  • Thanks Amit for your reply.

    I have made all efforts to see that my different datatype columns are below SharePoint allowed limits.

    E.g. I have Choice 240 columns which is below allowed 276.

    I have created different content types for each datatype.

    But when I try to add column through content types, as soon as column count reaches 344 in the list, I am unable to add any columns to the library.

    Also no worries about the list view as I will not be showing them on the view.

    Max in a view I will show 10-15columns.

    Please suggest on this.

    Thanks & regards,

    Manish



    Thursday, August 13, 2015 7:33 AM
  • Hello Manish,

    Limit per list item is 8000 bytes of which 256 bytes are reserved for built-in SharePoint columns:

    https://technet.microsoft.com/en-us/library/cc262787.aspx  

    In my test environment I received “The column cannot be added because the total size of the columns in this list exceeds the limit. Please delete some other columns first” error  while I was creating 261th Choice column.

    Adding all columns to a one list/library might not be the best idea. You can create couple lists, each having 200-250 columns (Max. amount they can hold). Using lookup field you can try to display all the columns in one list. For example in the first list you can add a lookup field and get the columns you want from the other lists you created.

    Here are some links about how to use lookup field in lists and libraries:

    https://support.office.com/en-za/article/Create-list-relationships-by-using-unique-and-lookup-columns-80a3e0a6-8016-41fb-ad09-8bf16d490632

    http://stackoverflow.com/questions/18186174/how-to-make-a-list-view-with-multiple-columns-from-single-lookup-column

    http://sharepoint.stackexchange.com/questions/24110/can-a-list-item-point-to-the-column-value-in-another-list

    Thank you

    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Monday, August 17, 2015 11:31 AM
    Moderator
  • I have made all efforts to see that my different datatype columns are below SharePoint allowed limits.

    E.g. I have Choice 240 columns which is below allowed 276.

    Hi Manish,

    It's important to understand that the limit of 276 choice columns is assuming you don't have any other columns on the list. Every column, no matter its type, contributes toward reaching the limit.

    Because different columns require a different amount of space, Microsoft has provided examples of the maximum number of columns for each type, assuming no other columns exist on a list. 700 columns will definitely exceed the allowable size.

    Consider Patrick's advice to use lookup columns to distribute the information into multiple lists. You might also explore using InfoPath or some other custom form tool that would store the information in another format (such as XML) instead of in SharePoint columns. Depending on the resources available to you, you might even consider setting up a SQL Server table and connecting to it via an external content type, which you can then expose on SharePoint via an external list.

    Monday, August 17, 2015 3:46 PM