Excel - Export worksheets to csv files
Convert Excel worksheets to csv files in batch
This script will process each
.xlsx file located in a specific folder (f.i.
c:\temp\input), start MS Excel, open each file in Excel and save each visible worksheets as a
.csv file in a second folder (like f.i.
- The original file will remains unchanged
- Only visible worksheets will be saved as
Table of Contents
Get a raw copy of
xls2csv.vbs and save it onto your disk.
If you want, get also a copy of
xls2csv.cmd and save it in the same folder.
With the xls2csv.vbs only
- Start a DOS prompt
- Go to the folder where you've saved the
cscript xls2csv.vbsand specify the folder where you've your
.xlsxfiles and where you want to save the generated
.csvfiles like, f.i.,
cscript xls2csv.vbs c:\temp\input c:\temp\output
With the xls2csv.cmd
- Edit the
xls2csv.cmdfile in Notepad
- Modify the path to
xls2csv.cmdthe input and output folders
- Save the file
- From now, just double-click on the
xls2csv.cmdto execute it.