Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Sharepoint list from excel file

Asked By: Loretta Pruitt Date: Mar 11, 2009 Category: Sharepoint Views: 728

I have an excel file that I am trying to export to create a new
SharePoint 2007 list. When I use Excel 2007, there is a column that is a single
line of text, which is correct. When I use the same file with Excel 2010, the
column is changed multiple lines of text.

I want to keep the column as single line of text so I can sort on it in the
SharePoint list. I am unable to change the multiple lines of text into a single
line after the list is created in SharePoint. Any ideas why Excel 2010 would
handle this column of data differently? Or a way to define the column types in
Excel?

Tagged:sharepoint list from excel file

3 Answers Found

Answer #1 Answered By: Leanna Merritt Answered On: Mar 11, 2009

Perhaps because the single-line text is default 255 characters? (At least, true
in 2007.) Do you have any fields that are more than that?

Answer #2 Answered By: Britany Baird Answered On: Mar 11, 2009

but i did already check that and none of the fields are over 255. They
are actually quite small.

Answer #3 Answered By: Brittani Morton Answered On: Mar 11, 2009

It might also happen if the fields have any sort of rich text formatting
in them.

Didn't find what you were looking for? Find more on Sharepoint list from excel file Or get search suggestion and latest updates.