Mighty Merge is an online tool that instantly merges csv files into one master file. Includes both vertical and horizontal merging with smart headers for automatically detecting csv file structure during merge.
Hello Product Hunt Peeps!
So I used to work with tons of data a long time ago and would get these massive lists of csv files that needed to be merged. The problem was these files would be delivered completely out of whack (e.g. scrambled columns or completely missing columns, etc.). For those of you familiar with merging csv files this is a huge hassle!
Now there are tools that can help like power query for excel or creating your own custom scripts via bash or python etc., but what if you don't want all that hassle and just want to get it done?
Well, in comes Mighty Merge:)
Key features:
- 100% privacy. All files are merged right in your browser (absolutely ZERO files are uploaded anywhere)!
- Files do not require matching columns nor matching case in order to be merged correctly.
- Ability to merge vertical or horizontal.
Vertical merge example:
[File1.csv]
Id,ProductId
1,200
2,300
[File2.csv]
ProductId,Name,Id
400,NameFor400,3
500,NameFor500,4
Final output would be...
[Output.csv]
Id,ProductId,Name
1,200,""
2,300,""
3,400,NameFor400
4,500,NameFor500
Horizontal join example:
[File1.csv]
Id,ProductId
3,400
4,500
[File2.csv]
Name,Id
NameFor400,3
NameFor500,4
Final output would be...
[Output.csv]
Id,ProductId,Name
3,400,NameFor400
4,500,NameFor500
Analytics Bar