Errors in CSV import

I'm trying to import Projects using CSV import, The process fails giving the following error

The first header row of the CSV import file contains following errors for the field name 'PK!q9+p��[Content_Types].xml ��(�̔MN�0��H�!�%n��j�?K��ؓƪc[���g��' on position 1: 'brackets mismatch', 'plus sign'

I've removed all the content in the file and tried uploading a basic csv with simple test data

<colgroup><col style="width: 49pt;" span="2" width="65"/> </colgroup>
Summary
test

Not sure what the reason is. Any help is really appreciated.

thank you

Miranda

2 answers

1 accepted

This widget could not be displayed.

I really don't think your file is CSV, there's a lot of control characters there.

Try opening it in a plain text editor (vi, gedit, nano, emacs, etc, or notepad if you're stuck with a Windows operating system) and checking what they show the first line as. Even Excel gets "save as .csv" right most of the time, but I do know of people trying to save as csv and not quite getting it right because all they change is the filename, and not the actual format.

Indeed, it looks like a zipped spreadsheet XML. Only plain CSV files are supported by JIRA Importers Plugin.

Thank you for the responses. It worked fine after the saved the file as a CSV.

@Nic Brough [Adaptavist] : Nic, you are just great!! I ran into this issue and found your post. In a minute i am On track now. Thanks, Akash

This widget could not be displayed.

Configuration format has changed in version 2.6.0. If you're using an older format you need to restart the wizard from scratch. I get this error while doing csv import. Please help

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published yesterday in Marketplace Apps

The 7 hacks of highly successful automation

...there's anything I've learnt from working, it's that people are lazy! No offense to anyone reading this, but it's true and we can all admit it. The easier you make something for someone, the more...

82 views 0 8
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you