{"uid":"cap_ndOMkdLOO7kZMZTKhjhkR","slug":"csv-data-cleanup-deduplication-service-81453ee2","name":"CSV Data Cleanup & Deduplication Service","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.mmelnyk2000.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_q_l8jdBQaat0LKseEuEFg","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 a CSV file by trimming whitespace, normalizing dates/emails/phones, and merging or flagging duplicate rows, returning cleaned CSV plus a JSON report.","exampleAgentPrompt":"Can you clean up this CSV for me — https://example.com/contacts.csv — trim any whitespace, normalize all dates to ISO 8601, lowercase the emails, standardize phone numbers, and flag any duplicate rows based on the 'email' and 'name' columns?","exampleUseCases":[{"title":"Pre-import contact list cleanup","prompt":"I have a contacts CSV at https://mysite.com/exports/crm_dump.csv — can you clean it up before I import it? Trim whitespace, normalize dates to ISO 8601, lowercase all emails, fix phone number formats, and deduplicate rows based on the email and phone columns."},{"title":"Standardize survey response data","prompt":"Here's my inline survey CSV data — can you clean it? Trim all whitespace, convert any date fields to ISO 8601, and flag any exact duplicate responses based on the respondent_id column."},{"title":"Deduplicate product catalog CSV","prompt":"I have a messy product catalog CSV at https://shop.example.com/products_export.csv with tons of near-duplicate entries — please clean it, normalize casing, and merge fuzzy duplicates based on the product_name and sku columns."}],"resultDescription":"Returns the cleaned CSV text plus a JSON report detailing rows in, rows out, number of duplicates found or merged, and which columns were changed during normalization.","failureModes":["CSV file exceeds 1 MB or 20,000 rows — request rejected","URL is not publicly accessible or returns non-CSV content","Malformed CSV that cannot be parsed","Invalid key_columns names not found in header","Network timeout fetching remote CSV URL","Payment of $0.005 USDC not completed — request blocked"],"whenToPreferThis":"Choose this endpoint when you need a fast, deterministic, rule-based CSV cleaning pipeline without AI involvement — ideal for normalizing phone numbers, emails, dates, trimming whitespace, and deduplicating rows based on exact or fuzzy key-column matches. Best for files under 1 MB / 20k rows where reproducibility and no data storage are requirements. Not suited for AI-driven data enrichment, schema inference, or large-scale ETL.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T06:35:51.871Z","isFirstParty":false,"canonicalSlug":"csv-data-cleanup-deduplication-service-81453ee2"}