Column names created when importing a spreadsheet instead of the spreadsheet's header row RRS feed

  • Question

  • I'm trying to import a spreadsheet in order to create a custom list, but it keeps creating column names (i.e. "column 1", "column 2", etc) instead of using the spreadsheet's header row. What am I doing wrong?
    • Edited by Mike Walsh FIN Monday, August 31, 2009 11:59 AM if -> of (own spelling)
    Monday, August 31, 2009 10:07 AM


All replies

  • Be sure to specify the cells range correctly, including the header row.

    You can find the Microsoft guide about how to do this at http://office.microsoft.com/en-us/sharepointtechnology/HA100992371033.aspx

    -- Edin http://edinkapic.blogspot.com
    Monday, August 31, 2009 12:27 PM
  • I know you asked this question almost a year ago, but I had the same problem and couldn't find any definitive feedback on it including your post here. So, I thought I'd add my 2 cents in case it helps someone else.

    In my case, a finally figured out that the culprit was as simple as having a fully blank column in the middle of the cell range with data in the columns before and after it. I had created the column to act as a visual separator between two sections of the data. As soon as I deleted that empty column, save the spreadsheet, and tried the import again, it worked perfectly.

    • Proposed as answer by JamesonBoz Wednesday, April 9, 2014 7:01 PM
    Thursday, June 24, 2010 3:39 PM
  • Thanx Lisajo10! Making sure all columns had a header name in the first row helped :-)

    Pål A

    Tuesday, June 19, 2012 6:50 AM
  • hello TessaH,

    I found detailed explanation here, which helped me alot.




    Friday, October 18, 2013 2:43 PM