CSV: Difference between revisions
From MoodleDocs
(edit link added OO Calc to list) |
(tidy up) |
||
| (7 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
A '''CSV''' (Comma Separated Values) file contains tabular data (such as found in spreadsheets or databases) in a simple text format. | {{Managing a Moodle site}} | ||
A '''CSV''' (Comma Separated Values) file contains tabular data (such as found in spreadsheets or databases) in a simple text format. Each value is separated from the next by a comma. Each line is a record and the commas separate the fields or columns. For example: | |||
First name, Last name, Address, City, State | |||
Sally, Smith, 234 A Street, Town, Peace | |||
George, Smithe, 999 Last Lane, Hamlet, Denial | |||
Dim, Witt, By-the-Either, Wave, Outback | |||
These files can be created, viewed and edited with software such as Microsoft Excel, Open Office Calc or, if done with care, any simple text editor. | These files can be created, viewed and edited with software such as Microsoft Excel, Open Office Calc or, if done with care, any simple text editor. | ||
== See | == See also == | ||
* [[Upload users]] | |||
* [[Flat file]] enrolment | |||
* [http://en.wikipedia.org/wiki/Comma-separated_values Wikipedia article on the CSV file format] | * [http://en.wikipedia.org/wiki/Comma-separated_values Wikipedia article on the CSV file format] | ||
* [http://office.microsoft.com/training/training.aspx?AssetID=RC011801181033&CTT=6&Origin=RP011801171033 Microsoft help tutorial on importing CSV file data into Excel] | * [http://office.microsoft.com/training/training.aspx?AssetID=RC011801181033&CTT=6&Origin=RP011801171033 Microsoft help tutorial on importing CSV file data into Excel] | ||
* [[UTF-8 and BOM]] | |||
* [[qformat/csv]] - a simple way of creating multiple choice questions using a CSV file | |||
* [[qformat simplecsv]] - a very simple way of creating multiple choice questions using a CSV file | |||
[[ | [[es:CSV]] | ||
Latest revision as of 16:19, 1 September 2020
A CSV (Comma Separated Values) file contains tabular data (such as found in spreadsheets or databases) in a simple text format. Each value is separated from the next by a comma. Each line is a record and the commas separate the fields or columns. For example:
First name, Last name, Address, City, State Sally, Smith, 234 A Street, Town, Peace George, Smithe, 999 Last Lane, Hamlet, Denial Dim, Witt, By-the-Either, Wave, Outback
These files can be created, viewed and edited with software such as Microsoft Excel, Open Office Calc or, if done with care, any simple text editor.
See also
- Upload users
- Flat file enrolment
- Wikipedia article on the CSV file format
- Microsoft help tutorial on importing CSV file data into Excel
- UTF-8 and BOM
- qformat/csv - a simple way of creating multiple choice questions using a CSV file
- qformat simplecsv - a very simple way of creating multiple choice questions using a CSV file
