Errors when trying to import a very basic CSV file

[Maxine Freedman-Thompson]

Hello

I'm trying to import 43 new stories into an existing Space using a CSV file. I have set the CSV delimiter to ';' and mapped the three fields, but keep getting the same errors, as shown below:

This is a sample of the data I'm trying to import:

Any advice please 🙏

[Trudy Claspill]

Hello @Maxine Freedman-Thompson 

Welcome to the Atlassian community.

The CSV file needs to use a comma as the delimiter, not a semi-colon. Have you done something to tell Jira that you are using a semi-colon instead? I did not find a way to do that (yet).

Into what type of space are you trying to import the data? Get that info by clicking on the ... next to the space name in the panel on the left. The type information is at the bottom of the pop-up.

What is the field mapping that you have set up for this import?

[Maxine Freedman-Thompson]

Hi Trudy

Is this Advanced option not for specifying the delimeter:

[Maxine Freedman-Thompson]

It's a Company Managed Space and I don't change the field mapping.

[Maxine Freedman-Thompson]

@Trudy Claspill I get the same error even if I upload the CSV file with ',' as the delimiter.

[John Funk]

Hi Maxine - Welcome to the Atlassian Community!

Is there a reason you are not using the standard Comma as your separator? 

[Maxine Freedman-Thompson]

Hi @John Funk 
The file was provided by someone else and they had used this format. I have now tried with a ',' delimeter too, and get the same error.

[David Nickell]

You may be doing everything perfectly and may not realize that no matter how hard you try, Excel does something to alter your data when the file is saved.  

Open the file in a good text editor and see if you can spot an issue.  I don't even recall what tripped me up before... but I finally corrected the CSV format using TEXT, not Excel.

Good luck!

[Maxine Freedman-Thompson]

Thanks @David Nickell but I can't spot any issues :(