I have some guidance on how to organize data (written back in 1999), but these guidelines are far superior. To be honest, you should use a database for anything more than half complicated, but for those simple data sets where you can use a text file or a spreadsheet, Dr. Broman’s comments are very helpful.

Karl Broman. Organizing data in spreadsheets. Available at http://kbroman.org/dataorg/

<U+00A0>

This Recommendation was added to the website on 2016-09-01 and was last modified on 2020-02-29. You can find similar pages at Data management.

An earlier version of this page appears here.