Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Sharepoint list from excel file

  Asked By: Loretta    Date: Mar 11    Category: Sharepoint    Views: 3052

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?

Share: 

 

3 Answers Found

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

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

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

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.




Tagged: