How to Import CSV File in Excel: In this tutorial, you will learn How to import CSV files in Excel. But, before going into this, let's learn What is CSV file?
.png "How to Import CSV File in Excel")
What is CSV File?
CSV stands for Comma Separated Values. It is a simple text file in which data and records are separated by commas. It allows data to be saved in tabular format. The extension of a CSV file is always .csv.
Read more: How to Check Jio balance
How to Import CSV File in Excel
Importing and opening a CSV file in excel are two different things. When we open a CSV file in excel, all the values and data get separated by commas. But, when we import the CSV files into excel, all the values and data get separated in the form of a table.
If you want to open a CSV file in excel then you can simply click on it. It will get opened. But, If you want to import it into excel, then here is the guide.
Step-1: First of all, download and save the CSV file which you want to import into excel.
Step-2: Now, start excel with a blank workbook.
.png "How to Import CSV Files in Excel")
Step-3: Go to the Data tab and click on From Text/CSV under the Get & transform data group.
.png "How to Import CSV Files in Excel")
Step-4: Now, select the file and click on import.
.png "How to Import CSV Files in Excel")
Step-5: Finally, click on load to import all the data into a new excel worksheet.
.png "How to Import CSV Files in Excel")
In this way, the selected CSV file will get opened in the form of a table in excel.
Read more: How to delete a YouTube Channel
Post a Comment