How to merge multiple CSV files into one CSV file

[Aravind Koushik Gobburu]

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.

[Ste Wright]

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]

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.

[Tessa Tuteleers]

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]

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

[Ste Wright]

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]

Hi Stephen,

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