VBA to Convert Excel File to CSV File and CSV to Excel File

We can convert and save Excel file to CSV and CSV file to Excel using VBA code or Macro. This example explains simple VBA Code to Open Excel file and then save as CSV file. Also how to change CSV file into Excel file.

[SajidAbbas-wcjb]

Appreciable, very easy to undersatand

[sanikanaik]

Amazing video very helpful... Can you please tell us how can we convert all files in the folder to binary format?

[evelyntan]

Hi, I would like to ask if I have more than two excel file change to CSV format. What should I need to add or change in your program?

[abigailbologa]

This is great for a noob like me. Thank you

[flemishlion]

Thank you for your tutorial.
I would like to use this could on a folder with for example 20 files with .xls extension and save them as .xlsx extension, how would I achieve this?

[rohithkumar]

Hi, this video is useful...can i have the video for converting Excel CSV file to excel binary workbook. main reason for my use is to reduce the file size of which contains nearly up to 4/5 gb to less than 50 kb -50 mb..

[bbabventures]

Hi, Can this be used to save as a text file also?

[trilochanjena]

bro can you guide to create a command button in userform asking to export in specific format ie either excel file or pdf format only.

[venu]

Thank You...How to convert vba file to excel..please let me know

[papakiawee]

hi sir. can i have a code for convertion for multiple file of csv convert to xlsx.. i only see 1 convertion per vba

[nvntckk]

Thank you. I tried to adjuste the Code to Chance the file from csv to Excel. But unfortunatily it not worked... please can you do it concrete ?

[jinkashivaprasad]

Hii shall we convert multiple files at time?

[DSN_INFO]

Hi after creating one copy how to stop this like if already csv file is present

[memadhav]

how to convert Excel file with multiple sheets? I want to convert multisheet workbook into csv(containing all the sheet data).

[limchunwei]

Hi, I want ask why I cannot save multiple sheets in single excel file by using the CSV format, after I click to save it, excel will pop out a dialogue, then I click yes. After I reopen it, just only one sheet had saved in my excel file. Otherwise, multiple sheets must be save respectively. Pls help

[kinzaabid]

Sir How to convert Excel 2007 VBA file to 'C'

[rajeshadam]

What is the code for convert multiple files

[MinuteProTrading]

I want excel to convert a particular range only from the file, how to specify the range

[etf]

Hi, is It the same for Excel to Text file?

[amritgoswami]

can you tell me excel to csv conversion. you just explain only excel to csv conversion