Read this article to get detail information to change excel file format. It is very useful requirement in various excel projects. Most of the excel reports uses input from csv files. Several times we need to convert .csv files into .xls or xlsx which is very tedious task. Usually, it consumes lot of hours for file conversion. However, we can simply automate this file conversion task writing excel VBA code. which we save couple of hours. Given below is simple example to convert .csv file into excel: Sub Convert_CSV_To_Excel() ' Author: Dreams24 ' Written for VBA Tricks and tips blog ' https://www.vbatricksntips.com ' Convert each csv file to excel from given list of files Dim fName As String Dim Dir_Path As String Dim New_fName As String Application.ScreenUpdating = False Application.DisplayAlerts = False 'Folder path where .csv file is available Dir_Path = "C:\Users\Dreams\Desktop\Blog" & "\" 'Name of .csv file to convert fName ="abc.csv" 'Open .csv file Workbooks.Open Dir_Path & fName 'Save file into .xls format ActiveWorkbook.SaveAs Filename:=Dir_Path & New_fName & ".xls", _ FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False ActiveWorkbook.Close Application.ScreenUpdating = True Application.DisplayAlerts = True End Sub
These are the main file formats in Excel 2007_2013: 51 = xlOpenXMLWorkbook (without macro's in 2007_2013, xlsx) 52 = xlOpenXMLWorkbookMacroEnabled (with or without macro's in 2007_2013, xlsm) 50 = xlExcel12 (Excel Binary Workbook in 2007_2013 with or without macro's, xlsb) 56 = xlExcel8 (97_2003 format in Excel 2007_2013, xls) Important to know this because SaveAs requires you to provide both the FileFormatparameter and the correct file extension.
You can convert multiple files using File Format Converter Add_ins at once:
I have created File Format Converter Add_ins which will help you to convert multiple file at once. Please refer to Download Section.