{"uid":"cap_MkeEzaVSz9aj99NlpDvjQ","slug":"csv-data-cleanup-normalization-764f8a89","name":"CSV Data Cleanup & Normalization","description":"Clean a CSV ($0.005 USDC): give an https url or inline csv (max 1 MB / 20k rows). Trims whitespace, optional case rules, dates to ISO 8601, lowercases emails, normalizes phone digits, merges or flags exact + fuzzy duplicate rows on key_columns. Returns cleaned CSV text + JSON report (rows in/out, dupes, columns changed). Deterministic, no AI. As is, no warranty. Nothing stored.","url":"https://well-016-datacleanup.rainmaker-wells.workers.dev/mcp?utm_source=zero.xyz#data-cleanup#data-cleanup","method":"POST","headers":{},"bodySchema":null,"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.005","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"registry","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.005/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.005","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.005","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_I-Qcjs0ZXXgXp1btNWpv6","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.005","costPer":"request","priority":0,"asset":null,"unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Cleans and normalizes a CSV file by trimming whitespace, standardizing dates, emails, and phone numbers, and detecting/merging duplicate rows — returning cleaned CSV plus a JSON report","exampleAgentPrompt":"Can you clean this CSV for me? Here's the URL: https://example.com/customers.csv — trim whitespace, normalize all dates to ISO 8601, lowercase the emails, and flag any duplicate rows using the 'email' and 'phone' columns as keys.","exampleUseCases":[{"title":"Pre-import CRM data cleanup","prompt":"I have a CSV export of our CRM contacts at https://example.com/crm_export.csv — can you clean it up before we import it? Trim all whitespace, standardize the phone numbers, lowercase emails, convert any dates to ISO 8601, and merge exact duplicate rows matching on the 'email' column."},{"title":"Deduplicating a marketing list","prompt":"We have a marketing list CSV pasted here with about 5,000 rows — can you find and remove duplicate contacts using 'email' and 'last_name' as the key columns, and give me a report of how many dupes were removed?"},{"title":"Normalizing survey response exports","prompt":"I exported survey responses as a CSV and the formatting is all over the place — dates in different formats, phone numbers with random characters, inconsistent capitalization. Can you normalize everything: ISO dates, clean phone digits, lowercase emails, and trim any extra spaces?"}],"resultDescription":"Returns the cleaned CSV as text with all normalizations applied, plus a JSON report containing: total rows in, rows out after deduplication, number of duplicate rows found, and a list of which columns were changed.","failureModes":["CSV exceeds 1 MB or 20,000 rows — request rejected","Invalid or inaccessible URL provided — fetch failure","Malformed CSV that cannot be parsed — error returned","Key columns specified for deduplication not found in CSV headers","Network timeout fetching remote CSV URL"],"whenToPreferThis":"Use this endpoint when you need a deterministic, rule-based CSV cleaning pipeline — not AI-based transformation — that handles whitespace trimming, date/phone/email normalization, and exact or fuzzy duplicate detection in a single call for $0.005 USDC. Prefer this over manual ETL scripts or AI-based data cleaning when you need reproducible, auditable transformations on files up to 1 MB / 20k rows with no data retention.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-22T12:38:13.048Z","isFirstParty":false,"canonicalSlug":"csv-data-cleanup-normalization-764f8a89"}