Pricing

from $0.10 / actor start

Try for free

Go to Apify Store

CSV & Excel Dataset Merger / Splitter [Bulk Optimizer]

Try for free

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.

Pricing

from $0.10 / actor start

Rating

0.0

(0)

Developer

sadique shaikh

Actor stats

Bookmarked

Total users

Monthly active users

6 days ago

Last modified

Smart Multi-Format Dataset Merger, Cleaner & Pattern Splitter 🚀

A high-performance Apify Actor to merge mixed CSV and Excel (.xlsx) files, auto-group by column patterns, clean leads, remove duplicate records, split large outputs by row limits, and ingest directly from Apify Datasets, ZIP archives, or Public URLs.

🌟 Key Features & USPs

🧠 Pattern-Based Auto Grouping: Prevents column misalignment and data corruption by automatically grouping files matching exact column signatures.
⚡ Mixed File Ingestion: Process .csv and .xlsx files simultaneously in a single run.
🎯 Custom Row-Limit Splitting: Split output files into custom row counts (e.g. 50,000 for CRMs, 100,000 for Google Sheets, 500,000 for balanced handling).
🧹 Lead Cleaning & Deduplication:
- Remove duplicates across merged datasets.
- Lowercase all email addresses (USER@GMAIL.COM -> user@gmail.com).
- Trim extra whitespace from all text columns.
- Split Full Name into first_name and last_name.
- Extract root domain (company.com) from email or website columns.
☁️ Cloud Native Integration: Ingest direct Apify Dataset IDs, ZIP download links, or public CSV/Excel file URLs.
📦 Multi-Format Export: Export output files as CSV, Excel (.xlsx), or JSON.

📋 Input Parameters

Parameter	Type	Default	Description
`zipFileUrl`	String	`null`	Direct URL to a `.zip` file containing CSV or Excel files.
`fileUrls`	Array	`[]`	List of public URLs to direct CSV/XLSX files.
`apifyDatasetIds`	Array	`[]`	List of Apify Dataset IDs to merge directly cloud-to-cloud.
`rowsPerFile`	Integer	`500000`	Max rows allowed per split output file.
`autoStandardizeHeaders`	Boolean	`true`	Map alias headers (`Email Address`, `e-mail` -> `email`).
`removeDuplicates`	Boolean	`true`	Remove duplicate records across datasets.
`dedupColumn`	String	`null`	Column to deduplicate on (e.g. `email`).
`trimWhitespace`	Boolean	`true`	Trim spaces from text cells.
`lowercaseEmails`	Boolean	`true`	Lowercase email addresses.
`splitFullNames`	Boolean	`false`	Split `Full Name` into `first_name` & `last_name`.
`extractDomains`	Boolean	`false`	Extract root domains into a `domain` column.
`outputFormat`	String	`"csv"`	Output file format (`csv`, `xlsx`, `json`).

📤 Output Artifacts

Key-Value Store: Output split files (format_1_part_1.csv, format_1_part_2.csv, etc.) ready for download.
Dataset Summary: A JSON report logging total files processed, pattern groups, row counts, and column schemas.

🛠️ How to Deploy to Apify

Install Apify CLI:

$npm install -g apify-cli

Log in to your Apify account:
```
$apify login
```
Push to your Apify console:
```
$apify push
```

👨‍💻 Support & Issues

For feature requests or issues, reach out on the Apify Store actor discussion page!

CSV & Excel Data Quality Cleaner

automation-lab/csv-excel-data-quality-cleaner

Clean CSV and Excel files under explicit rules, normalize columns and values, flag or remove duplicates, and export cleaned rows plus a structured validation report.

Stas Persiianenko

Lead List Deduplicator & Merger

jurassic_jove/lead-deduplicator-merger

Merge and deduplicate lead lists from multiple Apify datasets, CSV files and inline JSON into one clean, outreach-ready list. Pure data processor — no scraping, no proxies, no external APIs.

Data Runner

Dataset Dedupe Merger

inestimable_zoysia/dataset-dedupe-merger

Merge multiple datasets into one clean dataset. Removes duplicates with exact, normalized, or fuzzy matching, unifies field names, and keeps the most complete version of every record — with missing fields back-filled from discarded duplicates. Built for cleaning multi-scraper output.

Uncle Glooby

Text Splitter & Chunker for RAG / LLMs

zenomastro/text-splitter-for-llm

Split text into clean, overlapping chunks ready for embeddings, vector databases, RAG and LLM context. Configurable size, overlap, and split strategy.

Rosario Vitale

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

Dataset Toolkit — Dedupe, Merge, Clean, Diff

glueworks/dataset-toolkit

Post-process any Apify dataset: remove duplicates, merge multiple datasets, clean and normalize fields, or diff two crawls. Outputs a new dataset plus a summary record.

KAHA Chen

Excel & CSV Extractor — xlsx, xls, csv to JSON

gochujang/excel-extractor

Extract data from Excel (.xlsx) and CSV files into structured JSON. Input: URL or base64. Output: sheet name, headers, rows. Batch multiple files. $0.01/file + $0.0001/row.

Hojun Lee

Google Maps Contact Scraper

lightmoon/google-maps-contact-scraper

Search Google Maps by category and city to find local businesses, and export phone numbers, websites and addresses to CSV or Excel. 46 columns: split address fields, opening hours, rating, and flags for no website or an unclaimed profile. Export business contacts to build cold call and lead lists.

Stable

JSON to CSV Converter

maximedupre/json-to-csv-converter

Turn a JSON object or collection into a CSV or TSV file. Use direct JSON, a URL, or an Apify dataset, then flatten nested fields, choose columns, and get the complete file with structured rows.

Maxime Dupré

Data Cleaner — messy CSV/Excel/JSON to clean typed data

amanatools/data-cleaner

Clean, deduplicate, and type-infer CSV, Excel, and JSON files from URLs. Returns a quality report, preview rows, and a download link to the cleaned CSV. Built for AI agents and data pipelines.