Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

Jira exports unrecognized characters when I go to import CSV files

I export a table from jira, then when I go to import it with modifications, there is a black diamond with a questionmark in each table box. The only solution I have found is to literally manually put a space where each of those where. So when the tables are huge, that is way too tedious, especially across multiple tickets. The file encoding is correct as UTF-8 on import. I already tried pasting it into notepad then back into excel. And using new excel sheets. I've deleted the question marks then hit the "text" button on the description box and then copied and pasted. This is a huge pain because we're creating hundreds of tickets that have tables. 

 

ex: 

|Cam| | | |

turns into

|Cam|�|�|�|

1 answer

0 votes
Charlie Misonne Community Leader Dec 03, 2021

In my experience Excel saves CSV's in the encoding you OS is using. For me that is Windows-1252 (= ANSI)

After saving/ exporting the csv please check the encoding of the file and use it in the jira import wizard.
I usually open the file in notepad++ where you can check the encoding a the bottom right. See these screenshots for examples:

 

2021-12-03 13_48_02.png

2021-12-03 13_46_39-.png

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

460 views 19 23
Read article

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