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

Get FREE Advanced Excel Exercises with Solutions!

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.

Download Workbook

3 Methods to Open CSV File with Columns Automatically in Excel

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 (3 Easy Ways)


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: How to Open Notepad or Text File in Excel with Columns (3 Easy Methods)


Similar Readings


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: Excel VBA to Read CSV File Line by Line (3 Ideal Examples)


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

Afia Kona
Afia Kona

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo