Cleaning Steps

As soon as you import data into Dropbase you can start adding Cleaning Steps that clean your data the way you want, before loading it to the database. You can add a cleaning step by directly clicking on the column name of the column you want to clean up in the Spreadsheet UI, or by adding a step from the sidebar by clicking on the '+' button.

For a complete list of Cleaning Steps, go to the Steps section in the documentation.

Adding Cleaning Steps

There are 2 ways to add Processing Steps to your data.

From the sidebar: You can add Steps by clicking on the 'Add Step' button. Doing so will bring up a component that lets you search and choose which Step you want to apply to your data.

From the Spreadsheet UI: You can also click on any of the column headers for the columns you want to clean. You will see a dropdown with a categorized list of some of the Cleaning Steps that you can apply on that column. When you click on any of those, a Step will be added.

Either way to add a cleaning step results in your data being processed the same way for the same Step. The only difference is that adding Steps from the column header automatically targets the selected column whereas adding a step from the Sidebar requires you to select which column you want to target for processing.

Removing Steps

Removing Steps can be done from the sidebar. You can simply click on the trash icon on a Step to remove it. You may have to re-run the last Step to refresh the data in the Spreadsheet UI.

Running Steps

You can Run Steps by clicking on the "Preview" or “Validate” button. Running Steps will be applied to your imported data in a sequential manner.

Pre-built Cleaning Steps

Dropbase has a number of powerful and convenient pre-built cleaning steps.