Pricing

from $2.00 / 1,000 processed dataset parts

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 $2.00 / 1,000 processed dataset parts

Rating

0.0

(0)

Developer

sadique shaikh

Actor stats

Bookmarked

Total users

Monthly active users

a month ago

Last modified

Categories

Lead generation

Automation

Developer tools

You can access the CSV & Excel Dataset Merger / Splitter [Bulk Optimizer] 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

{
  "openapi": "3.0.1",
  "info": {
    "version": "1.0",
    "x-build-id": "8NKjqEzVRtqDbglMY"
  },
  "servers": [
    {
      "url": "https://api.apify.com/v2"
    }
  ],
  "paths": {
    "/acts/thecfmarketing~csv-xlsx-dataset-merger-pattern-splitter/run-sync-get-dataset-items": {
      "post": {
        "operationId": "run-sync-get-dataset-items-thecfmarketing-csv-xlsx-dataset-merger-pattern-splitter",
        "x-openai-isConsequential": false,
        "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.",
        "tags": [
          "Run Actor"
        ],
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "$ref": "#/components/schemas/inputSchema"
              }
            }
          }
        },
        "parameters": [
          {
            "name": "token",
            "in": "query",
            "required": true,
            "schema": {
              "type": "string"
            },
            "description": "Enter your Apify token here"
          }
        ],
        "responses": {
          "200": {
            "description": "OK"
          }
        }
      }
    },
    "/acts/thecfmarketing~csv-xlsx-dataset-merger-pattern-splitter/runs": {
      "post": {
        "operationId": "runs-sync-thecfmarketing-csv-xlsx-dataset-merger-pattern-splitter",
        "x-openai-isConsequential": false,
        "summary": "Executes an Actor and returns information about the initiated run in response.",
        "tags": [
          "Run Actor"
        ],
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "$ref": "#/components/schemas/inputSchema"
              }
            }
          }
        },
        "parameters": [
          {
            "name": "token",
            "in": "query",
            "required": true,
            "schema": {
              "type": "string"
            },
            "description": "Enter your Apify token here"
          }
        ],
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/runsResponseSchema"
                }
              }
            }
          }
        }
      }
    },
    "/acts/thecfmarketing~csv-xlsx-dataset-merger-pattern-splitter/run-sync": {
      "post": {
        "operationId": "run-sync-thecfmarketing-csv-xlsx-dataset-merger-pattern-splitter",
        "x-openai-isConsequential": false,
        "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.",
        "tags": [
          "Run Actor"
        ],
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "$ref": "#/components/schemas/inputSchema"
              }
            }
          }
        },
        "parameters": [
          {
            "name": "token",
            "in": "query",
            "required": true,
            "schema": {
              "type": "string"
            },
            "description": "Enter your Apify token here"
          }
        ],
        "responses": {
          "200": {
            "description": "OK"
          }
        }
      }
    }
  },
  "components": {
    "schemas": {
      "inputSchema": {
        "type": "object",
        "properties": {
          "sourceType": {
            "title": "Source Type",
            "enum": [
              "upload",
              "url",
              "dataset"
            ],
            "type": "string",
            "description": "Choose how you want to provide your files.",
            "default": "upload"
          },
          "file": {
            "title": "Upload Single File (CSV, XLSX, ZIP)",
            "type": "string",
            "description": "Upload a single CSV, Excel (.xlsx), or ZIP file from your computer."
          },
          "files": {
            "title": "📁 Bulk Upload Multiple Files (CSV, XLSX, ZIP)",
            "type": "array",
            "description": "Upload multiple CSV, Excel (.xlsx), or ZIP files at once directly from your computer.",
            "items": {
              "type": "string"
            }
          },
          "zipFileUrl": {
            "title": "ZIP File Direct Link (URL)",
            "type": "string",
            "description": "Direct download link to a .zip file (e.g. Google Drive, Dropbox, or public URL)."
          },
          "fileUrls": {
            "title": "Direct File URLs",
            "type": "array",
            "description": "List of direct public URLs to CSV or Excel files.",
            "items": {
              "type": "string"
            }
          },
          "apifyDatasetIds": {
            "title": "Apify Dataset IDs",
            "type": "array",
            "description": "List of Apify Dataset IDs to download and merge directly from your scrapers.",
            "items": {
              "type": "string"
            }
          },
          "rowsPerFile": {
            "title": "Rows Per Split File",
            "minimum": 1000,
            "maximum": 2000000,
            "type": "integer",
            "description": "Maximum number of rows allowed per split file in the output (e.g. 50,000 for CRMs, 100,000 for Google Sheets, 500,000 for balanced processing).",
            "default": 500000
          },
          "autoStandardizeHeaders": {
            "title": "Auto-Standardize Header Names",
            "type": "boolean",
            "description": "Automatically map alias column names (e.g. 'Email Address', 'e-mail', 'Contact Email' -> 'email') so files with slight variations merge into one format.",
            "default": true
          },
          "removeDuplicates": {
            "title": "Remove Duplicate Rows",
            "type": "boolean",
            "description": "Enable to remove duplicate records across merged datasets.",
            "default": true
          },
          "dedupColumn": {
            "title": "Deduplication Column (Optional)",
            "type": "string",
            "description": "Column name to base deduplication on (e.g. 'email' or 'phone'). Leave blank to deduplicate on exact full row match."
          },
          "trimWhitespace": {
            "title": "Trim Whitespace & Clean Text",
            "type": "boolean",
            "description": "Trim leading and trailing spaces from all text fields.",
            "default": true
          },
          "lowercaseEmails": {
            "title": "Lowercase Email Addresses",
            "type": "boolean",
            "description": "Convert all email addresses to lowercase (e.g., USER@GMAIL.COM -> user@gmail.com).",
            "default": true
          },
          "splitFullNames": {
            "title": "Split Full Name into First & Last Name",
            "type": "boolean",
            "description": "Split 'Full Name' or 'name' columns into 'first_name' and 'last_name' columns.",
            "default": false
          },
          "extractDomains": {
            "title": "Extract Company Domain",
            "type": "boolean",
            "description": "Extract domain names from email addresses or website URLs into a 'domain' column.",
            "default": false
          },
          "outputFormat": {
            "title": "Output File Format",
            "enum": [
              "csv",
              "xlsx",
              "json"
            ],
            "type": "string",
            "description": "Format for output files (CSV, XLSX, or JSON).",
            "default": "csv"
          }
        }
      },
      "runsResponseSchema": {
        "type": "object",
        "properties": {
          "data": {
            "type": "object",
            "properties": {
              "id": {
                "type": "string"
              },
              "actId": {
                "type": "string"
              },
              "userId": {
                "type": "string"
              },
              "startedAt": {
                "type": "string",
                "format": "date-time",
                "example": "2025-01-08T00:00:00.000Z"
              },
              "finishedAt": {
                "type": "string",
                "format": "date-time",
                "example": "2025-01-08T00:00:00.000Z"
              },
              "status": {
                "type": "string",
                "example": "READY"
              },
              "meta": {
                "type": "object",
                "properties": {
                  "origin": {
                    "type": "string",
                    "example": "API"
                  },
                  "userAgent": {
                    "type": "string"
                  }
                }
              },
              "stats": {
                "type": "object",
                "properties": {
                  "inputBodyLen": {
                    "type": "integer",
                    "example": 2000
                  },
                  "rebootCount": {
                    "type": "integer",
                    "example": 0
                  },
                  "restartCount": {
                    "type": "integer",
                    "example": 0
                  },
                  "resurrectCount": {
                    "type": "integer",
                    "example": 0
                  },
                  "computeUnits": {
                    "type": "integer",
                    "example": 0
                  }
                }
              },
              "options": {
                "type": "object",
                "properties": {
                  "build": {
                    "type": "string",
                    "example": "latest"
                  },
                  "timeoutSecs": {
                    "type": "integer",
                    "example": 300
                  },
                  "memoryMbytes": {
                    "type": "integer",
                    "example": 1024
                  },
                  "diskMbytes": {
                    "type": "integer",
                    "example": 2048
                  }
                }
              },
              "buildId": {
                "type": "string"
              },
              "defaultKeyValueStoreId": {
                "type": "string"
              },
              "defaultDatasetId": {
                "type": "string"
              },
              "defaultRequestQueueId": {
                "type": "string"
              },
              "buildNumber": {
                "type": "string",
                "example": "1.0.0"
              },
              "containerUrl": {
                "type": "string"
              },
              "usage": {
                "type": "object",
                "properties": {
                  "ACTOR_COMPUTE_UNITS": {
                    "type": "integer",
                    "example": 0
                  },
                  "DATASET_READS": {
                    "type": "integer",
                    "example": 0
                  },
                  "DATASET_WRITES": {
                    "type": "integer",
                    "example": 0
                  },
                  "KEY_VALUE_STORE_READS": {
                    "type": "integer",
                    "example": 0
                  },
                  "KEY_VALUE_STORE_WRITES": {
                    "type": "integer",
                    "example": 1
                  },
                  "KEY_VALUE_STORE_LISTS": {
                    "type": "integer",
                    "example": 0
                  },
                  "REQUEST_QUEUE_READS": {
                    "type": "integer",
                    "example": 0
                  },
                  "REQUEST_QUEUE_WRITES": {
                    "type": "integer",
                    "example": 0
                  },
                  "DATA_TRANSFER_INTERNAL_GBYTES": {
                    "type": "integer",
                    "example": 0
                  },
                  "DATA_TRANSFER_EXTERNAL_GBYTES": {
                    "type": "integer",
                    "example": 0
                  },
                  "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
                    "type": "integer",
                    "example": 0
                  },
                  "PROXY_SERPS": {
                    "type": "integer",
                    "example": 0
                  },
                  "PROXY_UNBLOCKER_UNITS": {
                    "type": "integer",
                    "example": 0
                  }
                }
              },
              "usageTotalUsd": {
                "type": "number",
                "example": 0.00005
              },
              "usageUsd": {
                "type": "object",
                "properties": {
                  "ACTOR_COMPUTE_UNITS": {
                    "type": "integer",
                    "example": 0
                  },
                  "DATASET_READS": {
                    "type": "integer",
                    "example": 0
                  },
                  "DATASET_WRITES": {
                    "type": "integer",
                    "example": 0
                  },
                  "KEY_VALUE_STORE_READS": {
                    "type": "integer",
                    "example": 0
                  },
                  "KEY_VALUE_STORE_WRITES": {
                    "type": "number",
                    "example": 0.00005
                  },
                  "KEY_VALUE_STORE_LISTS": {
                    "type": "integer",
                    "example": 0
                  },
                  "REQUEST_QUEUE_READS": {
                    "type": "integer",
                    "example": 0
                  },
                  "REQUEST_QUEUE_WRITES": {
                    "type": "integer",
                    "example": 0
                  },
                  "DATA_TRANSFER_INTERNAL_GBYTES": {
                    "type": "integer",
                    "example": 0
                  },
                  "DATA_TRANSFER_EXTERNAL_GBYTES": {
                    "type": "integer",
                    "example": 0
                  },
                  "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
                    "type": "integer",
                    "example": 0
                  },
                  "PROXY_SERPS": {
                    "type": "integer",
                    "example": 0
                  },
                  "PROXY_UNBLOCKER_UNITS": {
                    "type": "integer",
                    "example": 0
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}

CSV & Excel Dataset Merger, Lead Cleaner & Pattern Splitter OpenAPI definition

OpenAPI is a standard for designing and describing RESTful APIs, allowing developers to define API structure, endpoints, and data formats in a machine-readable way. It simplifies API development, integration, and documentation.

OpenAPI is effective when used with AI agents and GPTs by standardizing how these systems interact with various APIs, for reliable integrations and efficient communication.

By defining machine-readable API specifications, OpenAPI allows AI models like GPTs to understand and use varied data sources, improving accuracy. This accelerates development, reduces errors, and provides context-aware responses, making OpenAPI a core component for AI applications.

You can download the OpenAPI definitions for CSV & Excel Dataset Merger / Splitter [Bulk Optimizer] from the options below:

OpenAPI.json

If you’d like to learn more about how OpenAPI powers GPTs, read our blog post.

You can also check out our other API clients:

CSV & Excel Dataset Merger / Splitter [Bulk Optimizer] API in Python

CSV & Excel Dataset Merger / Splitter [Bulk Optimizer] API in JavaScript

CSV & Excel Dataset Merger / Splitter [Bulk Optimizer] API through CLI

CSV & Excel Dataset Merger / Splitter [Bulk Optimizer] API

RAG Web Browser

apify/rag-web-browser

Web search and fetch tool for AI agents and RAG pipelines. It queries Google Search, scrapes the top N pages using a full web browser, and returns their content as clean Markdown for further processing by an LLM. Can also fetch individual URLs.

Apify

183K

4.7

(36)

Dataset Filter & Transform

nerolabs/dataset-filter-transform

Returns rows of any Apify dataset, CSV/Excel/JSON file URL or Google Sheet that pass filter rules (25 operators, AND/OR, date ranges that fix a scraper's ignored date filter) after transforms (rename, cast, compute, regex), then sort, dedupe, export, webhook. Agent-ready: pay per event (x402, MCP).

Adam Pearce

🎉 Leads Finder ✅ $1.50/1k with Emails ✅ Apollo Alternative

pipelinelabs/leads-finder-with-emails-apollo-lusha-zoominfo

Find verified B2B leads with emails, LinkedIn URLs & phone numbers. 250M+ contact database with 100% email coverage. Apollo, Zoominfo & Lusha alternative. Up to 50,000 leads per run.

Pipeline Labs

3.9K

3.6

(12)

Website Screenshot Generator

apify/screenshot-url

Create a screenshot of a website based on a specified URL. The screenshot is stored as the output in a key-value store. It can be used to monitor web changes regularly after setting up the scheduler.

Apify

7.4K

3.9

(21)

Web Fetch

apify/web-fetch

Download any web page by URL and convert it to clean Markdown, plain text, HTML, and other formats. Automatically renders JavaScript and works around bot blocking. The Actor provides a real-time API for quick response times.

Apify

12K

5.0

(3)

LinkedIn Profile Scraper for cheap lead enrichment ✅

anchor/linkedin-profile-enrichment

Extract LIVE LinkedIn profile data from LinkedIn URLs. Works with people and companies. Upload a CSV of LinkedIn URLs or use the API. Automate your LinkedIn enrichment with N8N, Make, Zapier integrations... No Cookies. Cheap, high-quality, live lead enrichment for LinkedIn profiles !

Anchor

9.7K

4.9

(21)

Google Maps Businesses Without Website (No-Website Leads)

thecfmarketing/google-maps-businesses-without-website

Find and extract local businesses on Google Maps with no website or missing website. Perfect for web design agencies, SEO freelancers, and cold outreach.

sadique shaikh

Dataset Validity Checker

equidem/Dataset-Validity-Checker

Automatically checks, whether default datasets created by runs of an actor differ too much from the previously encountered ones, allowing it to warn you about web scraping problems caused by, e.g., a website layout changing, or other significant changes in the resulting data.

Matěj Sochor

Website Content Crawler

apify/website-content-crawler

Crawl websites and extract text content to feed AI models, LLM applications, vector databases, or RAG pipelines. The Actor supports rich formatting using Markdown, cleans the HTML, downloads files, and integrates well with 🦜🔗 LangChain, LlamaIndex, and the wider LLM ecosystem.

Apify

162K

4.6

(234)

Google Maps Scraper & B2B Lead Generator

thecfmarketing/google-maps-fast-scraper

Ultra-fast Google Maps scraper to extract verified B2B leads: business names, phone numbers, website emails, social media (IG, FB, LinkedIn, WA), ratings, and unclaimed GMB listings. Zero duplicates, lowest compute cost, and high-speed export.

sadique shaikh