CSV Generator
UtilitiesCreate and export CSV tables
- Runs in your browser
- Nothing is sent to a server
- No sign-up
Generador de tablas CSV
| Acciones de fila | |||
|---|---|---|---|
CSV Generator: Test Data with Custom Columns
CSV files (Comma Separated Values) are the universal standard for tabular data exchange: databases, spreadsheets, dashboards, ETL, BI. Our generator creates test CSVs with real columns (name, email, phone, address, dates, amounts) and specifiable row count.
Uses Faker.js for realistic data localized by locale (Spanish, English, French, Portuguese). Options for encoding (UTF-8, ISO-8859-1), separator (comma, semicolon, tab), and quoted fields (recommended for texts containing commas).
Ideal for developers testing importers, QA populating databases, or analysts learning data manipulation without exposing real data.
How does it work?
- Define columns
Add columns from templates (name, email, phone, city) or create custom ones (regex, dates, numbers).
- Configure options
Number of rows, locale (es/en/fr/pt), separator, encoding, headers.
- Generate and download
Preview the first 10 rows, verify format, and download the complete CSV.
Frequently Asked Questions
Why do Excel imports fail with my CSV?
Excel expects UTF-8 with BOM or ISO-8859-1. Also, uses ';' as separator in Spanish locale (not ','). Our generator has an 'Excel-friendly' preset that handles these compatibility details automatically.
How do I generate large CSVs (millions of rows)?
For over 100,000 rows, generation may be slow in the browser. We recommend downloading in batches (multiple CSVs of 100k) or using command-line tools like csvkit or mockneat for volumes greater than 1 million.
Is the generated data realistic enough for testing?
Yes for functional testing. Faker generates names, emails, addresses coherent with the locale. For load testing you'll need volumes greater than what the browser can handle — use libraries like faker-js in Node.js.