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.
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.
➤ 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.
➤ 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.
➤ Here, we re-arrange this table by deleting Column1, Column2, Column3, and Column4.
Finally, we can see the table in Excel.
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.
➤ Here, we re-arrange this table by deleting Column1, Column2, Column3 and Column4.
Finally, we can see the table in Excel.
Read More: How to Open Notepad or Text File in Excel with Columns (3 Easy Methods)
Similar Readings
- How to Import Text File to Excel Automatically (2 Suitable Ways)
- Excel VBA: Import Comma Delimited Text File (2 Cases)
- How to Import CSV into Existing Sheet in Excel (5 Methods)
- Excel VBA to Convert CSV File to XLSX (2 Easy Examples)
- How to Convert CSV to XLSX without Opening (5 Easy Methods)
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.
➤ 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.
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.
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.