How to Convert CSV to XLSX (4 Quick Methods)

Are you worried about your CSV file converting into XLSX file? No worries! You have come to the right place. There are several ways to do it but here I’ll show 4 quick ways to convert CSV to XLSX with clear steps and vivid illustrations.


Download Practice Workbook

You can download the free Excel template from here and practice on your own.


4 Ways to Convert CSV to XLSX

First, get introduced to my CSV file that is opened in Notepad. It represents some fruit prices for three consecutive months. CSV stands for Comma Separated Value. So have a look at my dataset, the values are separated with commas.


1. Use Open with from File Explorer to Convert CSV to XLSX

In our very first method, we’ll convert the CSV file to XLSX by opening it with File Explorer in Excel. Because if you open it in Excel then Excel will show it as a spreadsheet.

Steps:

  • Right-click on your CSV file.
  • Then click as follows from the Context menu: Open withExcel.

Use Open with from File Explorer to Convert CSV to XLSX

Now see, Excel is showing it as an XLSX spreadsheet. Keep in mind that no formats of Excel can be saved in CSV files. And if you close the Excel window then it will remain the same as the CSV file. To save it as an XLSX file, go forward to the next section.

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


2. Apply Save As Option to Convert CSV to XLSX

Here we’ll learn how to Save as an XLSX file after conversion from CSV using the Save As option.

Steps:

  • Click on File beside the Home tab.

Apply Save As Option to Convert CSV to XLSX

  • Later, click on Save As from the appeared options.

Apply Save As Option to Convert CSV to XLSX

Soon after a dialog box will open up.

  • Select Excel Workbook(*.xlsx) from the File type drop-down box.
  • Then just press Save.

Now see the image below, the file is converted to an XLSX file in the same folder with the same name.

Read More: Excel VBA to Import CSV File without Opening (3 Suitable Examples)


Similar Readings


3. Use Text Import Wizard Feature

By using the Text Import Wizard feature we can import the CSV file as text in Excel by which Excel will convert it into a spreadsheet.

Steps:

  • Open the Excel app.
  • Next, click as follows: Data Get Data Legacy Wizards From Text (Legacy).

Use Text Import Wizard Feature

  • Select the CSV file from the specific folder.
  • Then press Import and the 3 steps Text Import Wizard will appear.

Use Text Import Wizard Feature

  • Mark Delimited from the first step and press Next.

Use Text Import Wizard Feature

  • Form the second step, mark Comma, and press Next again.

Use Text Import Wizard Feature

  • In the final step, mark General and press Finish.

  • Then from the Import Data dialog box, select your desired worksheet. I marked the Existing worksheet.
  • Finally, just press OK.

Then you will get the output like the image below.

Read More: Excel VBA: Import Comma Delimited Text File (2 Cases)


4. Open Power Query to Convert CSV to XLSX

Excel Power Query has a lot of versatile operations. It can be used to convert CSV files to XLSX too. It takes pretty much more steps compared to the previous methods but may be helpful for some particular cases.

Steps:

  • Open the Excel app first.
  • After that, click as follows: Data From Text/CSV.

Open Power Query to Convert CSV to XLSX

  • After appearing the Import Data dialog box, select your CSV file.
  • Then click Import.

Open Power Query to Convert CSV to XLSX

  • Here, select Comma from the Delimiter dropdown box.
  • Select Based on the first 200 rows from the Data Type Detection. It is the default option, you can change it as your requirement.
  • Finally, click Load.

Open Power Query to Convert CSV to XLSX

It is now loaded as a Table in the worksheet. We can easily convert it to a normal range.

Open Power Query to Convert CSV to XLSX

  • Click any data from the dataset.
  • Next, click as follows: Table Design Convert to Range.

Here’s the converted normal range.

Read More: Excel VBA to Convert CSV File to XLSX (2 Easy Examples)


Conclusion

I hope the procedures described above will be good enough to convert CSV to XLSX. Feel free to ask any question in the comment section and please give me feedback.


Related Articles

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo