# Clean

Data often arrives in a less-than-ideal state. Analytics's suite of cleaning tools can help you automate data cleanup. Simple tools like [Find & Replace](https://docs.auditboardanalytics.com/tools/clean/find-replace) or [Text to Columns](https://docs.auditboardanalytics.com/tools/clean/texttocolumns) can help prep data before transformation. Check incoming data for specified conditions by using the [Validate](https://docs.auditboardanalytics.com/tools/clean/validate) tool.

<table data-card-size="large" data-view="cards"><thead><tr><th></th><th></th><th></th></tr></thead><tbody><tr><td><a href="clean/find-replace">Find Replace</a></td><td>Find text strings in a dataset, replace with new text</td><td></td></tr><tr><td><a href="clean/texttocolumns">Text to Columns</a></td><td>Split one column into many based on characters in that column</td><td></td></tr><tr><td><a href="clean/sample">Sample</a></td><td>Pull just a portion of data from a tool, based on selected rules</td><td></td></tr><tr><td><a href="clean/validate">Validate</a></td><td>Confirm your data meets expectations, includes lookup checks</td><td></td></tr><tr><td><a href="clean/parsejson">Parse JSON</a></td><td></td><td>ParseJSON offers the ability to flatten or explode JSON objects from one JSON column into new broken out columns in your dataset. You can also select the max level to flatten if you want to flatten to deeper levels in the JSON string.</td></tr></tbody></table>