There are a few ways to convert CSV files to Excel files (.xlsx, .xlsm). But you can do it by using the windows command line. Additionally, it has you can edit the CSV file according to the need you want to export data in an Excel file. This tutorial will show you how to convert CSV to xlsx using the windows command line.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
8 Easy Steps to Convert CSV to XLSX Command Line
In the following image, we have provided a data set of a CSV file. Firstly, we will type Visual Basic Script (VBS) codes in the Notepad application. Then, we will save them in .vbs format. Later on, we will use the VBS code file in the windows command line and link them with the CSV file and convert them into an Excel file (.xlsx)
Step 1: Save CSV File
- Save your CSV file (source) in a specific folder.
Step 2: Open Notepad from Windows
- From the search menu, open the Notepad application.
Step 3: Insert VBS Code for Command Line to Convert CSV to XLSX
- Paste the following (Visual Basic Script) VBS code in Notepad. There are options to alter column width, freeze pane, apply Filter, give a colorful Header, and more in the VBS codes
'====================================== ' Convert CSV to xlsx Command Line '====================================== srccsvfile = Wscript.Arguments(0) tgtxlsfile = Wscript.Arguments(1) 'Create an Excel worksheet where you want to place the file On Error Resume Next 'Set a variable and define Set ObjectiveFileExcel = GetObject(,"Excel.Application") 'If condition for creating new instance if the find is not found If Err.Number = 429 Then '> 0 'Set a command to create new instance Set ObjectiveFileExcel = CreateObject("Excel.Application") End If ObjectiveFileExcel.Visible = false ObjectiveFileExcel.displayalerts=false 'Give a command to import CSV into Excel Set ImportWbk = ObjectiveFileExcel.Workbooks.open(srccsvfile) Set ImportWbk1 = ImportWbk.Worksheets(1) 'Set a command to adjust column widths Set ObjectiveRng = ImportWbk1.UsedRange ObjectiveRng.EntireColumn.Autofit() ' ObjectiveFileExcel.Columns(intColumns).AutoFit() 'Next 'Give TRUE statement to set the column Headings Bold ObjectiveFileExcel.Rows(1).Font.Bold = TRUE 'Give TRUE statement to freeze panes for the Header Row With ObjectiveFileExcel.ActiveWindow .SplitColumn = 0 .SplitRow = 1 End With ObjectiveFileExcel.ActiveWindow.FreezePanes = True 'Apply AutoFilter to Heading Row ObjectiveFileExcel.Rows(1).AutoFilter 'Make Header row Interior Cyanide ObjectiveFileExcel.Rows(1).Interior.ColorIndex = 31 'Save the worksheet ImportWbk1.SaveAs tgtxlsfile, 51 'Make free the Lock on worksheetsheet ObjectiveFileExcel.Quit() Set ImportWbk1 = Nothing Set ImportWbk = Nothing Set ObjectiveFileExcel = Nothing
Step 4: Save VBS File
- Then, type .vbs with the file name.
- Select All Files from the Save as type.
- Click on Save.
Step 5: Add a Destination Excel File
- Place your destination Excel file (converted) in the same folder. This is the Excel file where you export data from the CSV file.
Step 6: Open Windows Command Line Box to Convert CSV to XLSX
- Press Shift + right-click .
- Select the Open PowerShell window here option to open the windows command line.
Step 7: Insert Command Line to Convert CSV to XLSX
- In the windows command line box, paste the following command.
- Finally, press Enter to run the command.
Step 8: Final Result
- Therefore, open the Excel file (converted). You will see the data in CSV (source) file is now converted to Excel (.xlsx) file with the applied editing with the Visual Basic Script (VBS).
I hope this article has given you a tutorial about converting CSV files to the xlsx files using the windows command line. All of these procedures should be learned and applied to your dataset. Take a look at the practice workbook and put these skills to the test. We’re motivated to keep making tutorials like this because of your valuable support.
If you have any questions – Feel free to ask us. Also, feel free to leave comments in the section below.
We, the Exceldemy Team, are always responsive to your queries.
Stay with us & keep learning.