where to get csv sample data?

Question

As part of my development I need to process some .csv files.

For what it matters I am writing a super fast CSV parser in java

I would like to ask if somebody can name some websites where I can find some good csv files so I can test my app.

Please don't tag this question is inappropriate I think developers would benefit from a list of good sites where to find sample data

You can consider all your test cases and generate csv file to have full test cases coverage. — khachik, Nov 09 '10 at 11:57
https://www.google.com/search?q=filetype:csv I recommend you write one yourself, add empty lines, quoted values which contains commas and newline, add chinese characters, add comments #, also try large files and empty files. — Christophe Roussy, May 11 '17 at 09:19

score 30 · Answer 1 · edited Nov 17 '19 at 19:31

30

The baseball archive can be downloaded in CSV format. The batting statistics file contains a little over 90,000 rows of data which should be helpful in performance testing your app.

edited Nov 17 '19 at 19:31

James McMahon

48,506
64
207
283

answered Nov 09 '10 at 15:43

Jeff Knecht

2,518
1
14
12

1

The file is approximately 8.1 MB in size, to give a sense of scale. – pjgranahan Jan 16 '17 at 22:46
And to give even more information: The concatenated CSVs are 32MB. – peri4n Feb 20 '17 at 07:31

score 8 · Answer 2 · answered Jun 27 '14 at 13:39

8

You can download the Sample CSV Data Files from this site.

Examples:

Sample Insurance Data

Real Estate Data

Sales Transactions Data

answered Jun 27 '14 at 13:39

shasi kanth

6,987
24
106
158

score 6 · Answer 3 · edited May 23 '17 at 12:03

6

See also this question on sample data.

I've used http://www.fakenamegenerator.com for these purposes in the past.

edited May 23 '17 at 12:03

Community

1
1

answered Nov 09 '10 at 14:48

warren

32,620
21
85
124

How do I download these fake informations as a CSV file? – renatov Apr 30 '15 at 19:16
@renatov- see http://www.fakenamegenerator.com/order.php – warren Apr 30 '15 at 19:17

score 3 · Answer 4 · answered Mar 18 '12 at 10:22

3

Another good source is baseball reference. Pick whatever baseball player or manager you can think of.

http://www.baseball-reference.com/managers/coxbo01.shtml

answered Mar 18 '12 at 10:22

cokedude

379
1
11
21

score 1 · Answer 5 · answered Nov 30 '13 at 01:07

This is a site that is in beta that can give you data in JSON, XML or CSV. All lists are customizable. This is a sample call to return data as CSV: http://mysafeinfo.com/api/data?list=dowjonescompanies&format=csv Documentation on lists, formats and options under documentation: http://mysafeinfo.com/content/documentation - Over 80 data sets available - see a full list under Datasets on the main menu

score 0 · Answer 6 · answered Jan 07 '13 at 19:45

0

If you're looking for some large CSV files with real-world data, try http://www.baseball-databank.org.

answered Jan 07 '13 at 19:45

Daryl Spitzer

143,156
76
154
173

PhilippeThomas · Answer 7 · 2014-03-09T00:21:38.820

0

Severals very nice testing csv files : http://support.spatialkey.com/spatialkey-sample-csv-data/

Sample insurance portfolio, Real estate transactions, Sales transactions, Company Funding Records, Crime Records

Thank you for the question !

edited Mar 09 '14 at 00:21

answered Mar 09 '14 at 00:07

PhilippeThomas

141
1
9

where to get csv sample data?

7 Answers7

Linked