Pricing

from $0.05 / 1,000 merged rows

Try for free

Go to Apify Store

Dataset Merge, Dedup and Convert (CSV, JSON, XLSX)

Try for free

Merge CSV, JSON, JSONL and XLSX files or Apify datasets into one table. Remove duplicates by the columns you choose, ignoring case and spaces if wanted. Get one CSV, JSON or XLSX file plus a 100-row dataset preview. Unreadable files are skipped and named in a clear summary. Pay per output row.

Pricing

from $0.05 / 1,000 merged rows

Rating

0.0

(0)

Developer

jeenopylo

Actor stats

Bookmarked

Total users

Monthly active users

11 hours ago

Last modified

Categories

Automation

Developer tools

Security

You can access the Dataset Merge, Dedup and Convert (CSV, JSON, XLSX) 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

1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4# Replace '<YOUR_API_TOKEN>' with your token.
5client = ApifyClient("<YOUR_API_TOKEN>")
6
7# Prepare the Actor input
8run_input = {
9    "sources": [
10        "https://api.apify.com/v2/key-value-stores/rKmTb0uCShh9ssnDK/records/u2-people-a.csv?signature=c2fjNY6K0S5nDDUM0aSk",
11        "https://api.apify.com/v2/key-value-stores/rKmTb0uCShh9ssnDK/records/u2-people-b-semicolon.csv?signature=owJd10EzKDS9vqJ9JbBx",
12        "https://api.apify.com/v2/key-value-stores/rKmTb0uCShh9ssnDK/records/u2-people-c.json?signature=49kUyk1G8O46Kt3IlXdZ",
13        "https://api.apify.com/v2/key-value-stores/rKmTb0uCShh9ssnDK/records/u2-people-d.jsonl?signature=1tJaeq09Aiq0fPzXZEx7p",
14        "https://api.apify.com/v2/key-value-stores/rKmTb0uCShh9ssnDK/records/u2-people-e.xlsx?signature=1Ah1Wuo9fjfYaIZdPtVjJ",
15    ],
16    "dedupFields": ["email"],
17    "caseInsensitive": True,
18    "trim": True,
19    "keep": "first",
20    "columns": "union",
21    "outputFormat": "csv",
22    "maxRows": 500000,
23}
24
25# Run the Actor and wait for it to finish
26run = client.actor("enthusiastic_ginkgo_7ie/dataset-merge-dedup").call(run_input=run_input)
27
28# Fetch and print Actor results from the run's dataset (if there are any)
29print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
30for item in client.dataset(run.default_dataset_id).iterate_items():
31    print(item)
32
33# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

CSV, JSON and Excel Merge, Dedup and Convert Tool API in Python

The Apify API client for Python is the official library that allows you to use Dataset Merge, Dedup and Convert (CSV, JSON, XLSX) API in Python, providing convenience functions and automatic retries on errors.

Install the apify-client

$pip install apify-client

Other API clients include:

Dataset Merge, Dedup and Convert (CSV, JSON, XLSX) API in JavaScript

Dataset Merge, Dedup and Convert (CSV, JSON, XLSX) API through CLI

Dataset Merge, Dedup and Convert (CSV, JSON, XLSX) OpenAPI definition

Dataset Merge, Dedup and Convert (CSV, JSON, XLSX) API

Instagram Scraper

apify/instagram-scraper

Extract Instagram posts, reels, profiles, places, hashtags, carousels, and comments. Get data from Instagram using one or more Instagram URLs or search queries: content, context, metrics, metadata. Export scraped data, run the scraper via API, schedule and monitor runs or integrate with other tools.

Apify

467K

4.7

(604)

TikTok Scraper

clockworks/tiktok-scraper

Extract data from TikTok videos, hashtags, and users. Use URLs or search queries to scrape TikTok profiles, hashtags, posts, URLs, shares, followers, hearts, names, video, and music-related data. Export scraped data, run the scraper via API, schedule and monitor runs or integrate with other tools.

Clockworks

380K

4.8

(370)

Google Maps Scraper

compass/crawler-google-places

Extract data from thousands of Google Maps locations and businesses, including reviews, reviewer details, images, contact info, including full name, email, and job title, opening hours, prices & more. Export data, run via API, schedule and monitor runs, or integrate with other tools.

Compass

682K

4.7

(1,825)

Instagram Profile Scraper

apify/instagram-profile-scraper

Scrape all Instagram profile info. Just add Instagram usernames, IDs or URLs and extract name, join date, number of followers, location, bio, website, related profiles, video&post count, latest posts. Export scraped data, schedule scraper via API, and integrate with other tools or AI workflows.

Apify

275K

4.7

(175)

Instagram Reel Scraper

apify/instagram-reel-scraper

Scrape or download Instagram reels. Just add Instagram profile or reel URL, and get caption, timestamp, transcript, hashtags, mentions, tagged users, comments, likes, shares, views, duration, and downloaded video. Export scraped data, schedule via API, and integrate with other tools or AI workflows.

Apify

185K

4.4

(102)

Google Search Results Scraper

apify/google-search-scraper

Scrape Google Search Engine Results Pages (SERPs). Select the country or language and extract organic and paid results, AI Mode, AI overviews, ads, queries, People Also Ask, prices, reviews, like a Google SERP API. Export data, run the scraper via API, schedule runs, or integrate with other tools.

Apify

227K

4.7

(218)

Facebook Posts Scraper

apify/facebook-posts-scraper

Extract posts, videos, and engagement metrics from Facebook pages. Get text captions, reactions, video transcripts, images, external links, collaborators, and more from Facebook pages and profiles. Export ad data, schedule runs via API, and integrate with other tools or AI workflows.

Apify

137K

4.7

(236)

LinkedIn Profile Scraper + Email (No Cookies)

harvestapi/linkedin-profile-scraper

Extract detailed information from LinkedIn profiles in bulk, including complete work experience, education history, skills and more. No cookies or account required.

HarvestAPI

93K

4.6

(93)

Instagram Hashtag Scraper

apify/instagram-hashtag-scraper

Scrape Instagram posts and reels by hashtags. Just add one or more hashtags and extract captions, locations, likes, plays, shares, comments count, images, timestamps, audio, and other hashtags. Export scraped hashtags, run the scraper via API, schedule and monitor runs or integrate with other tools.

Apify

147K

3.5

(91)

Google Search Results (~$0.05/1K Results)

scraperlink/google-search-results-serp-scraper

🔥 ~$0.05/1K results ($0.50/1,000 SERPs) 🔥 **CHEAPEST** Google Search Results (SERP) Scraper with real-time SERP data and support for multiple countries. Billed per 1 full SERP page (~10 results) — making it ~10× cheaper than others.