<div>
You don't need to convert first into intermediate separated csv files. You can convert them directly to one large csv file. This way you don't need to use DOS.
</div>


<div>
Please try with sometool.<br />
<br />
Please try this for free - <br />
<br />
1. <a href="https://convertio.co/xlsx-csv/" rel="ugc">https://convertio.co/xlsx-csv/</a>&nbsp;<br />
2. <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>
</div>


<div>
Thank you.<br />
Quite brilliant!!
</div>


<div>
Hi Greg,<br />
<br />
You have marked as 'best' a solution that *seems* very unlikely to work - please can you confirm?<br />
<br />
Thanks,<br />
<br />
Alan.
</div>


<div>
Hi Greg,<br />
<br />
Can you please explain how that works for you ?
</div>


<div>
It appeared to work. In that the suffix changed to .csv. And the csv file opened correctly within excel. <br />
But when I attempted to use DOS to copy them i.e. copy *.csv Combined.csv - the result was symbols. <br />
So it would appear it only changes the suffix and the resulting combined csv is unreadable in excel.
</div>


<div>
Hi Greg,<br />
<br />
That is because Windows / Excel recognised that the file was still an Excel file even though you had changed the extension (Excel was protecting you from doing something that that makes no sense).<br />
<br />
You should ask the moderators to reopen this question as the answer marked as correct is completely wrong and very misleading to anyone who comes along later and sees this.<br />
<br />
Alan.
</div>


<div>
Hi Alan,<br />
<br />
Thanks for your note.<br />
<br />
I will atempt to contact the moderators and ask them to change the answer selected.<br />
<br />
I found a solution here:<br />
<a href="http://www.rondebruin.nl/win/addins/rdbmerge.htm" rel="ugc">http://www.rondebruin.nl/win/addins/rdbmerge.htm</a>&nbsp;<br />
It has worked perfectly.<br />
Greg
</div>


<div>
Good find - Mark your answer as 'best' and any others that helped as 'assisted' to close the question.<br />
<br />
<br />
Thanks,<br />
<br />
Alan.
</div>


<div>
<div class="content wysiwyg-content">
I have a large number of xlsx files that I want to merge.<br />
And I thought the easiest way would be to convert them to csv and use DOS to merge the csv files.<br />
<br />
Is it possible to batch convert 22,000 xlsx files to csv?
</div>
</div>


I have a large number of xlsx files that I want to merge.
And I thought the easiest way would be to convert them to csv and use DOS to merge the csv files.

Is it possible to batch convert 22,000 xlsx files to csv?

Excel - batch convert 22,000 xlsx files to csv files

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.