Comma-Separated Values (CSV) Datafiles for Testing

Quotes in quotes, newlines in quotes, blank lines, comments, crlf, comma in quotes and more

Summary

a,b,c
1,2,3

=>

[["a", "b", "c"],
 ["1", "2", "3"]]

a,b,c
1,2,3
4,5,ʤ

=>

[["a", "b", "c"],
 ["1", "2", "3"],
 ["4", "5", "ʤ"]]

a,b,c
1,,
2,3,4

or

a,b,c
1,"",""
2,3,4

=>

[["a", "b", "c"],
 ["1", "",  "" ],
 ["2", "3", "4"]]

first,last,address,city,zip
John,Doe,120 any st.,"Anytown, WW",08123

=>

[["first", "last", "address",     "city",        "zip"  ],
 ["John",  "Doe",  "120 any st.", "Anytown, WW", "08123"]]

a,b,c
1,2,3
"Once upon↵
a time",5,6
7,8,9

=>

[["a", "b", "c"],
 ["1", "2", "3"],
 ["Once upon\na time", "5", "6"],
 ["7", "8", "9"]]

a,b
1,"ha ""ha"" ha"
3,4

=>

[["a", "b"],
 ["1", "ha \"ha\" ha"],
 ["3", "4"]]

a,b
1,"ha↵
""ha""↵
ha"
3,4

=>

[["a", "b"],
 ["1", "ha\n\"ha\"\nha"],
 ["3", "4"]]

key,val
1,"{""type"": ""Point"", ""coordinates"": [102.0, 0.5]}"

=>

[["key", "val"],
 ["1",   "{\"type\": \"Point\", \"coordinates\": [102.0, 0.5]}"]]

Name		Name	Last commit message	Last commit date
Latest commit History 25 Commits
EXCEL		EXCEL
EXCEL_DE		EXCEL_DE
MYSQL		MYSQL
POSTGRESQL		POSTGRESQL
POSTGRESQL_TEXT		POSTGRESQL_TEXT
RFC4180		RFC4180
TAB		TAB
UNIX		UNIX
tests		tests
LICENSE.md		LICENSE.md
NOTES.md		NOTES.md
README.md		README.md
comma_in_quotes.csv		comma_in_quotes.csv
comma_in_quotes.headers.json		comma_in_quotes.headers.json
comma_in_quotes.json		comma_in_quotes.json
empty.csv		empty.csv
empty.headers.json		empty.headers.json
empty.json		empty.json
empty_crlf.csv		empty_crlf.csv
empty_crlf.headers.json		empty_crlf.headers.json
empty_crlf.json		empty_crlf.json
empty_ii.csv		empty_ii.csv
empty_ii.headers.json		empty_ii.headers.json
empty_ii.json		empty_ii.json
escaped_quotes.csv		escaped_quotes.csv
escaped_quotes.headers.json		escaped_quotes.headers.json
escaped_quotes.json		escaped_quotes.json
json.csv		json.csv
json.headers.json		json.headers.json
json.json		json.json
newlines.csv		newlines.csv
newlines.headers.json		newlines.headers.json
newlines.json		newlines.json
newlines_crlf.csv		newlines_crlf.csv
newlines_crlf.headers.json		newlines_crlf.headers.json
newlines_crlf.json		newlines_crlf.json
quotes_and_newlines.csv		quotes_and_newlines.csv
quotes_and_newlines.headers.json		quotes_and_newlines.headers.json
quotes_and_newlines.json		quotes_and_newlines.json
simple.csv		simple.csv
simple.headers.json		simple.headers.json
simple.json		simple.json
simple_crlf.csv		simple_crlf.csv
simple_crlf.headers.json		simple_crlf.headers.json
simple_crlf.json		simple_crlf.json
utf8.csv		utf8.csv
utf8.headers.json		utf8.headers.json
utf8.json		utf8.json