Simple. Everyday. Automation.

Merge CSV Files into One CSV File

Merge CSV Files

I used Retrievem to merge the 37 CSV files

Task: Combine 37 comma separated values files (.CSV) into one

Challenges:

  • Cross-reference each component in the CSV files with a Master list of components
  • Remove duplicates after the merge
  • Generate two reports: a component list; a missing components list

Since the client just wanted two clean files, I was free to use my software to automate the merge. (Otherwise, I would have had to write a macro for him to be able to it on his computer.)

[ws_table id=”1″]