CSV: Difference between revisions
From MoodleDocs
(tidy up) |
(firstname, lastname, address, city, state SHOULD BE LOWERCASE) |
||
(One intermediate revision by the same user not shown) | |||
Line 2: | Line 2: | ||
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: | 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: | ||
firstname, lastname, address, city, state | |||
Sally, Smith, 234 A Street, Town, Peace | Sally, Smith, 234 A Street, Town, Peace | ||
George, Smithe, 999 Last Lane, Hamlet, Denial | George, Smithe, 999 Last Lane, Hamlet, Denial | ||
Line 17: | Line 17: | ||
* [[UTF-8 and BOM]] | * [[UTF-8 and BOM]] | ||
* [[qformat/csv]] - a simple way of creating multiple choice questions using a CSV file | * [[qformat/csv]] - a simple way of creating multiple choice questions using a CSV file | ||
* [[qformat | * [[qformat simplecsv]] - a very simple way of creating multiple choice questions using a CSV file | ||
[[es:CSV]] | [[es:CSV]] |
Latest revision as of 17:55, 25 July 2023
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:
firstname, lastname, 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