While working on an Excel Worksheet, sometimes you may need to work with a set of information like customer information, product information, or contacts of students or others. These pieces of data need to be appropriately handled. As a result, you need to convert the excel file into a CSV file to preserve the contact information. In this article, I will show you how to view CSV file in Excel. This is a concise and precise process. Hopefully, this article will help you to enhance your skill.
Download Practice Workbook
Please download the workbook to practice yourself.
3 Effective Methods to View CSV File in Excel
Here, I will show three effective methods to view CSV file in Excel. I will consider a dataset of Customer Information of ABC Traders. The dataset has three columns, B, C, & D called Name, Id, and Email Id. This file was saved as a CSV file. Now, follow the steps of the three methods mentioned below to view the CSV file in Excel.
1. Using Windows Explorer Option to View CSV File in Excel
This is the first method of all three methods. Here, I will use Windows Explorer to view CSV file in Excel. Let’s follow the steps and have a look at the corresponding illustrations.
- First, select the CSV file saved on your computer.
- Then, Right click on it.
- Consequently, you will get the Open With option in the pop-up window.
- Then, click on the option.
- As a result, a window will open.
- After that, select the Excel application.
- As a consequence, you will find the result. After some edits, your result will look like the picture given below.
Read More: How to Open CSV with Delimiter in Excel (6 Simple Ways)
2. Viewing CSV File in Excel by Using Data Tab in Toolbar
This is the second method of this article. In this part, I will view the CSV file in Excel by using the Data Tab in the toolbar. Follow the steps given below.
- First, go to the Data Tab in your toolbar.
- Then, select the Get Data option.
- After that, from the pop-up window, select the From File option.
- After selecting the option, select the From Txt/CSV option.
- Then, a window will pop up to select the file.
- Hence, change the file type to text files.
- After that, select the desired file.
- Then click on the Import option.
- Now, A new window will open. Here, check the delimiter is set as a comma.
- Moreover, click on the Load option.
- As a result, you will get the data of the CSV file in Table format.
Read More: How to Open CSV File with Columns in Excel (3 Easy Ways)
- CSV File Not Opening Correctly in Excel (4 Cases with Solutions)
- Merge CSV Files into Multiple Sheets in Excel (with Easy Steps)
- How to Convert CSV to XLSX (4 Quick Methods)
- Excel VBA: Read Text File into String (4 Effective Cases)
- How to Open Notepad or Text File in Excel with Columns (3 Easy Methods)
3. Introducing a Keyboard Shortcut to View CSV File in Excel
This is the last method of this article. Here I will show a keyboard shortcut to view CSV file in Excel. Without any further delay, let’s follow the rules given below.
- First, open the Excel application.
- Then, press the CTRL+O button to open a file.
- After that, the window shown in the picture will appear. You will see the Open option is selected.
- Hence, select the Browse option.
- Before selecting a file, select the file type first. The file type will be Text Files.
- Then, select the desired file.
- After that, click on the Open button.
- At last, you will get the result. After a bit of editing, the result will be just like the picture given below.
Read More: How to Open CSV File in Excel with Columns Automatically (3 Methods)
How to Open Multiple CSV Files in Excel at Once
While working with CSV files, you may need to open two or three CSV files at once. So, you need to know how to open multiple CSV files simultaneously. In this portion of this article, I will show you how to open multiple CSV files in Excel at once. An easy method will be described here. Just follow the steps to learn the process.
- First, open the Excel application and press Ctrl+O.
- In the window, you will see that the Open option is selected. Click on the Browse option now.
- Then, select the file type as Text Files.
- After that, select the desired files by pressing Shift and the files.
- Click on the Open button.
- Hence, after some editing, you will get the first CSV file as an Excel file just like the picture given below.
- Again, after some editing, you will get the second CSV file as an Excel file just like the picture given below.
Read More: Excel VBA: Merge Multiple CSV Files into One Workbook
The Difference Between Opening and Importing CSV Files to Excel
Microsoft Excel uses your default data format options to determine how precisely to display each column of text data when you open a CSV file. In most cases, this is effective. Importing is preferable to opening if your text file contains specific values and you want to manage how Excel displays them.
Things to Remember
- The second method is used to keep the exact formatting of the CSV file.
In this article, I have tried to explain how to view CSV file in Excel. I hope, you have learned something new from this article. Now, extend your skill by following the steps of these methods. You will find such interesting blogs on our website Exceldemy.com. I hope you have enjoyed the whole tutorial. If you have any kind of queries feel free to ask me in the comment section. Don’t forget to give us your feedback.
- How to Import CSV into Existing Sheet in Excel (5 Methods)
- Excel VBA: Read a Text File Line by Line (6 Related Examples)
- How to Convert CSV to XLSX Command Line (with Easy Steps)
- Excel VBA to Read CSV File into Array (4 Ideal Examples)
- [Solved:] Excel Is Opening CSV Files in One Column (3 Solutions)
- Difference Between CSV and Excel Files (11 Suitable Examples)