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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,460,036
Community Members
 
Community Events
176
Community Groups

How to merge multiple CSV files into one CSV file

I have 3 CSV files with more than 2000 issue's.in order to import that I need to merge 3 CSV files into one CSV file right how can i do that.

2 answers

Hi @Aravind Koushik Gobburu 

Can I clarify what you mean by merge 3 CSV files?

Is this more complicated than copying/pasting the data from 2 of the files into the main file (and ensuring all the field columns match up)?

I would be cautious having 2000 Issues in one file though, it might be less load/safer to do it in batches.

Ste

Ismael Jimoh Community Leader Apr 07, 2022

Also @Aravind Koushik Gobburu as mentioned by each of the users if you are importing the same header row then directly copying the data below the header of each of the other would help.

If it’s something else then clarify because in such a case I will always suggest merging into a new CSV so you do not corrupt the source files.

Most importantly, here I will suggest using Excel to copy whole columns and paste similar to another excel containing the CSV you are interested in.

Like Tessa Tuteleers likes this
1 vote
Tessa Tuteleers Community Leader Apr 07, 2022

Hi @Aravind Koushik Gobburu , 

I guess mapping the columns would be the problem here. I would think the easiest way to do it is import the CSV's in excel, merge then while mapping the columns and export to CSV again. 

Not really a CSV expert though, but 2000 lines would be easy to handle in excel. 

Hope it helps! 

- Tessa

Rob Horan Community Leader Aug 12, 2022

I am about to post a similar question.  Do you have any guidance on how to do this in Excel?

Hi @Rob Horan 

It depends on the size.

Honestly, I find unless it's huge (30+ exports), or extensive from a field perspective (i.e all fields export), it can be easier to just...

  1. Export each query
  2. Merge them into one Excel tab
  3. Manually align the columns

To help with (3), I either place the top row (with the field names) at the bottom of each exported list also, or hide the results. Makes for a quicker refinement.

If I'm doing regular exports though, which are large and complex, I'd use the REST API instead.

Ste

Rob Horan Community Leader Sep 09, 2022

Hi Stephen,

Its not that simple.  That I can handle.  This required Python, Pandas... all the animals

Suggest an answer

Log in or Sign up to answer