Keeping your data tidy is important for a number of reasons. Firstly, it helps future you when you want to refer back to points of your data. Secondly, it's helpful to keep things organized for when you want to analyze/visualize that data later. However, when you have thousands of records of data, this task of data cleanup can be pretty daunting. There are a variety of tools that can help with this purpose. For more comprehensive resources on all data, please check out our Data Analytics and Visualization LibGuide.
Excel
Spreadsheet software with calculation, graphing tools, and pivot table options for analyzing data.
Google Sheets
Spreadsheet software that works well for collaborative projects.
Open Refine
A tool for cleaning messy data and transforming it between different formats.
