Trying to combine Excel files

[tiepolo]

Hello, first post here. I have a report that I run that requires pulling data from several different .CSV files. Normally, I just copy the contents of the .CSV files and paste them into my master reports document. However, that's not efficient.

I tried creating an Automator action that is basically:
Open Excel Workbook > Find Finder Items > Import Text Files to Excel Workbook

All of that worked, but it created a new worksheet from each of the data sources. I want all of the data to be on one sheet. Is that possible?

 

[capetonian]

Funnily enough, the automator actions seem to be way more effective for Word docs. If you have files in CSV or simple text format, try using the automator to open them in Word (rather than excel), combine word files, then save the merged file back to CSV or simple text format. It should then be easy to open in Excel (depending, of course, on how fancy and how consistent your formatting is).