Convert XLS to CSV on command line

by

Open Notepad, create a file called XlsToCsv.vbs and paste this in:

if WScript.Arguments.Count < 2 Then
    WScript.Echo "Error! Please specify the source path and the destination. Usage: XlsToCsv SourcePath.xls Destination.csv"
    Wscript.Quit
End If
Dim oExcel
Set oExcel = CreateObject("Excel.Application")
Dim oBook
Set oBook = oExcel.Workbooks.Open(Wscript.Arguments.Item(0))
oBook.SaveAs WScript.Arguments.Item(1), 6
oBook.Close False
oExcel.Quit
WScript.Echo "Done"

Then from a command line, go to the folder you saved the .vbs file in and run: 

XlsToCsv.vbs [sourcexlsFile].xls [destinationcsvfile].csv

This requires Excel to be installed on the machine you are on though.

More Related Contents:

  1. Which encoding opens CSV files correctly with Excel on both Mac and Windows?
  2. Windows batch script to parse CSV file and output a text file
  3. Permission denied when trying to import a CSV file from PGAdmin
  4. Batch file to split .csv file
  5. Cannot read unicode .csv into R
  6. VBA:IE-How to assign pathname to file input tag without popup file upload form?
  7. Using a custom Tee command for .bat file
  8. Hidden features of Windows batch files
  9. How to get list of arguments?
  10. How to run .sh on Windows Command Prompt?
  11. Graphviz: How to go from .dot to a graph?
  12. Run cURL commands from Windows console
  13. How can I uninstall an application using PowerShell?
  14. How do I add an icon to a mingw-gcc compiled executable?
  15. How to make git ignore changes in case?
  16. File paths in Windows environment not case sensitive?
  17. Monitoring certain system calls done by a process in Windows
  18. How to display japanese Kanji inside a cmd window under windows?
  19. How can I debug a .BAT script?
  20. Python 3.2 Unable to import urllib2 (ImportError: No module named urllib2) [duplicate]
  21. Start multiple tasks in parallel and wait for them in windows?
  22. Convert xlsx file to csv using batch
  23. How to write a multiline command?
  24. How to output something in PowerShell
  25. NPM package ‘bin’ script for Windows
  26. Is it possible to get the number of rows in a CSV file without opening it?
  27. Where can I download precompiled GTK+ 3 binaries or windows installer? [closed]
  28. How to update system PATH variable permanently from cmd?
  29. php-fpm for Windows?
  30. IE Enable/Disable Proxy Settings via Registry

Leave a Comment