How to Convert CSV to XLSX without Opening (5 Easy Methods)

Method 1 – Use of Text Import Wizard to Convert CSV to XLSX without Opening

Steps:

• From the Data tab >>> select From Text/CSV.

The Import Data dialog box will open.

• Select the file named “convert-csv-to-xlsx.csv” and click Import.

A new window will appear.

• From Load >>> select “Load To…”.

Select the output location.

• Click on “Existing worksheet:” and point to cell A1.
• Click OK.

The CSV file will be converted to XLSX file format.

Read More: How to Convert CSV to XLSX

Method 2 – Convert CSV to XLSX without Opening by Using Legacy Wizard

Steps:

• Press ALT + F + T to bring up the Excel Options window.
• From Data >>> check “From Text (Legacy)” and click OK.

• From the Data tab >>> Get Data >>> Legacy Wizards >>> select From Text (Legacy).

Import the file again.

The Text Import Wizard window will pop up.

• Check “My data has headers” and click on Next.

• Choose Comma as Delimiter and click Next.

• Click on Finish.

Set the output location as cell A1 in Sheet2.

• Click OK.

The final output will be as shown in the following image.

Read More: Convert CSV to Excel Automatically

Method 3 – Convert CSV to XLSX without Opening by Using VBA Code

We’ll use VBA code to convert CSV files. We will define our input and output files. However, this code is only for a single file.

Steps:

• Select the file and from the Home tab >>> select Copy path.

This will copy the location of the file.

• Open the Module window and enter the following code.

Sub CsvToXlsxConversion2()
Dim w As Workbook
  Set w = Workbooks.Open("C:\Users\Rafi\OneDrive\Desktop\Softeko\36\convert-csv-to-xlsx.csv")
  w.SaveAs Filename:="C:\Users\Rafi\OneDrive\Desktop\Softeko\36\convert-csv-to-xlsx.xlsx", _ 
      FileFormat:=xlWorkbookDefault, _ 
      ReadOnlyRecommended:=False, CreateBackup:=False
End Sub

• Save and Run the Module.

The CSV file will be converted to XLSX.

Read More: How to Convert CSV to Excel with Columns

Method 4 – Applying VBA Code to Convert Multiple CSV Files to XLSX without Opening

Steps:

• From the Developer tab >>> select Visual Basic.

• From Insert >>> select Module.

• Enter the following code.

Sub CsvToXlsxConversion()
Dim f As FileDialog
Dim fPath As String
Dim csvFile As String
Dim ws As String
Application.DisplayAlerts = False
Application.StatusBar = True
ws = ActiveWorkbook.Name
Set f = Application.FileDialog(msoFileDialogFolderPicker)
f.Title = "Select a folder:"
If f.Show = -1 Then
fPath = f.SelectedItems(1)
Else
Exit Sub
End If
If Right(fPath, 1) <> "\" Then fPath = fPath + "\"
csvFile = Dir(fPath & "*.csv")
Do While csvFile <> ""
Application.StatusBar = "Converting: " & csvFile
Workbooks.Open Filename:=fPath & csvFile
ActiveWorkbook.SaveAs Replace(fPath & csvFile, ".csv", ".xlsx", vbTextCompare), xlWorkbookDefault
ActiveWorkbook.Close
Windows(ws).Activate
csvFile = Dir
Loop
Application.StatusBar = False
Application.DisplayAlerts = True
End Sub

• Save the Module.
• Click anywhere in the code and press Run.

It will ask to select a folder.

• Select a folder and click OK.

We have two files with XLSX format in that folder (it can vary depending on the number of CSV files you have in that folder).

Open any file to check if the data conversion has been done correctly.

Read More: Difference Between CSV and Excel Files

Method 5 – Utilizing Command-Line to Convert CSV to XLSX

Steps:

• Enter the following code in the notepad.

sourceFile= Wscript.Arguments(0)
targetFile = Wscript.Arguments(1)
On Error Resume Next
Set tExcel = GetObject(,"Excel.Application")
If Err.Number = 429 Then
Set tExcel = CreateObject("Excel.Application")
End If
tExcel.Visible = false
tExcel.displayalerts=false
Set tWorkbook = tExcel.Workbooks.open(sourceFile)
Set tWorksheet1 = tWorkbook.Worksheets(1)
Set tRange = tWorksheet1.UsedRange
tRange.EntireColumn.Autofit()
tExcel.Rows(1).Font.Bold = TRUE
tWorksheet1.SaveAs targetFile, 51
tExcel.Quit()

• Select All Files in “save as type:”.
• Save it as “vbs” filename.

• From the Start Menu >>> open Command Prompt.

• Enter the following code and press ENTER.

CD "C:\Users\USER\Desktop\Exceldemy"

This will set our directory to our working folder.

• Add this code.

conversion "C:\Users\USER\Desktop\Exceldemy\convert-csv-to-xlsx.csv" "C:\Users\USER\Desktop\Exceldemy\converted-using-cmd.xlsx"

This code will run our “conversion.vbs” file. In our code, the first location is the input and the second one is the output file.

• Press ENTER.

Open the “converted-using-cmd.xlsx” file to verify it.

Read More: How to Import CSV Data into Excel

Convert CSV Incorporating Online Converter

You can also use websites like Cloud Convert to convert your file.

Steps:

• Go to the website.
• Select your file.

• Click on Open.

• Select XLSX as the output format and click on Convert.

• Click on Download.

The output will look like the image below.

Read More: How to Convert CSV to XLSX Command Line

Download Practice Workbook

Related Articles

• How to Open Notepad or Text File in Excel with Columns
• How to Import Text File to Excel Automatically
• How to Import CSV into Existing Sheet in Excel
• How to Compare 2 CSV Files in Excel

<< Go Back to How to Convert CSV to Excel | Import CSV to Excel | Importing Data in Excel | Learn Excel