Open CSV File in Excel Without Formatting (2 Easy Ways)

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.

Table of Contents hide

Download Practice Workbook

2 Simple Methods to Open CSV File in Excel Without Formatting

1. Utilizing Open Command of Excel

2. Opening CSV File Using File Explorer

How to Open CSV File in One Column in Excel

Conclusion

Download Practice Workbook

Opening CSV File Without Formatting.xlsx

Sample CSV File.csv

Sample Text File.txt

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.

Similar Readings

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.

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.

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.