Input | Formatted |
---|---|
32 London Bridge St, London, UK | 32 London Bridge Street, London SE1 9SG, UK |
413 w 52nd Street, New York, 10019 | 413 W 52nd St, New York, NY 10019, USA |
624 Brush St, 48226 | 624 Brush St, Detroit, MI 48226, USA |
Input | Latitude | Longitude |
---|---|---|
32 London Bridge St, London, UK | 51.5042997 | -0.0863703 |
413 w 52nd Street, New York, 10019 | 40.7652307 | -73.988682 |
624 Brush St, 48226 | 42.33226579 | -83.0421731 |
Upload the spreadsheet or CSV file you want to clean
You can upload any of the following extensions: .xls, .csv, .xlm, .xlsx, .txt
You can change settings to read the file properly
Choose the data type you want to clean
Choose the column(s) you want to clean
Review a sample of your cleaned data
Click Clean Your Data to clean your file
Download just cleaned column or the entire file with clean values
Cleaned File is also emailed to you 😀
Input | prefix | first | middle | last | suffix | nicknames | other names |
---|---|---|---|---|---|---|---|
dr. martin luther king Jr. | Dr | Martin | Luther | King | Jr | ||
Emilia r. Clarke | Emilia | R | Clarke | ||||
Roosevelt, Franklin delano | Franklin | Delano | Roosevelt | ||||
Mister Benjamin M. Franklin (Inventor) | Mister | Benjamin | M | Franklin | (Inventor) |
Want even more details on the API? Check out our API docs
We encrypt your data at every cleaning step. In-transit using HTTPS/SSL and at rest using AWS Encryption Technology
We are fully GDPR Compliant. We will never use your data maliciously as spelled out in our Terms of Service
We offer on-prem installation if you need. We can also execute a Data Processor agreement with you easily
Trusted by Universities, Agencies, Startups & Small Businesses