CSV: Difference between revisions
From MoodleDocs
(edit link added OO Calc to list) |
(Example of CVS for real new users) |
||
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. | 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 seperate 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. | ||
Revision as of 16:13, 10 November 2006
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 seperate 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.