🤓VBA Convert XLSX to CSV File - Entire Directory🤓

Have you ever had to click on Save As for many files to change the file extension? This macro will go through each file in a target directory and save them all with a new extension. For example, changing from *.xlsx files to a *.csv file.

👇SUBSCRIBE & HIT THE 👍 BUTTON 👇

Do you have more to add? Let me know how you liked the video or if I need anything corrected in the comments below.

#excel #csv #vba #convert #xlsx #xls
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

TECH GEAR I USE DAILY

OTHER COURSES I CURRENTLY TEACH

Let's chat
#CommisionsEarned
As an Amazon Associate I earn from qualifying purchases.

[dasrotrad]

Just 4 likes? This is awesome. Thank you Mark!

[gmatree]

Thanks a ton!!!
I don't know anything about VBA and could still use it and get the job one.
Thanks Again!!!!

[pramodkoliar]

Hi Mark, excellent script. Can you modify the script where instead of opening the folder dialog box the script should automatically connect to the link of the folder saved in the local path ?

[joshcowper]

This is great! - Is there a way I can state the specific sheet-names I want it to convert?

Thanks Mark

[lunarlord]

THANKS FOR SAVING ME! Also, there is a way that makes columns separated with ";" and not with ", " ?

[shanukumar]

I want to convert .csv file to .xlsx . Could you please let me know what changes i can made in this code to work as per my requirement.

[CambodianTutorials]

thank you very much for the lesson. if you add a code for the subfolder, it would be much appreciated.

[aboubakrebenhaddou]

Question: if there are 3 populated sheet and I would like to have only sheet 3 to convert to CSV. what script would you add to make it happen Great tutorial!!!

[wheeler]

It seems the code website is dead, Please provide website site link or any think where we found the code.Thanks in advance

[rizkyerzaldilaga]

Hi Mark! thank you for the code! its really a time saving. Btw, how if I want to save the converted files into a new folder? could you please help me?

[mikelennon]

Not sure why I am only getting on worksheet converted while I have over 10 worksheets in my workbook to be converted to csv files? Your thoughts please.

[rameshalla]

that's great! is there any way to automatically select sub folders in the target folder

[BarBeCutieEver]

Disappointed that none of the links to this solution work. Hopefully you can reply with an updated link. Thanks.

[arthuroliveira]

Thanks a lot Mark!
One question. Some of the files i'm converting has alerts so when the macro open the files these alerts are preventing it to keep running. Is there a way to ignore these alerts so the macro run without any intervention?
Thanks again!

[dougfinlay]

Is it possible to bring back your code? It has been removed after all this time. Thanks.

[rafiqullah]

Can you give me new link for the code because the current link is not working.

[kevinlabore]

What would be needed to add /change so the source and destination paths/folders were different

[philiplyngholm]

Hi Mark. Could you add "Remove all filters" into the code. If there are any filters it will usually corrupt the csv output. Also there is no link for this code.

[vernongomes]

Hi Mark,

This worked for me, so thank you!

[fernand]

Run time error '91' occurred. Why?