Edited by cswitzer. 25 July 2011
Characteristics of a good CSV file:
1. Use database format in Excel
See this example: https://echinaceaproject.org/wp-content/uploads/2011/07/preliminary-analysis-for-calli.html
2. Don’t mix text, integer, or numeric fields (you may enter NA in a numeric field to signify missing data)
3. Remove spaces from excel cells
4. No punctuation in each column name
5. Don’t start a column with a number
6. Column names should be in easily typable format — use capitals at new words and use no spaces (called camelback format)
Leave a Reply