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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.