Bulk Convert CSV to Excel Files?

[rdanella]

Hello!

I have a few hundred CSV files that I need to convert to excel files. They are all in the same folder. Is it possible to convert an entire folder at once?

[PhilipMannering]

You could use this CSV to Excel macro,

[rdanella]

Thank you for sharing, but I am having some troubles getting this to work. I have associated the folder I want in directory but keep getting the following error:

CSV to Excel (2) Record #3: Tool #1: CSVFile: A field was missing a closing quote in record 3: ...ing or exceeding our overall team goals.

[PhilipMannering]

Can you share the offending CSV file? You may have to change some of the configuration settings of the Input Data Tool inside the macro...

[alteryxokan]

This is amazing thank you very much! Is there way to set output location as well?