How to Open CSV File in Excel with Columns Automatically (3 Methods)

There are several methods to open a CSV file in Excel with columns automatically. Among them, we will demonstrate to you 3 methods to do the task effortlessly.


How to Open CSV File with Columns Automatically in Excel: 3 Easy Methods

We have a CSV file where the following Employee List table shows Id No, Name, Age and Salary columns. We want to convert this CSV file in Excel with columns automatically by using 3 simple and easy methods. Here, we used Excel 365. You can use any available Excel version.

Open CSV File in Excel with Columns Automatically


Method-1: Using From Text Option

In this method, we will use the From Text option to open a CSV file.

➤ First of all, we will open a worksheet in Excel > go to the Data tab > select From Text/CSV option.

how to open csv file in excel with columns automatically

➤ After that, we will select our Book1, and click on Import.

Now, we can see a Book1.CSV window appears.

➤ We will select Delimiter as Comma.

how to open csv file in excel with columns automatically

➤ Now, we will click on Load > Load To.

An Import Data window will appear.

➤ We will select Existing worksheet > click on the up arrow to give a location > click OK.

Now, we can see the table in the Excel column.

how to open csv file in excel with columns automatically

➤ Here, we re-arrange this table by deleting Column1, Column2, Column3, and Column4.

Finally, we can see the table in Excel.

how to open csv file in excel with columns automatically

Read More: How to Open CSV File with Columns in Excel


Method-2: Using Data Tab to Open CSV File in Excel

➤ First of all, we open a blank worksheet > select Data > click on Get Data.

➤ After that, select From File > select From Text/CSV.

Now, our CSV file will appear.

➤ We select Book1, and click Import.

Now, a Book1.CSV window will appear.

➤ We will select Comma as Delimiter > select Load > select Load To.

After that, an Import Data window will appear.

➤ We will select Existing worksheet > click on the up arrow to select the location > click OK.

Now, we can see the table in our Excel columns.

how to open csv file in excel with columns automatically

➤ Here, we re-arrange this table by deleting Column1, Column2, Column3 and Column4.

Finally, we can see the table in Excel.

how to open csv file in excel with columns automatically

Read More: Open CSV File in Excel Without Formatting


Method-3: Open Multiple CSV Files in Excel at Once

In this method, we can open multiple CSV files in Excel.

Here, we want to open 2 CSV files in Excel.

➤ First of all, we will open a workbook > select the File tab.

how to open csv file in excel with columns automatically

➤ Then, we will select Open.

Here, we can use the keyboard shortcut CTRL+O to get the Open option.

We will now choose our files from our required folder.

➤ Now, we will choose Text Files > we will choose Book1, and Book2 > click Open.

We will see a Text Import Wizard window appear for Book2.

➤ After that, we will click on My data has headers > Click Next.

➤ We will mark Comma and Tab > click Next.

After that, we can see the preview of the data.

➤ Click Finish.

how to open csv file in excel with columns automatically

Finally, we can see the table of Book2 in our Excel columns.

After that, another Text Import Wizard window appears for Book1.

➤ Now, we will select My data has headers, and click Next.

➤ We will mark on Tab and Comma > Click Next.

we can see the Data preview.

➤ After that, we will click on Finish.

Finally, we can see the table in Excel columns.

how to open csv file in excel with columns automatically

Read More: How to Open CSV with Delimiter in Excel


Download Workbook


Conclusion

Here, we tried to show you 3 methods to open a CSV file in Excel with columns automatically. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, feel free to know us in the comment section.


Related Articles


<< Go Back to Open CSV in Excel | Import CSV to Excel | Importing Data in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

3 Comments
  1. Thank you so much for teaching me how to load a .csv on Excel.

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo