Pricing

from $0.10 / actor start

Smart Dataset Merger, Cleaner & Pattern Splitter (CSV + XLSX)

Merge mixed CSV & Excel files by pattern, standardize columns, clean leads, remove duplicates, extract domains, and split outputs by row limits.

Pricing

from $0.10 / actor start

Rating

0.0

(0)

Developer

sadique shaikh

Actor stats

Bookmarked

Total users

Monthly active users

13 hours 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!

🧠 Smart Article Extractor

scraper-engine/smart-article-extractor

Smart Article Extractor by Extract clean article content from any webpage, including titles, authors, publish dates, text, images, metadata, and links. Remove ads and clutter automatically. Export structured data to JSON, CSV, Excel, or XML for research, AI training, content analysis, and archiving.

Scraper Engine

Virginia DPOR Professional License Scraper

haketa/virginia-dpor-license-scraper

Virginia DPOR license scraper & API: search Department of Professional and Occupational Regulation licenses and export license number, type, status, name, address and dates. Professional license verification and lead generation — fast, no login.

Haketa

Corporate Decision Intelligence: KYC, Compliance, Supplier Risk

ryanclinton/opencorporates-search

Resolve, score, and monitor companies across 140+ jurisdictions. Each record carries a stable entity ID, a deterministic risk score with evidence, confidence, data quality, and freshness. Free multi-source mode or full OpenCorporates coverage with an API key.

Ryan Clinton

136

SCOUTR Nordics (Google Maps Scraper)

odaudlegur/scoutr-nordics-google-maps-scraper

Specialized Google Maps scraper for Nordic countries. Geocodes a start address, finds businesses within a radius, and extracts name, address, website, phone. Visits each website to fetch real contact information. Other countries will be added in different actors when the code is fully optimized.

SLASH

Excel Automation Suite & MCP Server

lovely_radiologist/excel-mcp-server

The most powerful Excel automation API. 274 professional tools to create workbooks, bulk write & format, build BI dashboards, evaluate formulas, and import/export JSON/CSV. Use via REST API for ETL pipelines, or run as a native MCP server to give your AI agents (Claude/GPT-4) Excel superpowers.

Vivek Gaur

TikTok User Search Scraper - Find Creators [NO LOGIN] ✅

unseenuser/tiktok-user-search-scraper

Search TikTok users and creators by keyword. Get handles, bios, follower counts, and recent videos. Built for creator discovery, influencer research, and lead generation by topic or niche. No login, no cookies. Pair with our Followers Scraper to map full audiences.

Unseen User

5.0

(3)

Email Finder & Verifier - B2B Email Lookup API

clearpath/email-finder-api

Find verified business emails using first name, last name, and company domain. Tests common patterns and validates with SMTP checks. Upload CSV or Excel files for bulk processing. Returns quality-ranked results with alternative emails and confidence scores. Export to JSON or CSV.

ClearPath

1.6K

1.4

(3)

🏯 Tiktok Profile Scraper (Pay Per Result)

apidojo/tiktok-profile-scraper

Scrape TikTok user profiles at 425 posts/sec with 98% success, no proxy needed. Get followers, bio, badges, full video history & engagement. Username or URL input. Export JSON/CSV, API ready. Perfect for influencer research, lead gen & brand deals. $0.30 per 1K posts.

API Dojo

3.9K

4.8

(15)

🌐 Website Content Crawler

citrine_venus/website-content-crawler

Crawl any website into clean text, Markdown & rich metadata — AI-ready output for RAG, LLMs & vector databases. Streams to your dataset in real time.

Data Minds

Twitter Profile Scraper: Get Profile Tweets + Their Replies

apidojo/twitter-profile-scraper

Extract tweets, replies & engagement data from Twitter profiles. $0.016 per profile includes 40 tweets FREE. Get likes, retweets, views & media URLs. Date filtering, reply extraction, custom data transformation. No authentication, no proxy required. Event-based pricing, only pay for what you scrape!

API Dojo

3.4

(11)

B2B LinkedIn Lead Generator

chieftools/b2b-linkedin-lead-generator

Find B2B decision-makers on LinkedIn by describing your ideal customer. AI discovers matching companies from live web data, identifies the right people, and scores every lead for relevance. Pay only for qualifying leads.