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 .
- General : the default format;
- Text : text format;
- Date : date format;
- 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!
You should read it
- Simple way to convert Excel files to PDF
- How to convert a Word file to Excel
- How to convert Word to a CSV file
- How to convert Excel files to PDF online using Google Drive
- How to Convert Excel to Dat
- How to convert Excel file to Google Sheets
- How to Convert Excel to Word
- How to convert Cad to Word, PDF, Excel
- How to convert AI files to PNG, JPG without software
- 2 ways to convert JPG image file to PDF
- What file is XLL? How to open, edit and convert XLL files
- How to convert CSV files to Excel in bulk