How to Create a CSV File
The fastest way to create a CSV file is to type it in any text editor — comma between fields, newline between rows, save with a `.csv` extension. Below are five proven methods, from a hand-typed CSV to a generator that produces thousands of realistic rows in a click.
Method 1: A text editor (60 seconds)
Open Notepad, TextEdit, or VS Code. Type:
name,email,country
Ada,ada@example.com,UK
Grace,grace@example.com,US
Save as people.csv. Done. This is the most universal way to create a CSV.
Method 2: Excel
Enter your data in a worksheet. File → Save As → CSV UTF-8 (Comma delimited). Excel warns that formulas and formatting will be lost — that's expected; CSV is text-only.
Method 3: Google Sheets
Enter your data. File → Download → Comma-separated values (.csv). The download starts immediately and works on any device.
Method 4: Python
import csv
with open('people.csv', 'w', newline='') as f:
w = csv.writer(f)
w.writerow(['name', 'email'])
w.writerow(['Ada', 'ada@example.com'])
Method 5: A generator (for test data)
When you need realistic dummy data — 1,000 fake users, transactions, addresses — typing them is a waste of time. Use a free generator like CSV.si: define your columns, pick a row count, click Download. The file is ready in seconds, properly UTF-8 encoded with all edge cases handled.
Frequently asked questions
Do I need Excel to make a CSV?
No. Any text editor works, and free tools like Google Sheets and CSV.si require nothing installed.
What if my data contains commas?
Wrap those fields in double quotes: `"Hopper, Grace",grace@example.com`. Good tools handle this automatically.