I'm trying to import a CSV file using import export wizard, Im facing an issue. The first row is also added as a column name.

Import wizard:

enter image description here

The highlighted area is my 1'st row.

  • What is your row terminator? – Stijn Wynants Jul 18 '17 at 8:11
  • THis is my row delimiter {CR}{LF} – Bhuvanesh Jul 18 '17 at 8:27
  • can you check if the csv file first row has the CRLF at the end? – Stijn Wynants Jul 18 '17 at 8:30
  • I have attached the snap in my question, can you check whether it has or not? – Bhuvanesh Jul 18 '17 at 8:38
  • I can't do it from a snap :), copy the first two rows when opening in notepad, and check if there is a CRLF at the end, if not that is your issue. – Stijn Wynants Jul 18 '17 at 8:43

I used your data and was able to do it without any issues. Seems your first row of data does not have {CR}{LF}. The snap of data looks like there is an auto new line rather than you providing it.And that is why the 3rd column has ' Is_Active""1, so the wizard is looking for a comma now. Below is my test with data of similar type :

enter image description here

enter image description here

enter image description here

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.