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")

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

Click To Load Comments