How to open a CSV File in Excel Without Formatting – 2 Methods

Method 1 – Utilizing the Open Command of Excel

Steps:

• Press CTRL + O to open the following window.

• Select Open.
• Choose Browse.

• Locate your CSV file.

• Select the CSV file.
• Click Open.

This is the output.

Read More: How to Open CSV with Delimiter in Excel

Method 2 – Opening a CSV File Using the File Explorer

Steps:

• Locate your CSV file.
• Select it.

• Right-click the CSV file and click Open with.
• Select Excel.

This is the output.

Read More: How to Open CSV File in Excel with Columns Automatically

How to Open a CSV File in One Column in Excel

Steps:

• Locate your CSV file.

• Right-click the CSV file and click Open with.
• Select Excel.

Your CSV file is displayed in a single column.

To open a CSV file in multiple columns:

• Locate your CSV file.

• Choose Text Files.
• Select the CSV file and click Open.

• In the Text Import Wizard, choose Delimited in Original data type.
• Click Next.

• Choose Comma in Delimiters and click Next.

• Click Finish.

Your CSV file is displayed in multiple columns.

Read More: [Solved:] Excel Is Opening CSV Files in One Column

Download Practice Workbook

Related Articles

• CSV File Not Opening Correctly in Excel
• How to Read CSV File in Excel
• How to Open CSV File with Columns in Excel
• How to Open Large CSV Files in Excel
• How to View CSV File in Excel

<< Go Back to Open CSV in Excel | Import CSV to Excel | Importing Data in Excel | Learn Excel