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.