Sample CSV File Download

CSV (Comma-Separated Values) is the standard format for data exchange between software systems. It works with Microsoft Excel, Google Sheets, and every major SQL database including PostgreSQL, MySQL, and SQLite.

Technical Standards

While many variations of CSV exist, our files follow the RFC 4180 standard. This means features like multi-line fields and quoted delimiters work correctly in most parsers.

• RFC 4180 Compliance: Proper use of double-quotes to escape special characters and commas within fields.
• UTF-8 Encoding: All downloads are encoded in UTF-8 without BOM to prevent compatibility issues in Linux and macOS environments.
• Line Ending Consistency: Files use standard Unix-style (LF) line endings, but are easily convertible to Windows (CRLF) via Excel.

For deep technical details, refer to the RFC 4180 CSV Specification or the Wiki Guide to CSV .

CSV files are the most commonly used format for data exchange between spreadsheet applications, databases, and programming environments. Below are four complete, runnable examples for the most important use cases.

How to Open a CSV File in Python with pandas

The pandas library is the standard tool for reading and analyzing CSV data in Python. It loads the entire file into a DataFrame, making filtering, aggregation, and export straightforward.

import pandas as pd

# Read the sample CSV file
df = pd.read_csv("sample-users.csv", encoding="utf-8")

# Display the first 5 rows
print(df.head())

# Filter only female records
female_users = df[df["gender"] == "Female"]
print(female_users[["first_name", "email"]])

How to Parse a CSV File in JavaScript (PapaParse)

PapaParse is the most reliable CSV parser for JavaScript and handles quoted fields, multi-line values, and streaming out of the box. It works in both the browser and Node.js.

// Browser usage with PapaParse
// <script src="https://unpkg.com/papaparse/papaparse.min.js"></script>

Papa.parse("sample-users.csv", {
  download: true,
  header: true,
  dynamicTyping: true,
  complete: function (results) {
    results.data.forEach((row) => {
      console.log(row.first_name, row.email);
    });
  },
});

How to Import a CSV File into Microsoft Excel

Open Excel and go to the Data tab. Click Get Data > From File > From Text/CSV. Select your downloaded sample file. In the import wizard, confirm that the Delimiter is set to Comma and the File Origin is set to 65001: Unicode (UTF-8). Click Load to populate the spreadsheet with the parsed data.

How to Load a CSV File into a PostgreSQL Database

PostgreSQL's built-in COPY command is the fastest way to seed a database table from a CSV file. The file must match the column order of an existing table exactly.

-- Create a matching table first
CREATE TABLE users (
  id SERIAL,
  first_name TEXT,
  last_name TEXT,
  email TEXT,
  gender TEXT,
  ip_address TEXT,
  registration_date DATE
);

-- Import the CSV (skip the header row)
COPY users(id, first_name, last_name, email, gender, ip_address, registration_date)
FROM '/path/to/sample-users.csv'
DELIMITER ','
CSV HEADER;

Creating a CSV file manually or programmatically is simple, but getting the quoting rules right is essential. A single unescaped comma inside a field value will break the column alignment for every row that follows it.

Creating a CSV File Manually in a Text Editor

Open any plain text editor and save the file with a .csv extension. The first line is the header row. Each subsequent line is one data record. Wrap any field that contains a comma, a newline, or a double-quote in double quotation marks. Escape a literal double-quote inside a quoted field by doubling it.

id,name,department,salary
1,Alice Johnson,Engineering,125000
2,Bob Smith,"Sales, EMEA",85000
3,Carol White,"HR & ""People"" Dept",105000

Generating a CSV File in Python

Python's built-in csv module handles all quoting and escaping automatically. Use the csv.writer class and let it decide when to apply quotes.

import csv

rows = [
    ["id", "name", "department", "salary"],
    [1, "Alice Johnson", "Engineering", 125000],
    [2, "Bob Smith", "Sales, EMEA", 85000],
    [3, "Carol White", 'HR & "People" Dept', 105000],
]

with open("output.csv", "w", newline="", encoding="utf-8") as f:
    writer = csv.writer(f)
    writer.writerows(rows)

print("CSV file created successfully.")

Generating a CSV File in JavaScript (Node.js)

const fs = require("fs");

const rows = [
  ["id", "name", "department", "salary"],
  [1, "Alice Johnson", "Engineering", 125000],
  [2, "Bob Smith", "Sales, EMEA", 85000],
];

// Wrap fields containing commas in double quotes
const escape = (v) => (String(v).includes(",") ? '"' + v + '"' : v);
const csv = rows.map((r) => r.map(escape).join(",")).join("
");

fs.writeFileSync("output.csv", csv, "utf8");
console.log("CSV file created successfully.");

Common mistakes to avoid: Never mix line endings (CRLF on Windows versus LF on Linux) within a single file — this causes row-count mismatches in some parsers. Always include the header row as the first line. Never leave trailing spaces after commas, as some parsers include them in the field value. If your data contains commas, always quote the field rather than escaping the comma with a backslash.