How to Open CSV Files in Excel

Opening a CSV File in Excel

Below are instructions for how to open a CSV file in Excel so that you don’t lose the TEXT formatting.

Step 1: Open Excel

Launch Excel on your pc.

Step 2: Go to the Data Tab

Click on the Data tab in the top menu bar.

Step 3: Import the File

Click on From Text/CSV and select your CSV file from your computer.

Csvtoexcel Step1

Step 4: Complete the Import

Follow the prompts and choose the comma as delimiter.

Csvtoexcel Step2

Step 5: Complete the Import

Click on load to complete the import. Your data will appear in Excel.

Tip: Save your imported data as an Excel file after opening it to avoid needing to repeat these steps.