Find file
Fetching contributors…
Cannot retrieve contributors at this time
106 lines (99 sloc) 5 KB
<html>
<head>
<title>CSVdata.info</title>
<link href='http://fonts.googleapis.com/css?family=Expletus+Sans' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Lekton' rel='stylesheet' type='text/css'>
<link type="text/css" rel="stylesheet" href="/css/style.css" />
<link rel="shortcut icon" href="/img/favicon.ico" type="image/x-icon" />
<script type="text/javascript" src="/js/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="/js/ui.js"></script>
</head>
<body>
<div id="header">
<div class="site-title">CSVdata.info</div>
<div id="menu">
<span class="menu-item"><a href="/">Home</a></span>
<span class="menu-item"><a href="#find">Find</a></span>
<span class="menu-item"><a href="#validate">Validate</a></span>
<span class="menu-item"><a href="#resources">Resources</a></span>
<span class="menu-item"><a href="#about">About</a></span>
</div>
</div>
<div id="main">
<div class="section">
<p class="intro">
... to help you consume and publish CSV data.
</p>
</div>
<div class="section">
<a id="find"></a><h2>Find <a class="plink" href="#find" title="Permalink to this section">#</a></h2>
<p class="subheading">
Where can I find CSV data?
</p>
<p>
There is no dedicated CSV look-up service, to our knowledge. However, one can use search engines and some dedicated catalogs to find CSV files:
</p>
<ul>
<li>In Google, use <code>filetype:csv</code> [<a href="http://www.google.com/search?q=filetype%3Acsv">example</a>]</li>
<li>In Bing, use <code>contains:csv</code> [<a href="http://www.bing.com/search?q=contains%3Acsv">example</a>]</li>
<li>In CKAN, use the 'Resource Format' CSV [<a href="http://ckan.net/package?res_format=CSV">example</a>]</li>
</ul>
<p>
Several (open) data initiatives offer data in CSV format and some people keep track of the sources manually:
</p>
<ul>
<li><a href="http://data.gov.uk/data">data.gov.uk</a></li>
<li><a href="http://www.data.gov/catalog">data.gov</a></li>
<li><a href="http://www.infochimps.com/">infochimps.com</a></li>
<li><a href="http://www.quora.com/Data/Where-can-I-get-large-datasets-open-to-the-public">Where can I get large datasets open to the public?</a> via Quora</li>
</ul>
<p class="note">
Note: we plan to offer a look-up service here in the new future.
</p>
</div>
<div class="section">
<a id="validate"></a><h2>Validate <a class="plink" href="#validate" title="Permalink to this section">#</a></h2>
<p class="subheading">
How can I validate CSV data?
</p>
<p>
Validating CSV files can happen on the syntactic level or on the schema level. A tool you might find useful is <a href="http://cutplace.sourceforge.net/">Cutplace</a>. Read more about this topic on <a href="http://stackoverflow.com/questions/2450345/how-to-validate-csv-file">stackoverflow</a> ...
</p>
<p class="note">
Note: we plan to offer an online-validation service here in the new future.
</p>
</div>
<div class="section">
<a id="resources"></a><h2>Resources <a class="plink" href="#resources" title="Permalink to this section">#</a></h2>
<p class="subheading">
What are relevant standards, guides and libraries for CSV data?
</p>
<h3>Specifications</h3>
<ul>
<li><a href="http://tools.ietf.org/html/rfc4180">RFC4180</a> Common Format and MIME Type for Comma-Separated Values (CSV) Files</li>
<li>Internet-Draft <a href="http://tools.ietf.org/html/draft-hausenblas-csv-fragment">URI Fragment Identifiers for the text/csv Media Type</a></li>
</ul>
<h3>Libraries, Guides and More</h3>
<ul>
<li><a href="http://databrewery.org/">Brewery</a>, a Python framework and collection of tools for analysing and mining data</li>
<li><a href="http://opencsv.sourceforge.net/">opencsv</a>, is a CSV parser library for Java</li>
<li><a href="http://code.google.com/p/php-csv-parser/">php-csv-parser</a>, simple data access object for CSV files in PHP5</li>
<li><a href="http://code.google.com/p/js-tables/">js-tables</a>, jQuery plug-in for CSV parsing and rendering</li>
<li><a href="https://github.com/mhausenblas/addrable">Addrable</a>, JavaScript-based access for CSV via fragment identifier</li>
<li>Wikipedia entry on <a href="http://en.wikipedia.org/wiki/Comma-separated_values">CSV</a></li>
<li><a href="http://webofdata.wordpress.com/2011/04/16/csv-web-data/">From CSV data on the Web to CSV data in the Web</a></li>
</ul>
</div>
<div class="section">
<a id="about"></a><h2>About <a class="plink" href="#about" title="Permalink to this section">#</a></h2>
<p class="subheading">
What's the purpose of this site?
</p>
<p>
To advocate interoperability and quality data on the Web. This site is maintained by <a href="http://sw-app.org/mic.xhtml#i">Michael Hausenblas</a> and <a href="http://dret.net/netdret/">Erik Wilde</a> - please let us know if you want to contribute.
</p>
</div>
</div>
<div id="footer">Last update: 2011-04-27</div>
</body>
</html>