OnlineNotes Logo

    How to Create a CSV File in Notepad (Windows, Mac and Online)

    Make a CSV file in Notepad in four steps: type the rows, Save as, pick All files, add .csv. Plus the encoding fix for accents in Excel and the mistakes that break columns.

    By Amit Yadav • November 15, 2026 • 5 min read

    A CSV file is plain text. Each line is a row, and commas split the row into columns. That means any plain text editor can make one, including Windows Notepad, Mac TextEdit or the notepad on this site. You do not need Excel.

    Step by step in Windows Notepad

    1. Open Notepad (press the Windows key, type Notepad, press Enter).
    2. Type the header row, then one line per record:
    name,email,city
    Asha Rao,[email protected],Pune
    Ben Ortiz,[email protected],Austin
    1. Press Ctrl + Shift + S (or File, Save as).
    2. Set Save as type to All files (*.*), type a name that ends in .csv, such as contacts.csv, and click Save.

    If you skip step 4, Notepad saves contacts.csv.txt, and Excel opens it as one long column. If you cannot see file extensions in File Explorer, turn them on with View, Show, File name extensions.

    Accents and other languages: pick the right encoding

    Windows 11 Notepad saves as UTF-8 by default. Most apps read that fine, but Excel on Windows can show José instead of José when it opens a UTF-8 file without a marker. The fix is in the same Save as dialog: set Encoding to UTF-8 with BOM. The BOM is a hidden marker at the start of the file that tells Excel which encoding to use.

    Use plain UTF-8 (no BOM) when the file goes to a database, a script or a web app, as some of them treat the marker as part of the first column name.

    Rules that keep the columns straight

    • A comma inside a value needs quotes. Write "Pune, India" with double quotes, or the city splits into two columns.
    • A quote inside a quoted value is doubled. "She said ""hi""" is read as She said "hi".
    • Every row needs the same number of commas. An empty value is still a comma: Ben,,Austin.
    • No spaces after commas unless you want them in the data. Asha, Pune stores Pune with a leading space.
    • One record per line. Do not wrap long lines by hand.

    Make a CSV on a Mac with TextEdit

    TextEdit saves rich text by default, which is not a CSV. Before you type, choose Format, Make Plain Text (Shift + Command + T). Type the rows, then File, Save. Name the file contacts.csv, and if asked, choose Use .csv. Untick “If no extension is provided, use .txt” if it is shown.

    Make a CSV online without installing anything

    On a Chromebook, a work laptop that blocks apps, or a phone, you can use the online notepad:

    1. Type or paste your rows.
    2. Open Export and, under Save as any file type, enter csv.
    3. Click Save. The file downloads as your-note-title.csv, ready for Excel or Google Sheets.

    Your text stays in your browser. Nothing is uploaded.

    Turn a list into CSV rows faster

    If your data is a column of values (from an email, a PDF or another sheet), the comma separator joins it into one comma separated line, and add prefix and suffix can wrap every line in quotes. Remove empty lines clears blank rows before you save.

    Quick checks before you send the file

    • Open it in Notepad again. If you see one record per line and the same number of commas on each, the file is fine.
    • Open it in Excel or Google Sheets. Each value should sit in its own column. If everything is in column A, the extension is wrong (.txt) or your region uses semicolons as the list separator.
    • In some European regions, Excel expects semicolons instead of commas. Either use ; between values or import the file with Data, From Text/CSV and pick comma as the delimiter.

    Tools to use with this guide

    Keep this workflow practical with these related utilities.