Skip to Main Content

Data Cleaning 101: Using No-code Tools: PPT

This guide is designed to facilitate the teaching of the library workshop "Data Cleaning 101".

About the workshop

Data cleaning is a crucial step in the research process, ensuring data accuracy, consistency, and reliability for analysis. This workshop introduces OpenRefine and Power Query, two powerful no-code tools that simplify data cleaning without programming. Through hands-on exercises, students will gain practical experience in data cleaning and wrangling. 

OpenRefine logo
  • Free, open-source, desktop app (needs installation)
  • Good at finding patterns, text clustering, standardizing inconsistent data
  • Repeatable workflows
  • Built-in tool in Excel, no extra installation
  • Good at reshaping data structure, working with files from multiple sources in different types
  • Repeatable workflows, within MS environment
  • Work better on Windows

Download & Install OpenRefine

Download latest version from: https://openrefine.org/download
Installation steps: https://openrefine.org/docs/manual/installing

When you double-click “openrefine.exe” for the first time, make sure to: 

Download latest version from: https://openrefine.org/download
Installation steps: https://openrefine.org/docs/manual/installing

When you double-click “OpenRefine.app” for the first time, make sure to: 

Workshop PPT

202503 Data Cleaning 101 - No-code tools by Aster Zhao

© HKUST Library, The Hong Kong University of Science and Technology. All Rights Reserved.