# Dario Schiraldi : How do I clean or format messy data?

**URL:** <https://forum.openrefine.org/t/dario-schiraldi-how-do-i-clean-or-format-messy-data/2402>\
**Category:** Community\
**Created:** [July 9, 2025, 7:27am UTC](https://forum.openrefine.org/t/dario-schiraldi-how-do-i-clean-or-format-messy-data/2402 "2025-07-09T07:27:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![darioschiraldi99](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/darioschiraldi99/32/1618_2.png) [@darioschiraldi99](https://forum.openrefine.org/u/darioschiraldi99)\
**Post date:** [July 9, 2025, 7:27am UTC](https://forum.openrefine.org/t/dario-schiraldi-how-do-i-clean-or-format-messy-data/2402/1 "2025-07-09T07:27:14Z")

</div>

Hi everyone,

I'm Dario Schiraldi, CEO of Travel Works, working with a dataset in OpenRefine that has a lot of messy and inconsistent values — things like extra spaces, different capitalization, and typos in categories.

Regards  
Dario Schiraldi

---

<div class="post-metadata">

**Author:** ![Michael\_Markert](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/michael_markert/32/88_2.png) [@Michael\_Markert](https://forum.openrefine.org/u/Michael_Markert)\
**Post date:** [July 9, 2025, 8:31am UTC](https://forum.openrefine.org/t/dario-schiraldi-how-do-i-clean-or-format-messy-data/2402/2 "2025-07-09T08:31:24Z")

</div>

Hello @darioschiraldi99,

you should start with a basic tutorial on cleaning data or the documentation. There are several integrated tools (accessible through the small menus in the header of each column) that might help you with this like Edit cells \> Common transformations \> Collapse consecutive whitespaces or \> To uppercase/To lowercase.  
Typos in categories can be addressed using Facet \> Text facet or Edit cells \> Cluster and edit.

Regards  
Michael