πŸ“‘ Data Organization in Spreadsheets

Bookmarked Data Organization in Spreadsheets (Taylor & Francis)

Spreadsheets are widely used software tools for data entry, storage, analysis, and visualization. Focusing on the data entry and storage aspects, this article offers practical recommendations for organizing spreadsheet data to reduce errors and ease later analyses. The basic principles are: be consistent, write dates like YYYY-MM-DD, do not leave any cells empty, put just one thing in a cell, organize the data as a single rectangle (with subjects as rows and variables as columns, and with a single header row), create a data dictionary, do not include calculations in the raw data files, do not use font color or highlighting as data, choose good names for things, make backups, use data validation to avoid data entry errors, and save the data in plain text files.

Karl W. Broman and Kara H. Wood provide a series of tips for organising data. This has me reviewing my work in regards to collating contact data with my job. Along with Ben Collins’ post, this is a useful guide for working with spreadsheets.

via Cory Doctorow

Leave a Reply

Your email address will not be published. Required fields are marked *