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

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?

Answer 1

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

Answer 2

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.

Answer 3

Thanx Lisajo10! Making sure all columns had a header name in the first row helped :-)

---

Pål A

Answer 4

hello TessaH,

I found detailed explanation here, which helped me alot.

http://sharepointbuzzer.com/2010/10/22/import-excel-sheet-as-sharepoint-list/

Regards

Manish