One Time Import of a Google Sheet into Jira Server to Create Tasks

[Cailyn Steinhardt]

Hi all!

I have a team that is going to be moving into Jira that has been tracking all of their work in 1 Google Sheet and it has 100+ tasks in there. Is there a way to import the data into Jira to automatically create tasks so that we don't have to manually do this?

We are not looking for an integration just a one time upload and we are on the server version of Jira.

[Sanjen Bariki]

Hi @Cailyn Steinhardt ,

Welcome to Atlassian Community!

You can do it easily by using the Import by default method in Jira.

Just go through the below link and import it in Jira.

• Importing data from CSV 

"Note:- At the time of import file format must be CSV and Field mapping details"

Please Accept the Answer If it helps you😊

If anything blocker happened, Please let me know.

Regards,

Sanjen Bariki

[Cailyn Steinhardt]

Thank you! That is helpful!

[Sanjen Bariki]

Hi @Cailyn Steinhardt ,

Thanks for your update!

If it helps you, Please accept the answer.

I will be happy and It would be grate for others for solution.

Advance Thanks.

Regards,

Sanjen Bariki

[Kai Becker]

Hi @Cailyn Steinhardt ,

thanks for your question. Is is totally possible by using the CSV import.
It is in easy process, that lets you map the data from the import file to jira fields.
You can find the detailed documentation on the import feature here.

It will guide you through all the steps, one by one. With this method it is also possible to make updates to issues, but I would not recommend that.

If you have any questions to add, please feel free to ask. 

[Cailyn Steinhardt]

Thank you! That is helpful! I was only finding articles on how to do it through the cloud version so I will take a look at the link you sent.