How to import the data from CSV file in Excel
CSV refers to the Comma Separated Values, which indicates the method of storing data. CSV file is basically a comma-separated value file that saves the tabular data in plain text. It is used by many popular spreadsheet programs, such as Excel spreadsheets and Google spreadsheets.
CSV data is plain text values separated by comma but stored in tabular form.
CSV file is a simple text file that does not contain any formatting, editing, macros, or maths operations. Besides that, the CSV file does not allow data manipulation. Therefore, CSV files are also known as flat files. It stores the data in tabular form, same as Excel and its extension is .csv.
Why CSV data need to import in Excel file
CSV file is a simple text file that does not contain any formatting, editing, macros, or maths operations. CSV files are also called as flat files because CSV file does not allow data manipulation. So, you have to import the data to an Excel sheet to perform manipulation on data.
Import the CSV file data to the Excel worksheet, then you are allowed to perform operations on it. We have discussed the steps for importing data to an Excel file with the help of an example.
This chapter will show you how easily Excel users can import the CSV file data into an Excel worksheet. Let’ see how it can be done.
Steps to import CSV data to Excel file
Following are the steps to import the CSV file data into Excel file:
Step 1: First of all, open a blank Excel file and navigate to the Data tab in the Excel menu bar.
Step 2: In the Data ribbon, you will see a Get Extern Data dropdown button; click on it.
Step 3: From this dropdown list, click on the From Text option. From text option will allow importing plain text data (CSV data) to the Excel sheet.
Step 4: Browse the CSV file in your system folder, select it and click on the Import button at last.
Now, you have to complete three steps:
- Choose the file type that can best describe your data and specify if the data has a header.
- Set the delimiters that your data will contain in Excel.
- Set the column data format to General.
Step 5: A text import wizard will open. Here, chooses the file type Delimited that will best describe our data.
In the same wizard, mark the “My data has header” and then click on the Next button.
Step 6: Set the comma delimiter here. Mark the Comma checkbox and see the preview how data will be visible in the Excel worksheet after importing. Click the Next button.
Step 7: In the third/last step, set the column format to General by marking the radio button and Finish the task.
Step 8: A new popup panel will open where select the cell from where you want to import the CSV file data and click on the OK button.
You can also select another cell back on the Excel worksheet from where the CSV file will start importing.
Step 9: Your CSV file data has been successfully imported to the Excel file. Now, you are allowed to data manipulation operations on it.
CSV file data has been imported in different columns as you have marked the Comma delimiter checkbox in step 6.
What if do not mark comma delimiter option?
In case you do not mark the comma delimiter, all the data of a row will insert into a single column separated by a comma, as shown in the below preview section.
See how data will look like after importing in Excel worksheet. It is not so readable because everything is adjusted in a single column.
How CSV file is different from Excel file
CSV file and Excel worksheet both are used for storing the data in tabular form. But both have some differences; see the list below:
|CSV file||Excel file|
|CSV file is a simple plain text file, which stores data in tabular form that does not contain formatting, editing, macros, or maths operations.||Excel file stores data in tabular form, which can have formatting, macros, manipulation operations on data.|
|CSV file does not allow data manipulation. For performing operations on CSV data, you have to import it to an Excel sheet.||Unlike CSV files, Excel allows to perform data manipulation on its data.|
|CSV files can be edited by any text editor, like Notepad, Wordpad.||Excel files cannot be edited in any text editor. It means that Excel can only be opened in MS Excel only.|
|CSV files are easy to manipulate programmatically because these are simple text files.||As a developer, it is not easy to manipulate the Excel file programmatically because Excel is propriety.|
|CSV file restricts to perform various functionalities on its data.||Excel allows data manipulation as well as fetch data from external sources.|
|In the CSV file, you cannot add charts or graphs. It simply stores each record as one line of text file separated by a comma.||In the Excel file, you can add charts, graphs and add formatting to the Excel data.|
|.csv is the extension of CSV file.||.xls or xlsx is the file extension of Excel file.|