How to Save a Notepad file as Microsoft Excel file


If you want to save a file in Notepad (or Notepad++ or any other text editor) as a Microsoft Excel file that has to be a .csv extension (Comma Separated File)

To make sure columns are separate from each other you would have to make use of commas and to separate lines make use of the Enter key (adds a new line)

Example:
SrNo, Name, Age
1, Sam, 20
2, Alex, 21
3, Sandra, 21
4, Mike, 20

The first line (optional) could be the header.

Make sure to save this file as filename.csv (select save as file: All types, or save the file within double quotes example: "myfile.csv")

Save the file as Excel using Notepad
Microsoft Excel File Preview

Though .xls and .xlsx are the file types primarily associated with Microsoft Excel, CSV should be by default opened with Excel Application.


This is not an AI-generated article but is demonstrated by a human on a Windows 11 device.

Please support independent contributors like Code2care by donating a coffee.

Buy me a coffee!

Buy Code2care a Coffee!

Facing issues? Have Questions? Post them here! I am happy to answer!

Author Info:

Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail: rakesh@code2care.org



















Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap