How to convert a CSV file to Excel

CSV stands for Comma Separated Values, which is a simple text format where values ​​are separated by commas. Both CSV and Excel are files that help store data in spreadsheets. However, CSV also has advantages and disadvantages compared to Excel software. The CSV file is lightweight, and the data recording process is simpler, but CSV is not capable of drawing charts and formatting. However, there are cases where users are required to convert from a CSV file into Excel format. Today, Dexterity Software will guide you some ways to convert CSV to Excel.

How to convert a CSV file to Excel Picture 1

How to open a CSV file directly in Excel and save as Save As

Step 1: In the directory to save the CSV file, right-click and select Open with (1) , select Choose another app (2) . If your computer already has the Excel option available as shown in the image below, click Excel.

How to convert a CSV file to Excel Picture 2

Step 2: The selection window appears, select the item to open using Excel software (1) => click the OK button (2) .

How to convert a CSV file to Excel Picture 3

Step 3: The CSV file is opened by Excel software but the format remains the same.

How to convert a CSV file to Excel Picture 4

Step 4: Choose File (1) => Save as (2) => Select the folder where you need to save the Excel file (3) .

How to convert a CSV file to Excel Picture 5

Step 5: Save As window appears, in the Save as Type section select the file format that you need to convert .xls or .xlsx.

How to convert a CSV file to Excel Picture 6

The result is an extra Excel format file:

How to convert a CSV file to Excel Picture 7

Convert CSV file in Excel as external data

Step 1 : You open a new Excel spreadsheet. You select any cell that you want to import data from CSV or TXT.

How to convert a CSV file to Excel Picture 8

Step 2 : Select Data tab (1) -> select Get External (2) -> and then select From Text (3) .

How to convert a CSV file to Excel Picture 9

Step 3: The Import Text File window appears, navigate to the CSV file to be converted, select the file and click the Import button .

How to convert a CSV file to Excel Picture 10

Step 4: The Import Text Wizard window appears.

Select Delimited and Start import at row 1 if Excel does not select it first. If your data has a title then select My data has headers , otherwise uncheck it.

The window below will show before the first items in the CSV file. Click the Next button .

How to convert a CSV file to Excel Picture 11

Step 5: You choose Delimiters (can select multiple items) as the characters that convention to split columns. For example, Ad select comma (comma) as a convention character separating content separated by commas into cells. You check the data preview in the bottom window has met your requirements, then press the Next button .

How to convert a CSV file to Excel Picture 12

Step 6: You can adjust the format of each data column by clicking on each column and selecting Column data format .

1. General : the default format;
2. Text : text format;
3. Date : date format;
4. Do not import column (skip) : do not move this column to Excel table.

How to convert a CSV file to Excel Picture 13

After adjusting, click Finish .

Step 7: The Import Data window appears to select the location for the imported data. Since I have chosen from Step 1 , now I just press OK to confirm.

How to convert a CSV file to Excel Picture 14

And this is the result:

How to convert a CSV file to Excel Picture 15

Column B, C, D format Text, year of birth is not converted into Excel files because I choose Do not import column. You can now use Excel's built-in tools to handle spreadsheets.

Note: Excel cannot convert values ​​to exact dates.

In addition to the above two ways, you can use the online converter to follow the link: https://onlineconvertfree.com/vn/convert-format/csv-to-xls/

You only need to upload the CSV file and after the conversion is finished, you can download the Excel file to your computer Good luck!