Clean a messy spreadsheet or CSV: the standard mess taxonomy, the fix per problem in the right order, and the checks that prove it's clean.
Clean this data: {{data_description}} (paste a sample + describe the full set: rows, where it came from, what it's for). Diagnose against the mess taxonomy: duplicates (exact and fuzzy — 'Jon Smith'/'John Smith'), inconsistent formats (dates, phones, casing, whitespace), mixed types in columns, merged-cells and header archaeology, encoding gremlins, and missing values (distinguish blank-means-zero from blank-means-unknown — it changes the fix). Give: the cleanup sequence (order matters — dedupe after normalising, not before), the tool-appropriate method per fix ({{tool}} formulas/features or steps), and the post-clean validation: row counts reconciled, spot-checks, and the summary stats that would expose a botched clean.
Fields like {{ this }} are placeholders — replace them with your own details, or let Aria ask you for them.
This prompt runs with Aria connected to your email, files, CRM and 40+ other services — and you can schedule it to run automatically.
Start Free WeekPull structured data out of messy text — emails, PDFs pastes, reports — into a clean table, with con...
Get the right Excel or Google Sheets formula for your layout — explained part by part, with a worked...
Get a structured first read of pasted data: observations with the numbers cited, trends vs noise sep...
Turn open-ended survey answers into themes and quotes.
Pick the best chart type for what you want to show.
Write or optimise a SQL query from a plain-English description of the data and the question — with t...