I am looking for a way to quickly convert a directory of .csv files into the .xls or .xlsx format (would be nice if I could do either/or).
Is there an easy way to do this or do I need to install a third party program?
Assuming you like and have Python (for some reason), you could use this script I whipped up:
Ran in the directory with all the CSV files, it will convert them all and slap a ".xls" onto the end.
For Excel 2007+ (xlsx files) supporting up to about 1 Mrows:
Here is a perl script that supposedly does it, but it does seem like a lot of work to do something that is already built into Excel.
There is a lot left unsaid in your question.
Assuming that your CVS files are in a directory structure similar to
and you want to end up with
I can think of three routes to go depending on the ratio of upfront work to clean-up work you are willing to do.
Note that I haven't written any code to do these things (yet) I am just offering ideas for a starting point. Perhaps if you could give more details about what you want you could get more detailed explanations for how to handle approach from me or another forum member.