In Excel, we often use CSV files to import data from a large dataset. The CSV stands for Comma Separated Value. So, in a CSV file, the values are separated by a comma. You can create a CSV file in Excel by using several ways. In this article, we will learn 2 convenient ways to open CSV file without formatting in Excel. So, let’s start this article and explore these methods.
2 Simple Methods to Open CSV File in Excel Without Formatting
In this section of the article, we will learn 2 simple methods to open a CSV file without formatting in Excel. Let’s say, we have a CSV file as our dataset. Our goal is to open the CSV file without formatting in Excel.
1. Utilizing Open Command of Excel
Utilizing the Open command of Excel is one of the most efficient ways to open a CSV file without formatting in Excel. Let’s follow the steps mentioned below to do this.
Steps:
- Firstly, use the keyboard shortcut CTRL + O from your worksheet to open the following window.
- Now, select the Open tab.
- After that, choose the Browse option as marked in the following image.
Consequently, you will have the option to locate your CSV file from your hard drive.
- Next, locate your CSV file and select it.
- Subsequently, click on Open.
As a result, your CSV file will open without any formatting as demonstrated in the following image.
Read More: How to Open Notepad or Text File in Excel with Columns (3 Easy Methods)
Similar Readings
- How to View CSV File in Excel (3 Effective Methods)
- Difference Between CSV and Excel Files (11 Suitable Examples)
- Convert CSV to Excel Automatically with Easy Steps
- How to Convert CSV to XLSX Command Line (with Easy Steps)
- Excel VBA: Read a Text File Line by Line (6 Related Examples)
2. Opening CSV File Using File Explorer
Using the File Explorer option is another smart way to open CSV file without formatting in Excel. In this section of the article, we will discuss the detailed steps to do it.
Steps:
- Firstly, locate your CSV file from the hard drive of your PC.
- After that, select your CSV file.
- Following that, right-click on the CSV file and click on the Open with option.
- Then, select the Excel option as shown in the image below.
That’s it! Your CSV file will open without any formatting in Excel as shown in the following picture.
Read More: How to Open CSV File in Excel with Columns Automatically (3 Methods)
How to Open CSV File in One Column in Excel
While working in Excel, sometimes we need to open a CSV file where all the data are in 1 column. Here, we will learn how we can do this. But in all cases, it might not be the desired outcome. We often need to open the CSV file in multiple columns. Don’t worry! We will discuss that too. First, let’s follow the steps to open a CSV file where all the data are in 1 column.
Steps:
- Firstly, locate your CSV file from your hard drive and then select your file.
- After that, right-click on the CSV file and choose the Open with option.
- Now, select the Excel option as marked in the image below.
Consequently, you will see that your CSV file has opened in a single column as demonstrated in the following picture.
Now, let’s discuss the steps to open a CSV file in multiple columns.
- Firstly, locate your CSV file from your PC.
- After locating the CSV file, make sure to choose the Text Files options as marked in the image below.
- Then, select the CSV file and click on Open.
- Now, in the Text Import Wizard dialogue box, choose the Delimited option in the Original data type field.
- Following that, click on Next.
- Afterward, choose the Comma option in the Delimiters field and click on Next.
- Lastly, click on Finish.
Consequently, your CSV file will open in multiple columns as demonstrated in the following image.
Read More: [Solved:] Excel Is Opening CSV Files in One Column (3 Solutions)
Conclusion
So, these are the most common & effective methods you can use anytime while working with your Excel datasheet to open a CSV file without formatting in Excel. If you have any questions, suggestions, or feedback related to this article you can comment below. You can also have a look at our other useful articles on Excel functions and formulas on our website ExcelDemy.
Related Articles
- How to Fix CSV File in Excel (5 Common Problems)
- How to Merge Multiple CSV Files into One Workbook in Excel
- Excel VBA: Merge Multiple CSV Files into One Workbook
- How to Compare 2 CSV Files in Excel (6 Easy Ways)
- CSV File Not Opening Correctly in Excel (4 Cases with Solutions)
- Merge CSV Files into Multiple Sheets in Excel (with Easy Steps)