Ben Hamilton

Convert multiple Microsoft Excel files to .csv files with 3 clicks

I often get given Microsoft Excel files to import them into a database. Normally we’ll work with the files in the Excel to clean up data (phone numbers, Addresses, Titles, etc) but then save them as .csv files to do the actual import.

On my MacBook this is now an easy task because I’ve setup a ‘Service’ with Automator. In Finder I simply select the files I want converted, right click, select Services and select Convert Excel to csv files. Job done. Heaps quicker than doing them one at a time.

Screenshot of Convert Excel files to csv service in Automator

Screenshot of Convert Excel files to csv service in Automator

Screenshot showing service in use

Screenshot showing service in use

This entry was posted in How to and tagged , , . Bookmark the permalink. Follow any comments here with the RSS feed for this post. Both comments and trackbacks are currently closed.