How to open a CSV file in Excel

Modified on Mon, 19 Apr 2021 at 02:54 PM

 



 



HOW to Open a CSV File In Excel?

 

Steps on how to open a CSV file in Excel:

This article shows how to properly open CSV files in Excel which usually has an issue in older excel versions, without the need to convert any part of the data manually:

 

1. Open a new Excel document and navigate to the Data tab.



 

2. Click From Text.

 



3. Navigate to the CSV file you wish to open and click Import.



4. From the newly-opened window, choose Delimited. Then click Next.


 




5. Check the box next to the type of delimiter – in most cases this is either a semicolon or a comma. Then click Next.
 



6. Click Finish.
 



That’s it; you have just imported a CSV file to Excel!

 

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article