nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

CSV Import

unknown

I'm having problems importing excel files to jira when the excel files contains more than 250 rows.

Atteched is a image of the validation data. Is there any way i can import more than 250 issues?

Accepted answers

Tim Perrault

Hi @[deleted]

If you are a site admin you can use the External System Importer to bypass the 250 limit.

Once your CSV file has been prepared, log into your Jira Cloud site as a Jira administrator to start the import process.
Upload your file

Choose

> System.

In the Import and Export section, click External System Import and then click CSV.

Choose your CSV source file.

Leave the Use an existing configuration file option unchecked if you do not have a configuration file or if you want to create a new one. Configuration files specify a mapping between column names in your CSV file's header row and fields in your Jira site. At the end of the CSV import process, Jira will create a configuration file that you can use for subsequent CSV imports.

Expand the Advanced section to change the file encoding (UTF-8 by default) and CSV delimiter. If your CSV file uses a separator character other than a comma, specify that character in the CSV Delimiter field.

Click Next.

Thanks,

Tim

Bastian Stehmann

Hi @[deleted],

Welcome to the community.

As the error says, jira is configured that only 250 issues can be imported at once. You need administrator permissions (or ask your administrator), to change this settings. Another way would be to import the csv in the system settings are, there is no such limit, but you need administrator permission again.

Or you split your csv in multiple files and import one after the other.

All comments

Tim Perrault

Hi @[deleted]

If you are a site admin you can use the External System Importer to bypass the 250 limit.

Once your CSV file has been prepared, log into your Jira Cloud site as a Jira administrator to start the import process.
Upload your file

Choose

> System.

In the Import and Export section, click External System Import and then click CSV.

Choose your CSV source file.

Click Next.

Thanks,

Tim

Bastian Stehmann

Hi @[deleted],

Welcome to the community.

Or you split your csv in multiple files and import one after the other.

unknown

Thanks!!!

unknown

Thanks!

unknown

I made the upgrade to 2 Gb but I'm stilll having problems import files with more than 250 rows. Is there any other change in settings I could do?

Tim Perrault

Is it still the same error?

Abdallah Soaody

Hi @Tim Perrault & @Bastian Stehmann

Do you know why it takes so much time to import issues form csv? I'm importing 16 issues and it's 37% completion after 2 hours!!

Ying Yin

Hello,

We’re looking for feedback on a feature we’re building, and would love to invite you to take part in an upcoming customer study!

What’s involved in the research:

Sessions are 1 hour and conducted over video-conference, so you can participate from anywhere around the globe.
During the research, we'll start with a general chat to get to know you, then, you might explore a prototype and complete some tasks.
As a token of our appreciation, you'll receive an e-gift card worth $100 USD within 5 business days of completing your session.

Interested in taking part? Follow this link https://www.userinterviews.com/projects/MKTtUWU-Sg/apply to fill in a few more details so we can make sure you’re a good fit.

If you have any other questions at all, feel free to reply to this message or email me directly on yyin@atlassian.com. We look forward to meeting you!

Cheers,

Ying

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

atl-gruland