Buzz
CSV stands for Comma Separated Values, a simple text format where values are separated by commas. Both CSV and Excel are file types used for storing data in spreadsheet format. However, CSV has its own advantages and disadvantages compared to Excel software. CSV files are lightweight and the data recording process is simpler. However, CSV lacks the ability to create charts and preserve formatting. Nevertheless, there are cases where users need to convert from CSV to Excel format. Today, Software Tips will guide you through some methods to convert CSV to Excel.
How to open CSV files directly in Excel and save using Save As
Step 1: In the directory where the CSV file is saved, right-click on it and select Open with (1), then choose Choose another app (2). If your computer already has Excel as an option like in the image below, simply select Excel.
Step 2: The selection window appears, choose to open with Excel (1) => then press OK (2).
Step 3: The CSV file is opened with Excel, but the format remains CSV.
Step 4: Select File (1) => Save as (2) => Choose the folder where you want to save the Excel file (3).
Step 5: The Save As window appears, in the Save as Type section, choose the file format you want to convert to: .xls or .xlsx.
The result is the creation of an additional Excel file:
Convert CSV file within Excel as external data
Step 1: Open a new Excel spreadsheet. Select any cell where you want to input data from the CSV or TXT.
Step 2: Select the Data (1) tab -> choose Get External (2) -> then select From Text (3).
Step 5: Choose Delimiters (you can select multiple items) as the character to separate columns. For example, Ad chooses the comma to separate content by commas into individual cells. Check the data preview in the bottom window to ensure it meets your requirements, then press the Next button.
Step 6: You can adjust the format of each data column by clicking on each column and checking Column data format.
- General: default format;
- Text: text format;
- Date: date format;
- Do not import column (skip): do not transfer this column to the Excel table.
After you finish adjusting, press Finish.
