ConvertToCSV And Merge.app.zip

File uploaded by user28897 on Nov 9, 2018
Version 1Show Document
  • View in full screen mode

Hello everyone.   I got tired of dealing with so many excel files and needing to merge them instead of uploading one at time I decided to do a little apple scripting.   Well after searching around for a way to merge multiple files all with the same headers I found a way to merge them online only if csv files.   So I took that and a bit of code from somewhere else I used before to save files as csv and viola.   It's a simple application built in automator that will let you select a folder full of excel files, converts them to csv first then prompts you to choose the folder full of csv files to merge into a file called merged.csv.

 

All you guys  have been so helpful and I thought I would return the favor for those that need it.

 

Cheers

Outcomes