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)
![Share on Twitter twitter](https://echinaceaproject.org/wp-content/plugins/social-media-feather/synved-social/image/social/regular/48x48/twitter.png)
![Pin it with Pinterest pinterest](https://echinaceaproject.org/wp-content/plugins/social-media-feather/synved-social/image/social/regular/48x48/pinterest.png)
![Share by email mail](https://echinaceaproject.org/wp-content/plugins/social-media-feather/synved-social/image/social/regular/48x48/mail.png)
Leave a Reply