Forum Discussion

jolondon's avatar
jolondon
New Member
10 years ago
Solved

I am so frustrated!

I have imported the same Excel sheet 7 times in excel and csv form. Every time I do the name of the column shows up as column1, column2, etc. rather than the names in the first row. I have followed t...
  • samdthompson's avatar
    samdthompson
    10 years ago

    It can be super frustrating. A couple of things to try:

     

    1. can you save as a table in excel and bring in?

    2. rename each of the headers in the csv with say a preceeding space. It sounds like its a format thing and by changing it you might get some joy.

samdthompson's avatar
samdthompson
Icon for Memorable Member rankMemorable Member
10 years ago

It can be super frustrating. A couple of things to try:

 

1. can you save as a table in excel and bring in?

2. rename each of the headers in the csv with say a preceeding space. It sounds like its a format thing and by changing it you might get some joy.

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

jolondon Yes try option 1 listed by samdthompson

 

In Excel - click in any cell in the data => Ctrl-T => verify the range => check my Table has headers => give your table a Name

 

Then try importing again => and select the Table name NOT the Sheet name