CSV — Quoted Embedded Newlines
A CSV with a quoted field that contains an embedded newline — a classic RFC 4180 parser stress case.
id,note
1,"line one
line two"
2,plain
Specifications
- Rows
- 2
- Quirk
- quoted field contains LF
What is a .csv file?
CSV (Comma-Separated Values) is a plain-text tabular format where rows are lines and fields are separated by commas, with quoting rules for values that contain delimiters, quotes, or newlines. It has no formal type system and depends on encoding and dialect conventions. It is the most portable format for tabular data exchange.
How to use this file
Use an example CSV to test parsers against quoting and embedded-delimiter edge cases, header handling, encoding detection, and import pipelines into databases or spreadsheets.
How to use this file for testing
“CSV — Quoted Embedded Newlines” is a deterministic Novus Examples fixture for CSV parsing, Error handling. Clean and deliberately messy CSVs — quoted commas, embedded newlines, ragged rows, odd delimiters, and encodings.
Documented properties for this file: 2 rows. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such — expect parsers to fail loudly rather than silently accept them.
Data fixtures document their exact quirks — delimiters, encodings, null handling, schema, and row counts — in the spec table. Point your parser or importer at the file and assert it handles the documented edge cases; clean and deliberately-messy siblings make before/after diffs straightforward.
Feed the file to your parser and assert it handles the documented quirks — quoted delimiters, embedded newlines, ragged rows, or invalid syntax; the valid↔invalid distinction is labelled in the title.
Code examples
import pandas as pd
df = pd.read_csv("quoted-newlines.csv")
print(df.head())
print(df.dtypes)Related files
- csvCSV — Ragged Column CountsRows with differing field counts — for testing how importers pad, truncate, or error on ragged CSV.
- csvCSV Extension — Tab Delimited ContentA .csv file whose content is tab-delimited — tests whether importers sniff delimiters or trust the extension.
- csvCSV Edge — Empty FieldsTiny SAMPLE CSV (empty-fields) exercising delimiter/quoting edge behaviour.
- csvCSV Edge — Hash CommentedTiny SAMPLE CSV (hash-commented) exercising delimiter/quoting edge behaviour.
- csvCSV Edge — Header OnlyTiny SAMPLE CSV (header-only) exercising delimiter/quoting edge behaviour.
- csvCSV Edge — Mixed QuotingTiny SAMPLE CSV (mixed-quoting) exercising delimiter/quoting edge behaviour.
Generated by generation/data_encodings_wave_c.py. Free for any use, no attribution required — license.