Cannot import CSV files

[Todd B_ Cutick]

Multiple attempts to import a CSV file into Jira have failed.  I have set the delimiters correctly, but all the columns in the file are loaded into a single field in Jira.  Can you assist?

[John Funk]

Hi @Todd B_ Cutick  - Did you ever get this resolved? 

[Alex Koxaras -Relational-]

Hi @Todd B_ Cutick and welcome to the community!

If Jira keeps importing everything in one cell, then you are not setting the correct delimiter. Save your file as utf-8 csv with commas delimiters.

If you are not able to do that, then on Jira try other delimiters, such as semi colon ";".

[Todd B_ Cutick]

Tried multiple delimiters with no success.  File was saved as utf-8.  I'm wondering if the problem is the result of the liberal use of commas in the text of each column.  I did try replacing the comma delimeter with a $, but there was still no success.

[Alex Koxaras -Relational-]

Can you share anything? Like a screenshot of your csv, or your csv, or your import process?

[Todd B_ Cutick]

One problem is setting the delimiters globally without messing with the commas in the text (I changed the comma delimiter to a $ sign, but that changed all the commas in the text, too. I have at least 1300 user stories to import, and manually setting the delimiters is, at best, an arduous task.  It may be easier to just manually copy-paste each row into Jira, but I want to avoid that level of effort.

[Alex Koxaras -Relational-]

Sometimes you might have within your file commas as delimiters, but you settings, alongside with excel settings, might have set another delimiter. This happened to me, that's why I'm telling you.

Can you open your file from excel and from notepad? Do you get the same results?

[Todd B_ Cutick]

I'm on a Mac and used Numbers to create the csv.  I can open it in text edit, as well.

It looks like I'm gonna have to go through each row and fix the delimiters while maintaining commas with the text.  Not a fun project! ;-)

[Alex Koxaras -Relational-]

Can you attach here a sample of your CSV, but with sample data?