Data Cleaning Tutorials for Data Driven Journalism

• A guide to bullet-proofing your data

Cleaning data with Excel

• 37 ways to hide information in Excel
• KDMC Berkeley Tutorial: Intro to cleaning data
• Setting the Record(s) Straight: Dealing with Bad Data
• A gentle introduction to data cleaning
• Using a spreadsheet to clean up a dataset
• Top 10 ways to clean your data
• Separating first and last names in Microsoft Excel
• Adding Value(s) to Your Spreadsheet: Turning Text Data into Numbers?

Cleaning data with OpenRefine

• Data exploration with OpenRefine
• Cleaning data with Refine
• Clustering text facets in OpenRefine
• Data Shaping in Google Refine – Generating New Rows from Multiple Values in a Single Column
• Refine documentation for users
• JSON Tutorial
• Google Refine Expression Language documentation