A CSV file is just plain text. That means you don't need Excel or Google Sheets to create one. Notepad, or a fast online notepad, does the job in a few steps.
How to Create a .CSV File in Notepad
Jul 3, 20263 min read
What is a CSV file?
CSV stands for Comma-Separated Values. It stores data in rows, with each value in a row separated by a comma. Spreadsheet apps, databases, and scripts all read this format, which makes it one of the most common ways to move data between tools.
A simple CSV looks like this:
Name, Age, City
John,28, New York
Sara,24, London
Each line is a row. Each comma marks a new column.
Step-by-step: Create a CSV file in Notepad
Step 1: Open Notepad
Open Notepad on your computer, or use a free online notepad if you want to skip the desktop app.
Step 2: Type your column headers
Type your headers on the first line, separated by commas. For example:
Product, Price, Quantity
Step 3: Add your data
Add each row of data on a new line, keeping the same order as your headers.
Product, Price, Quantity
Laptop,850,5
Mouse,20,30
Keyboard,45,15
Step 4: Save the file with a .csv extension
Go to File, then Save As. In the "Save as type" dropdown, choose All Files. Name your file with a .csv extension, for example inventory.csv. If you skip this step, Notepad saves it as a .txt file, and it won't be read as a spreadsheet.
Step 5: Open and check the file
Open the file in Excel, Google Sheets, or any spreadsheet app to confirm the columns and rows line up the way you expect.
Common Mistakes to Avoid
Extra commas in a value. If a value itself contains a comma, wrap it in double quotes, like "New York, NY". Otherwise it splits into two columns by mistake.
Inconsistent columns. Every row needs the same number of values as the header row. A missing comma throws off the whole row.
Wrong file extension. Saving as .txt instead of .csv means spreadsheet apps won't open it correctly.
Extra spaces after commas. Some tools read a space after a comma as part of the value. Keep commas tight against the next value unless your target app expects spaces.
Quick tips
Keep one row per line. Don't split a row across two lines.
Use a header row so anyone opening the file knows what each column means.
If you're building a large CSV, write it in a spreadsheet app first, then export to CSV, rather than typing hundreds of rows by hand.
Already have data in Excel and need it as CSV, or the other way around? Use a free CSV to Excel converter instead of retyping everything.
Conclusion
A CSV file is nothing more than comma-separated text saved with the right extension. Notepad handles it without any extra software. Type your headers, add your rows, save it as .csv, and it's ready to open in any spreadsheet tool.