CSV - Revision history

Sembiance: Moved sample files section

2023-12-28T14:58:19Z

Moved sample files section

Sembiance: /* Sample files */

2023-12-28T14:57:43Z

‎Sample files

Dan Tobias: /* Other links and references */

2022-05-22T21:06:29Z

‎Other links and references

Dan Tobias: /* Examples */

2020-02-12T00:19:39Z

‎Examples

Dan Tobias: /* Other links and references */

2019-12-14T04:07:01Z

‎Other links and references

Dan Tobias at 00:23, 30 May 2019

2019-05-30T00:23:23Z

Dan Tobias at 00:22, 30 May 2019

2019-05-30T00:22:57Z

Jsummers at 19:10, 24 August 2016

2016-08-24T19:10:57Z

Dan Tobias: /* Software */

2016-04-14T12:26:32Z

‎Software

Dan Tobias: /* Software */

2016-04-14T12:25:28Z

‎Software

@@ Line 66: / Line 66: @@
 * [[CSV Schema]]
 * [[JSON Table Schema]]
 == Software ==
@@ Line 90: / Line 84: @@
 == Code ==
 * [http://sourceforge.net/projects/ndad/files/ndad/ NDAD] The public release of the NDAD code contained a generic set of routines to read and write CSV files which supported arbitrary quoting and multi-line fields, as well as supporting files which contained different numbers of fields in each record. readcsv_v & writecsv are buried in this tarball:
 : There's also readcsv, a simpler implementation which expects the caller to know how many fields the input record will contain and returns an error if that isn't what it finds.
@@ Line 102: / Line 95: @@
 * MIME type (Internet media type): '''text/csv''' is the officially-registered type, but a number of other types have been used starting before the registration took place, but continuing afterward.  '''text/x-csv''' and '''application/x-csv''' are common, and '''application/csv''', '''text/x-comma-separated-values''', and '''text/comma-separated-values''' are also encountered.  Sometimes such files are even served as '''application/vnd.ms-excel''' in order to get them to load in MS Excel (and be unnecessarily perceived as in a proprietary format by those who can't or won't use Microsoft products).  Incidentally, Windows in its default configuration refers to files with a .csv extension as "Microsoft Office Excel Comma Separated Values File", implying that MS is claiming ownership of the format.
 * Non-computer-geek people will often mistakenly refer to these files as "CVS". They're probably thinking of the [http://www.cvs.com/ drugstore chain]; CVS is also a [[Concurrent Versions System|revision control system for software projects]], but you can't expect non-geeks to know ''that''.
 == Hints and tips ==

@@ Line 67: / Line 67: @@
 * [[JSON Table Schema]]
-== Examples ==
+== Sample files ==
 * [https://www.dan.info/sampledata/test.csv Sample CSV file (with double quotes around values)]
 * [http://www.bl.uk/bibliographic/datasamples.html#csvbnb Subject themed sample datasets]
 * [http://labs.nationalarchives.gov.uk/wordpress/index.php/2014/01/datasets/ National Archives (UK) datasets (includes some CSV files)]
 == Software ==

@@ Line 115: / Line 115: @@
 * [http://www.w3.org/TR/csv2json/ Generating JSON from tabular data on the Web (W3C)]
 * [http://blogs.perl.org/users/enkidu/2019/12/working-with-csv-using-pdl.html Working with CSV using PDL]
 [[Category:Document]]

@@ Line 68: / Line 68: @@
 == Examples ==
-* [http://www.dan.info/sampledata/test.csv Sample CSV file (with double quotes around values)]
+* [https://www.dan.info/sampledata/test.csv Sample CSV file (with double quotes around values)]
 * [http://www.bl.uk/bibliographic/datasamples.html#csvbnb Subject themed sample datasets]
 * [http://labs.nationalarchives.gov.uk/wordpress/index.php/2014/01/datasets/ National Archives (UK) datasets (includes some CSV files)]

@@ Line 114: / Line 114: @@
 * [http://www.w3.org/TR/csv2rdf/ Generating RDF from tabular data on the Web (W3C)]
 * [http://www.w3.org/TR/csv2json/ Generating JSON from tabular data on the Web (W3C)]
 [[Category:Document]]

@@ Line 6: / Line 6: @@
 {{mimetype|text/csv}} (officially registered type), {{mimetype|application/csv}}, {{mimetype|text/x-csv}}, {{mimetype|application/x-csv}}, {{mimetype|text/x-comma-separated-values}}, {{mimetype|text/comma-separated-values}}
 |pronom={{PRONOM|x-fmt/18}}
-|locfdd={{LocFDD|fdd000323}}
+|locfdd={{LoCFDD|fdd000323}}
 |wikidata={{wikidata|Q935809}}
 }}

@@ Line 7: / Line 7: @@
 |pronom={{PRONOM|x-fmt/18}}
 }}
-'''CSV''' (Comma Separated Values) is a text-based format typically used for the storage or exchange of database-like records. In Microsoft Windows systems, it will commonly open in Excel, but it is not a proprietary format and can be used in many other programs.
+'''CSV''' (Comma Separated Values) is a text-based format typically used for the storage or exchange of database-like records. In Microsoft Windows systems, it will commonly open in [[Microsoft Excel|Excel]], but it is not a proprietary format and can be used in many other programs.
 == Description ==

@@ Line 74: / Line 74: @@
 * [http://csvkit.readthedocs.org/en/0.7.3/ csvkit 0.7.3: utilities for CSV]
 * [http://csvkit.readthedocs.org/en/0.8.0/ csvkit 0.8.0: utilities for CSV]
-* [http://digital-preservation.github.io/csv-validator/ CSV Validator 1.1] ([http://blog.nationalarchives.gov.uk/blog/csv-validator-new-digital-preservation-tool/ more info])
+* [http://digital-preservation.github.io/csv-validator/csv-validator-1.0.html CSV Validator 1.0] ([http://blog.nationalarchives.gov.uk/blog/csv-validator-new-digital-preservation-tool/ more info])
 * [https://github.com/digital-preservation/csv-validator/releases/tag/1.1.3 CSV Validator 1.1.3]
 * [https://github.com/ropensci/testdat testdat]