automatically convert csv file to excel file?

Get help. Get answers. Let others lend you a hand.

Moderator: Mr_Noodle

Anyone know if there is a way to use hazel to automatically convert a csv file to an excel file.

use case example:

download a csv file from a bank
want to change the file into an excel file (and move to another folder, etc.)

there is a hazel command to open a file - so can use "open file with application" command to open the csv file

but cannot figure out way to have hazel automatically save the file with an "xls" or "xlsx" extension... (and would prefer not to have manually save the opened csv file with the excel extension)

also cannot just rename the csv file / change the csv extension to xls or xlsx (the renamed file with the excel extension will not open in excel...). seems like have to open the csv file and resave with an excel extension in order to have it be able to be opened by excel in future (i.e., cannot just rename in finder - or have hazel rename it)

maybe need an applescript to have file opened/ then saved with excel extension?
corylusman
 
Posts: 2
Joined: Sun Sep 30, 2012 2:57 pm

Yes, Applescript is most likely needed to "drive" Excel in this case. You might want to hunt around to see if such a script already exists.
Mr_Noodle
Site Admin
 
Posts: 11872
Joined: Sun Sep 03, 2006 1:30 am
Location: New York City


Return to Support