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 be opened with Excel Application

-


Have Questions? Post them here!

Topics Coverage:


🎉 We are celebrating the 10th years of Code2care! Thank you for all your support!

We strongly support Gender Equality & Diversity.

Follow Us: GitHub | Facebook | Twitter | Instagram