nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Errors when trying to import a very basic CSV file

Maxine Freedman-Thompson_vwry25

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:
Import errors.jpg

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

Sample CSV.jpg

Any advice please 🙏

Accepted answers

John Funk

Hi Maxine - Welcome to the Atlassian Community!

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

All comments

Trudy P 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.

Screenshot 2025-12-05 at 8.59.53 AM.png

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

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!

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_vwry25

Hi Trudy

Is this Advanced option not for specifying the delimeter:

Maxine Freedman-Thompson_vwry25

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

Maxine Freedman-Thompson_vwry25

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

Maxine Freedman-Thompson_vwry25

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.

Maxine Freedman-Thompson_vwry25

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

David Nickell

What is the non-ascii character warning you are getting? Maybe a Line Feed ? (I see the warning in your screen shot)
Back slashes "/" are sometimes used as escape characters.
Are there any required fields either in our field context or workflow steps?

Try importing a single issue. Debug one and then add a second.

You can also see the JSON representation of an existing issue using the REST API in a browser like this: https://splitdimedata.atlassian.net/rest/api/3/issue/SSSB-300?expand=editmeta

You'll get something like this which will help check your required fields

"expand": "renderedFields,names,schema,operations,editmeta,changelog,versionedRepresentations,customfield_10210.cmdb.label,customfield_10210.cmdb.objectKey,customfield_10210.cmdb.attributes,customfield_10010.requestTypePractice",
  "id": "10868",
  "self": "https://splitdimedata.atlassian.net/rest/api/3/issue/10868",
  "key": "SSSB-300",
  "editmeta": {
    "fields": {
      "summary": {
        "required": true,
        "schema": {
          "type": "string",
          "system": "summary"
        },
        "name": "Summary",
        "key": "summary",
        "operations": [
          "set"
        ]
      },
      "parent": {
        "required": true,
        "schema": {
          "type": "issuelink",
          "system": "parent"
        },
        "name": "Parent",
        "key": "parent",
        "hasDefaultValue": false,
        "operations": [
          "set"
        ]
      },

David Nickell

Also --do you have create issue permission in the project? A CSV import mimics a create from the UI. All rules and permissions apply.

John Funk

So in your spreadsheet tool, but the values in different columns and drop the separator in the spreadsheet. Then save as a CSV file. When you import then you will map the columns of your spreadsheet to the Jira fields.

Maxine Freedman-Thompson_vwry25

Hey @John Funk , sorry, I'm not sure what you mean by this When creating the Excel file, each value is in a separate column:

Maxine Freedman-Thompson_vwry25

Thank you, everyone, for your help! 🙏

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

import