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

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?
gregfthompsonAsked:
Who is Participating?
 
OddyWriterConnect With a Mentor Mr.Commented:
I'm not sure for this solution.
1. Press Shift and right-click on the folder of your xlsx files.
2. Select "Open Command Window Here".
3. Type Command

ren *.xlsx *.csv
0
 
Máté FarkasDatabase Developer and AdministratorCommented:
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.
0
 
Pawan KumarDatabase ExpertCommented:
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
gregfthompsonAuthor Commented:
Thank you.
Quite brilliant!!
0
 
Máté FarkasDatabase Developer and AdministratorCommented:
What???
0
 
AlanConsultantCommented:
Hi Greg,

You have marked as 'best' a solution that *seems* very unlikely to work - please can you confirm?

Thanks,

Alan.
0
 
Pawan KumarDatabase ExpertCommented:
Hi Greg,

Can you please explain how that works for you ?
0
 
gregfthompsonAuthor Commented:
It appeared to work. In that the suffix changed to .csv. And the csv file opened correctly within excel.
But when I attempted to use DOS to copy them i.e. copy *.csv Combined.csv - the result was symbols.
So it would appear it only changes the suffix and the resulting combined csv is unreadable in excel.
0
 
AlanConsultantCommented:
Hi Greg,

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).

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.

Alan.
0
 
gregfthompsonAuthor Commented:
Hi Alan,

Thanks for your note.

I will atempt to contact the moderators and ask them to change the answer selected.

I found a solution here:
http://www.rondebruin.nl/win/addins/rdbmerge.htm 
It has worked perfectly.
Greg
0
 
AlanConsultantCommented:
Good find - Mark your answer as 'best' and any others that helped as 'assisted' to close the question.


Thanks,

Alan.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.