Get started
Clean a CSV in 2 minutes
From messy spreadsheet to clean rows.
- Create a free test key in the dashboard (it starts with
messy_test_). - Export your spreadsheet as CSV, then convert it to JSON rows (or use the CLI, which reads CSV directly).
- Send the rows to AutoPilot, which repairs, normalizes and de-duplicates them and returns a receipt of every change.
npm install -g https://messyapi.com/pkg/messyapi-cli-0.1.0.tgz
export MESSYAPI_API_KEY=messy_test_...
messyapi --helpcurl -X POST https://messyapi.com/api/v1/autopilot \
-H "Authorization: Bearer $MESSYAPI_KEY" \
-H "Content-Type: application/json" \
-d '{
"records": [
{
"company": " ACME, INC ",
"email": "MIKE@ACME.COM ",
"phone": "(415) 555-0132",
"revenue": "$1,250.00"
}
]
}'Want to see the result before it is applied? Call /api/v1/autopilot/preview instead. No key yet? Try the keyless demo on the homepage.