Pricing

$1.00 / verified file

Try for free

Go to Apify Store

Excel & CSV Data Cleaner

Try for free

Clean messy Excel and CSV files from a plain-English request: remove duplicates, fix dates and number formats, tidy text, add calculated columns. Every result is checked by code before delivery: you pay USD 1.00 only for verified files. Failed or unsupported files are free.

Pricing

$1.00 / verified file

Rating

0.0

(0)

Developer

Verified Sheets

Actor stats

Bookmarked

Total users

Monthly active users

a day ago

Last modified

Categories

You can access the Excel & CSV Data Cleaner programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

1import { ApifyClient } from 'apify-client';
2
3// Initialize the ApifyClient with your Apify API token
4// Replace the '<YOUR_API_TOKEN>' with your token
5const client = new ApifyClient({
6    token: '<YOUR_API_TOKEN>',
7});
8
9// Prepare Actor input
10const input = {
11    "pedido": "Remove duplicate rows based on the email column and convert the dates to YYYY-MM-DD."
12};
13
14// Run the Actor and wait for it to finish
15const run = await client.actor("verifiedsheets/excel-csv-data-cleaner").call(input);
16
17// Fetch and print Actor results from the run's dataset (if any)
18console.log('Results from dataset');
19console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
20const { items } = await client.dataset(run.defaultDatasetId).listItems();
21items.forEach((item) => {
22    console.dir(item);
23});
24
25// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

Excel & CSV Data Cleaner API in JavaScript

The Apify API client for JavaScript is the official library that allows you to use Excel & CSV Data Cleaner API in JavaScript or TypeScript, providing convenience functions and automatic retries on errors.

Install the apify-client

$npm install apify-client

Other API clients include:

Excel & CSV Data Cleaner API in Python

Excel & CSV Data Cleaner API through CLI

Excel & CSV Data Cleaner OpenAPI definition

Excel & CSV Data Cleaner API

CSV & Excel Dataset Merger / Splitter [Bulk Optimizer]

thecfmarketing/csv-xlsx-dataset-merger-pattern-splitter

High-speed tool to merge multiple CSV & Excel files or split large datasets into smaller chunks by rows, file size, or specific patterns. Clean duplicates, optimize data formats, and structure columns. The ultimate utility for handling millions of B2B cold email leads and data lists.

sadique shaikh

Excel to CSV Converter

web.harvester/excel-to-csv

Convert Excel files (XLSX, XLS, ODS) to CSV format. Extract all sheets or specific ones. Configurable delimiter, date formatting, skip empty rows. Batch processing multiple files. Optional JSON output to Dataset. Handles large files efficiently. Perfect for ETL pipelines.

Web Harvester

Json To Excel

zuzka/json-to-excel

Convert your json into a tabular form, such as CSV, Excel or HTML table fast and easy.

Zuzka Pelechová

CRM Lead Data Cleaner (Email/Phone Validator + Dedup)

motivational_nickel/universal-data-cleaner

Turn messy CSV or Excel leads into clean, validated, CRM-ready data. Fix Excel E+11 phone numbers, validate emails, remove duplicates, and score lead quality (HIGH, MEDIUM, LOW). Built for sales teams, lead gen agencies, and automation workflows.

Leoncio Coronado Jr

CSV/JSON Data Cleaner & Converter

m3web/scraped-data-cleaner-rental

Clean and organize scraped .json or .csv data — no coding required. Remove duplicates, empty rows, unwanted columns, and sort by any field. Cleaned results are pushed to your Apify dataset. Perfect for marketers, researchers, and no-code workflows.

M3Web

5.0

(1)

Excel MCP Server

constant_quadruped/excel-mcp-server

MCP server enabling AI assistants to read, write, and manipulate Excel files. 12 tools for cells, ranges, formulas, sheet management, and JSON/CSV export. No Excel installation required — pure Python processing. Perfect for AI automation workflows and MCP-enabled applications.

US address cleaner

saswave/us-address-cleaner

Normalize US address. From an address , extract city, state and zipcode. Handles non standard list of physical addresses. Uses advanced NLP (Natural Language Processing) methods.

SASWAVE

CSV Cleaner & Deduplication Tool

taroyamada/csv-data-cleaner

Clean CSV data. No API key / no login. Open Input → leave defaults → Start (3 CSV rows cleaned ≈ USD 0.01/run): https://console.apify.com/actors/Rrl9isk1pUMDbShKc/input From USD 0.

naoki anzai

Excel Converter — XLSX to CSV & JSON (and back)

hipersoft/excel-converter

Convert Excel workbooks to CSV or JSON (all sheets or one), or build a styled XLSX from JSON. The spreadsheet glue for no-code and n8n automation pipelines.

hiper soft

ai-data-cleaner-classifier

keratogenous_surgeon/dataset-ai-cleaner

Clean, normalize, deduplicate, and classify JSON, CSV, or Apify datasets using rules or OpenAI models. Built for automation pipelines, data preparation, and AI workflows. Supports dataset chaining, cost controls, and safe fallbacks.