Skip to content
faker.tools
All 79

Plate IV · Developer, API & Database Seeding Utilities

CSV & TSV Dataset Generator

Delimiters, quoting, line endings and BOM — all the things that break imports.

csv
id,fullName,email,city,isActive,createdAt
1,Alice Young,alice.young@example.com,Boise,true,2025-11-01T21:05:30Z
2,Ryan Lopez,ryan.lopez@example.com,Brooklyn,true,2026-01-09T21:05:30Z
3,Linda Anderson,linda.anderson@example.com,Savannah,false,2026-01-21T21:05:30Z
4,Iris Martin,iris.martin@example.com,Portland,true,2024-02-09T21:05:30Z
5,Thomas Moore,thomas.moore@example.com,Boise,true,2025-05-06T21:05:30Z
6,Patricia Smith,patricia.smith@example.com,Portland,true,2025-12-12T21:05:30Z
7,Margaret Garcia,margaret.garcia@example.com,Boise,false,2026-03-20T21:05:30Z
8,Elijah Williams,elijah.williams@example.com,Austin,false,2026-04-14T21:05:30Z
9,Jason Hill,jason.hill@example.com,Savannah,true,2026-05-27T21:05:30Z
10,Jason Davis,jason.davis@example.com,Savannah,true,2025-10-10T21:05:30Z
11,Eric Lopez,eric.lopez@example.com,Boise,true,2026-01-29T21:05:30Z
12,Sarah Hernandez,sarah.hernandez@example.com,Chicago,true,2024-06-30T21:05:30Z
13,Sarah Allen,sarah.allen@example.com,Chicago,true,2026-06-27T21:05:30Z
14,Joseph Williams,joseph.williams@example.com,Brooklyn,true,2024-12-23T21:05:30Z
15,Lisa Lewis,lisa.lewis@example.com,Austin,true,2025-12-02T21:05:30Z
16,Elijah Moore,elijah.moore@example.com,Portland,true,2024-07-07T21:05:30Z
17,Jennifer Torres,jennifer.torres@example.com,Boise,true,2025-07-09T21:05:30Z
18,Jessica Martinez,jessica.martinez@example.com,Chicago,true,2026-01-26T21:05:30Z
19,Michael Martinez,michael.martinez@example.com,Portland,true,2025-01-05T21:05:30Z
20,Elijah Flores,elijah.flores@example.com,Boise,true,2025-06-21T21:05:30Z
21 lines · 1.5 KBGenerated in your browser · CSV & TSV Dataset Generator

CSV import bugs are almost never about the data. They are about a comma inside a quoted field, a CRLF where an LF was expected, or a missing BOM that turns Renée into Renée in Excel. All three are controls here.

What you can control

  • Four delimiters, including semicolon for locales where the comma is a decimal separator.
  • Quote-everything mode, for importers that cannot handle selective quoting.
  • CRLF line endings for Windows tooling that still expects them.
  • The UTF-8 BOM toggle is the single fix for Excel mangling accented characters.

What this is not

Values containing the delimiter, a quote or a newline are quoted and escaped per RFC 4180. If your importer does not follow that spec, the file is correct and the importer is not.

Questions

Why does Excel mangle my accented characters?

Excel assumes the system codepage unless the file starts with a UTF-8 byte order mark. Turn the BOM on and the accents survive.

When should I use semicolons?

In locales where the comma is the decimal separator — most of continental Europe. Excel there defaults to semicolon-delimited files.

How are embedded commas handled?

The field is wrapped in double quotes, and any quote inside it is doubled. That is RFC 4180, which nearly every parser implements.

Next in Developer

All 11 →

JSON Mock Data Generator

Arrays, envelopes, keyed objects or NDJSON from thirty-three field types.

SQL INSERT Statement Generator

Seed scripts for PostgreSQL, MySQL, SQLite and SQL Server.

GraphQL Mock Generator

SDL schemas, query documents, mutations and response payloads.