The problem is simple: You have multiple CSV files of the same structure (e.g. from running SQL queries or other exports), but you need to combine them before you can process and analyze them in Excel, R, or an analytics tool.
CSV Merger does the merging for you and removes redundant headers as well. If you want to remove “NULL” values from columns, you can do that as well.
hello,
I just bough CSV Merger on the Mac App Store…
and
noticed that it wouldn’t take my .tsv files (which are like CSV files but with tabulation separated values instead of commas)
is there a quick fix for that ?
all the best,
Xavier
Hi!
You could try replacing the tab characters with commas (e.g. via BBEdit) and saving the file as CSV. (You might have to think about enclosing fields in quotes in case they contain commas.)
Hope this helps!
Hey. Would be great if you could add drag and drop support for Mac?