Overcoming Messy Spreadsheets

Do you have messy spreadsheets? Would you love a quicker way to clean them up? 

In celebration of Love Data Week 2025, join the ASU Library to learn about OpenRefine, a free, open-source tool that simplifies the process of cleaning, transforming and enhancing datasets. Whether you conduct data-intensive research daily or casually use spreadsheets, OpenRefine’s user-friendly interface helps individuals of all skill levels clean up messy datasets without learning programming languages or complicated spreadsheet formulas. This presentation will introduce OpenRefine, including importing data, using facets and filters, normalizing terms and exporting the cleaned data.