<div>
You can do it with SoftInterface.com - Convert XLSX to CSV or a macro that you call via VBS<br />
<br />
Here is the former, if it doesn't work I can post a macro<br />
<a href="https://stackoverflow.com/questions/5256733/convert-xlsx-file-to-csv-using-batch" rel="ugc">https://stackoverflow.com/questions/5256733/convert-xlsx-file-to-csv-using-batch</a><br />
<a href="http://www.softinterface.com/Convert-XLS/Features/Convert-XLSX-To-CSV.htm" rel="ugc">http://www.softinterface.com/Convert-XLS/Features/Convert-XLSX-To-CSV.htm</a><br />

<pre><code id="code-20-42747493-1">&quot;c:\Program Files\Softinterface, Inc\Convert XLS\ConvertXLS.EXE&quot; /S&quot;C:\MyExcelFile.xlsx&quot; /F51 /N&quot;Sheet1&quot; /T&quot;C:\MyExcelFile.CSV&quot; /C6 /M1 /V</code></pre>
</div>


You can do it with SoftInterface.com - Convert XLSX to CSV or a macro that you call via VBS

Here is the former, if it doesn't work I can post a macro
https://stackoverflow.com/questions/5256733/convert-xlsx-file-to-csv-using-batch [https://stackoverflow.com/questions/5256733/convert-xlsx-file-to-csv-using-batch]
http://www.softinterface.com/Convert-XLS/Features/Convert-XLSX-To-CSV.htm [http://www.softinterface.com/Convert-XLS/Features/Convert-XLSX-To-CSV.htm]


"c:\Program Files\Softinterface, Inc\Convert XLS\ConvertXLS.EXE" /S"C:\MyExcelFile.xlsx" /F51 /N"Sheet1" /T"C:\MyExcelFile.CSV" /C6 /M1 /V

<div>
Hi Shaun<br />
<br />
VBS file would be good. &nbsp;I want to keep it as clean as possible. &nbsp;I don't really want to install any additional software.<br />
<br />
Regards<br />
<br />
<br />
Simon
</div>


Hi Shaun

VBS file would be good.  I want to keep it as clean as possible.  I don't really want to install any additional software.

Regards


Simon

Simon Allaway

<div>
so will I be able to use this in an unattended scenario as the main script will be working about 2am?
</div>


so will I be able to use this in an unattended scenario as the main script will be working about 2am?

<div>
sorry I will be adding this to a batch file that is set in the scheduled tasks
</div>


sorry I will be adding this to a batch file that is set in the scheduled tasks

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
Please can you help me convert a file call distlistcontacts.xlsx to distlistcontacts.csv located in c:\o365update\ via command prompt. &nbsp;I have tried a scripts on the web and cant get them to run. Excel is not installed on the pc where the batch file will be scheduled to run from .<br />
<br />
Regards<br />
<br />
<br />
Simon
</div>
</div>


Hi

Please can you help me convert a file call distlistcontacts.xlsx to distlistcontacts.csv located in c:\o365update\ via command prompt.  I have tried a scripts on the web and cant get them to run. Excel is not installed on the pc where the batch file will be scheduled to run from .

Regards


Simon

How to convert XLSX to CSV via command prompt?

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Disk Operating System (MS-DOS) was an operating system for x86-based personal computers, and traces of it are still found in the Windows operating system. DOS is still used in some embedded systems and for certain legacy 16-bit networks.

Microsoft DOS

A personal computer is a general-purpose computer whose size, capabilities and price make it useful for individuals, and is intended to be operated directly by an end-user with no intervening computer time-sharing models that allowed systems to be used by many people, usually at the same time. Personal computers may be connected to a local area network (LAN), either by a cable or a wireless connection, and through that to the Internet. A personal computer may be a laptop computer or a desktop computer running an operating system such as Windows, Linux or Macintosh OS.