This macros will bulk covert csv to xlsx in Excel. First, save csv to txt (just changing name.csv to name.txt in totalcommaner or similar, bulk in one click). Place to CSVfolder = "C:\csv\txt\" ,output will be here XlsFolder = "C:\csv\xlsx\"

bulk_convert_csv_to_xlsx.vbs

Private Sub CommandButton2_Click()
Dim CSVfolder As String, _
    XlsFolder As String, _
    fname As String, _
    wBook As Workbook

 CSVfolder = "C:\csv\txt\"
 XlsFolder = "C:\csv\xlsx\"

 fname = Dir(CSVfolder & "*.txt")

 Do While fname <> ""
    Set wBook = Workbooks.Open(CSVfolder & fname, Format:=4)
    wBook.SaveAs XlsFolder & Replace(fname, ".txt", ""), xlOpenXMLWorkbook
    wBook.Close False
    fname = Dir
 Loop
End Sub