Random CSV - Complete Guide

Random CSV generator creates sample CSV files with realistic data for testing imports, data pipelines, and spreadsheet functionality. Configurable columns, data types, and row counts. Essential for QA testing and development.

How It Works

Define schema: column names and data types (string, number, date, email, etc.). Generator creates specified number of rows with random values matching each column's type. Output follows CSV format with proper escaping.

Technical Details

Each column type has its generator: names from pools, emails from patterns, numbers in ranges, dates in spans. Handles CSV escaping for commas and quotes. Configurable: delimiter, quote character, header row, line endings.

Common Use Cases

1. Import Testing: Test CSV import functionality with varied data.
2. ETL Pipeline Testing: Validate data transformation pipelines.
3. Performance Testing: Generate large files for load testing.
4. Spreadsheet Development: Test Excel/Sheets formulas with sample data.

Code Examples

Random CSV Generator

const generators = {
  name: () => ['John', 'Jane', 'Bob', 'Alice'][Math.floor(Math.random() * 4)],
  email: () => `user${Math.floor(Math.random() * 1000)}@example.com`,
  int: (min = 0, max = 100) => Math.floor(Math.random() * (max - min + 1)) + min,
  date: () => new Date(Date.now() - Math.random() * 365 * 24 * 60 * 60 * 1000)
    .toISOString().split('T')[0],
  bool: () => Math.random() > 0.5
};

function escapeCSV(val) {
  const str = String(val);
  return /[",\n]/.test(str) ? `"${str.replace(/"/g, '""')}"` : str;
}

function randomCSV(schema, rows) {
  let csv = schema.map(c => c.name).join(',') + '\n';

  for (let i = 0; i < rows; i++) {
    const row = schema.map(col => {
      const gen = generators[col.type];
      return escapeCSV(gen(col.min, col.max));
    });
    csv += row.join(',') + '\n';
  }
  return csv;
}

// Generate 100 rows
const schema = [
  {name: 'name', type: 'name'},
  {name: 'email', type: 'email'},
  {name: 'age', type: 'int', min: 18, max: 65}
];
randomCSV(schema, 100);

Define type generators, create rows by calling generators for each column.

Tips & Best Practices

• Define realistic column types
• Use proper CSV escaping
• Seed random for reproducibility
• Stream for large file generation
• Include edge cases (empty, special chars)

Common Mistakes to Avoid

• Not escaping special characters
• Unrealistic data combinations
• Memory issues with large generation
• Missing edge case data

When to Use This Tool

Use random CSV generator for testing data imports, ETL pipelines, spreadsheet functionality, and any system that processes CSV files.

Frequently Asked Questions

How do I specify column types?

Define schema: [{name: "email", type: "email"}, {name: "age", type: "int", min: 18, max: 65}]. Each type has a generator with configurable options.

Can I generate specific data patterns?

Yes. Use regex patterns, value lists, or custom generator functions. Example: phone format "(###) ###-####" or status from ["active", "pending", "closed"].

How large can the output be?

Memory-limited for in-browser tools. Stream output for large files. 100K rows is typically fine; millions may need streaming or chunked generation.

How do I ensure data consistency?

Use seeded random for reproducibility. Related fields (city/state/zip) need lookup tables. Foreign keys require generating parent data first.

Get Started

Ready to try Random CSV? Use the tool now - it's free, fast, and works right in your browser.

---

Last updated: June 27, 2026