Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Problems importing CSV file

When I work in a CSV file in excel and I save it in that format (CSV)

then I want to import it to Jira and it seems "," delimiter changes to ";"

Why is this happening? and how can fix it?

1.JPG

1 answer

1 accepted

0 votes
Answer accepted
Hana Kučerová Community Leader Jan 27, 2021

Hi @Sofia Grunspan ,

on the first step's screen there's the Advanced section - if you click on it, you will get the possibility to set CSV Delimiter.

import.png

Hana Kučerová Community Leader Jan 27, 2021

As for the other question - one of the main reasons, why I stopped using Excel, is, the work with csv files became very complicated and I wasn't able to achieve, what I needed, in the later versions, because some functionalities were missing / very well hidden :-).

So I think what is happening is Excel just saves your file without asking about the format and use something default...

You can always check the format of your csv file using simple text editor as Notepad before the import.

Hi @Hana Kučerová ! Thanks for your answer. If I change the CSV delimiter "," to ";" it seems to work fine, but Does affect the import process in someway? or is it indistinct? 

I use Excel when I need to edit the file but I will try to find another way.

Thanks once more

Hana Kučerová Community Leader Jan 28, 2021

Hi @Sofia Grunspan ,

in general there is no difference between delimiters, you can use whichever delimiter you want.

If you for example import some text fields and the delimiter is also used in the texts, there can be parsing problems, but these situations could be handled by using quotes to mark the whole text...

Like Sofia Grunspan likes this

Thanks a lot! it helps me a lot! :)

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you