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-wc5jb]

Appreciable, very easy to undersatand

[@sureshbabu5687]

Tq Sir. Can you do a session about vb code to send a video file to whatsapp?

[@sanikanaik944]

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

[@abigailbologa4160]

This is great for a noob like me. Thank you

[@ExcelDestination]

Welcome

[@jinkashivaprasad6034]

Hii shall we convert multiple files at time?

[@manaswinisahoo4555]

Thanks for the video

[@paulinefroehlig142]

Thanks a lot! Super helpful

[@ExcelDestination]

You're welcome!

[@owen8092]

Thank you so much!!!

[@user-nv5nt7ck1k]

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 ?

[@capredo]

Tks

[@venu7745]

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

[@rohithkumar8006]

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

[@trilochanjena3836]

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.

[@rajeshadam2044]

What is the code for convert multiple files

[@30MinuteProTrading]

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

[@kinzaabid3786]

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

[@orayqt]

how to save as .csv utf-8

[@memadhav5617]

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

[@evelyntan5066]

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?

[@vijayakumarrajangam6021]

Pls confirm how to change .csv to .xlsb with the help of VB

[@ExcelDestination]

you need to modify the code little bit.

[@sakthi6469]

@@ExcelDestination How to do that

[@asifshaikh8412]

@@ExcelDestinationkindly guide what changes to do

[@papakiawee1495]

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

[@ExcelDestination]

you can watch tutorial to convert csv to excel and excel to csv at below link :
ruclips.net/video/VDN9w6PBZIQ/видео.html
For multiple files, you can send me email, I have a team to work on excel vba automation work.

[@DSN_INFO]

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

[@flemishlion9764]

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?

[@cerberus_uwu]

powershell

[@asifshaikh8412]

Csv to excel binary convert

[@limchunwei7799]

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

[@ExcelDestination]

You can use this code withing loop statement. However some r&d would be required by you. Try yourself. If not possible for you.........then send me email at [e-mail]

[@PujaKiPyaariDuniya]

How to ask the path of file from a user

[@amritgoswami4392]

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

[@ExcelDestination]

let me

[@etf3203]

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

[@ExcelDestination]

Logic would be same........with some different code.

[@talionisl8242]

Error 1004 bro,, when im done and double tap the Click to convert file

[@ExcelDestination]

without looking at code, can't say anything. you can share your code at [e-mail]

[@talionisl8242]

@@ExcelDestination i know now bro,,, thank you,, i just make small mistakes but now its perfect and i know

[@jonelatendido9836]

Private Sub CommandButton1_Click()
Dim wb As Workbook
Set wb = Workbooks.Open(Worksheets("Sheet1").Cells(2, 11).Value)
wb.SaveAs Filename:="C:\Users\Jonel Atendido\Desktop\csv2pdf\csv2pdf.csv", FileFormat:=xlCSV, CreateBackup:=False
wb.Close savechanges:=False
MsgBox ("workbook is converted into csv format")
End Sub

[@jonelatendido9836]

@@ExcelDestination Here is the command error 1004

[@chandrakantpatil9719]

Can we create a CSV file from excel with the values of the selected columns using VBA code? can you share code for the same?

[@ExcelDestination]

yes, we can do that. Let me share the code soon.

[@chilling54]

@@ExcelDestination i need the same can u give me dad code? thanks

[@bbabventures3961]

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