lightinger.blogg.se - Coolutils total excel converter

SoftInterface's " Convert XLS" can use Excel (but is not required) and is more expensive ($500+), but supports more formats and has more options. "c:\Program Files\CSV Converter\csvcnv.exe" c:\base\*.csv c:\exports\ /TOXLSX /SRCHDR " Advanced CSV Converter" ($40-200) is a portable EXE that can do it quickly and without Excel having to be installed. It can recurse sub-directories, delete original CSV files, combine all files to one document, and more. 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.įor Windows? CoolUtils " Total CSV Converter" command line version supports many output formats including JSON, Access, DBF, XML & SQL and is only $40. Note that I haven't written any code to do these things (yet) I am just offering ideas for a starting point. You could even add a simple message box that offers a choice of either xls or xlsx as each file is opened.

Create a VBA program within an Excel Spreadsheet: VBA could automatically opens each CSV file and then saves it to an Excel format.

A Simple Batch File: That batch file could use wild cards and/or a for each loop structure to open each of the CSV files for you and then you could manually process them as before.

Then for each file you can select "File" and "Save as" and finally choose the new file format you want it saved to.

No Precoding: Use Windows Explorer to navigate to the CSV files use whatever method works best to select the files to be converted (lasso, ctrl+a, ctrl+click, shift+click) then right click one of the selected files and click on Open.

I can think of three routes to go depending on the ratio of upfront work to clean-up work you are willing to do. There is a lot left unsaid in your question.Īssuming that your CVS files are in a directory structure similar to c:\randompath\CSV\Īnd you want to end up with c:\randompath\XLS\ via pip)įor r, row in enumerate(reader, start=1):

Ran in the directory with all the CSV files, it will convert them all and slap a ".xls" onto the end.įor Excel 2007+ (xlsx files) supporting up to about 1 Mrows: import os Assuming you like and have Python (for some reason), you could use this script I whipped up: import osįor csvfile in glob.glob(os.path.join('.', '*.csv')):