But in some times, you want to convert the single sheet into CSV file, in this case, the Split Workbook utility of Kutools for Excel can help you. Click OK, now the Excel files in the folder have been converted to CSV files and saved in another folder.Īs we known, we only can convert the whole workbook into one CSV file in Excel with its Save As function. Click OK, then in the second popping dialog, select the folder to place the CSV files.Ħ. Press F5 key, select the folder contains the Excel files you want to convert to CSV files in first popping dialog.ĥ. XObjWB.SaveAs Filename:=xStrCSVFName, FileFormat:=xlCSVĪpplication.Calculation = xlCalculationAutomaticĤ. XStrCSVFName = xStrSPath & Left(xStrEFFile, InStr(1, xStrEFFile, ".") - 1) & ".csv" XStrSPath = xObjSFD.SelectedItems(1) & "\" XObjSFD.Title = "Kutools for Excel - Select a folder to locate CSV files" Set xObjSFD = Application.FileDialog(msoFileDialogFolderPicker) XStrEFPath = xObjFD.SelectedItems(1) & "\" XObjFD.Title = "Kutools for Excel - Select a folder which contains Excel files" Set xObjFD = Application.FileDialog(msoFileDialogFolderPicker) VBA: Batch convert Excel files to CSV Sub WorkbooksSaveAsCsvToFolder()Īpplication.Calculation = xlCalculationManual Copy below code and paste them to the new Module window. Click Insert > Module to create a new Module.ģ. Enable Excel, and press Alt + F11 keys open Microsoft Visual Basic for Applications window.Ģ. In Excel, there is no built-in function can solve this job quickly except VBA.ġ.
In Excel, we can convert the workbook to CSV file with the Save as function, but could you know how to batch convert multiple Excel files to separate CSV files? In this article, I introduce a VBA code to batch convert all Excel files in a folder to CSV files in Excel.īatch convert Excel files of a folder to CSV files with VBAĬonvert sheets of workbook into separate CSV files with Kutools for Excel How to batch convert multiple Excel files to CSV files in Excel?
0 kommentar(er)
