Then choose the Destination location and press Finish.

Put a checkmark on Comma when the next wizard comes up.

As a consequence, the Convert Text to Columns Wizard appears.

Next, select the column (column A) that has comma-separated values.

Initially, open the CSV file with excel.

Here I will use the text to column function in excel to transform single columns data into multiple columns. This time I will convert CSV file data into multiple columns in excel. Insert ‘Text to Column’ Option to Convert CSV to Excel with Columns Later, format the data as per your requirement.Ģ. You can see data are separated into columns.

At last, you will see the above CSV file is transformed into an Excel file.Press Save when you are done with the process. After that, give a File Name and choose the Save as type: Excel Workbook (*.xlsx).Here, go to the location where you want to save the file. Next, from the Excel Ribbon, click on the File tab. As a result, the CSV file is now open in Microsoft Excel.Instead right-click on the file and go to Open with > Excel. Follow the below steps to perform the task. Now, I will convert the CSV file into an excel file. However, we can only see comma-separated values in Notepad. The data in the below file are separated into multiple columns. Suppose, we have the below CSV file opened with Notepad. Apply ‘Save As’ Option to Turn CSV Files into Excel Other than that, in excel files you can apply varied data representation techniques to understand the pattern of data more closely.ĥ Methods to Convert CSV to Excel with Columns 1. Unlike CSV files, you can do various calculations in excel files. These files can be opened through any spreadsheet software like Google Sheets, Open Office, or Microsoft Excel. What Is an Excel File?Įxcel files generated from Microsoft Excel mainly have a. Besides, we can open CSV files through spreadsheet applications such as Excel or Google Sheets. You can open a CSV file using simple text editors such as Notepad. This is a plaintext file format where data is separated by commas.

Convert excel into csv