Pricing

from $0.55 / 1,000 output rows

Try for free

Go to Apify Store

Dataset Filter & Transform: Filter, Pick, Rename, Flatten

Try for free

Clean any Apify dataset without code: filter rows (equals, contains, regex, greater than, empty…), keep or drop columns, rename fields, flatten nested JSON, split list fields into rows, add tags. Chain it between a scraper and Google Sheets, CSV export or alerts.

Pricing

from $0.55 / 1,000 output rows

Rating

0.0

(0)

Developer

Charles Markette

Actor stats

Bookmarked

Total users

Monthly active users

a day ago

Last modified

Categories

You can access the Dataset Filter & Transform: Filter, Pick, Rename, Flatten 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

$echo '{
<  "items": [
<    {
<      "name": "Blue Door Cafe",
<      "website": "https://bluedoor.example",
<      "rating": 4.6,
<      "emails": [
<        "hello@bluedoor.example"
<      ],
<      "address": {
<        "city": "Oslo"
<      }
<    },
<    {
<      "name": "Corner Bar",
<      "website": "",
<      "rating": 4.2,
<      "emails": [],
<      "address": {
<        "city": "Bergen"
<      }
<    },
<    {
<      "name": "Harbor Hotel",
<      "website": "https://harbor.example",
<      "rating": 3.8,
<      "emails": [
<        "info@harbor.example"
<      ],
<      "address": {
<        "city": "Bergen"
<      }
<    },
<    {
<      "name": "Fjord Bakery",
<      "website": "https://fjordbakery.example",
<      "rating": "4.9",
<      "emails": [
<        "post@fjordbakery.example"
<      ],
<      "address": {
<        "city": "Oslo"
<      }
<    }
<  ],
<  "filters": [
<    {
<      "field": "website",
<      "op": "isNotEmpty"
<    },
<    {
<      "field": "rating",
<      "op": "greaterOrEqual",
<      "value": 4
<    }
<  ]
<}' |
<apify call charlesmarkette/dataset-filter-transform-rename-flatten-fields --silent --output-dataset

Dataset Filter & Transform: Filter, Pick, Rename, Flatten API through CLI

The Apify CLI is the official tool that allows you to use Dataset Filter & Transform: Filter, Pick, Rename, Flatten locally, providing convenience functions and automatic retries on errors.

Install Apify CLI

Using installation script (macOS/Linux):

$curl -fsSL https://apify.com/install-cli.sh | bash

Using installation script (Windows):

$irm https://apify.com/install-cli.ps1 | iex

Using Homebrew:

$brew install apify-cli

Using npm:

$npm install -g apify-cli

Other API clients include:

Dataset Filter & Transform: Filter, Pick, Rename, Flatten API in Python

Dataset Filter & Transform: Filter, Pick, Rename, Flatten API in JavaScript

Dataset Filter & Transform: Filter, Pick, Rename, Flatten OpenAPI definition

Dataset Filter & Transform: Filter, Pick, Rename, Flatten API

Merge, Deduplicate & Export Datasets — CSV, Excel, JSON

tidydata/merge-dedupe-datasets

Combine several Apify datasets or CSV/JSON files into one, remove duplicates by any field, filter rows, rename or drop columns, keep only new rows since the last run, and export CSV, Excel or JSON with a download link. Clear errors, no setup.

tidydata

Website Contact Info Scraper: Emails, Phones & Social Links

charlesmarkette/website-contact-info-scraper-emails-phones-socials

Get the emails, phone numbers (E.164), social profiles, address and company name that company websites publish. Reads the home page and contact pages, decodes Cloudflare-protected emails, ranks on-site contacts first. One row per website; enrich any lead dataset.

Charles Markette

Dataset Flatten and Field Mapper

eager_vitamin/apify-dataset-flatten-field-mapper

Flatten nested JSON, rename and drop fields, and coerce simple types in Apify datasets without writing transformation code.

Lau Kuan Ee

Dataset Merge & Dedup Datasets — Filter, Join CSV & Excel

saliga/dataset-merge-dedupe

Merge Apify datasets, CSV, JSON and Excel files or Google Sheets into one table. Clean fields, normalise URLs, extract domains, filter, remove duplicates and join (VLOOKUP) in one run. Works with limited permissions. CSV and Excel exports free. $0.50 per 1,000 output rows.

Salih Küçükkayış

RSS & Atom Feed Reader: Bulk, Only New Items, Auto-Discovery

charlesmarkette/rss-atom-feed-reader-only-new-items

Read many RSS, Atom and JSON feeds into one clean dataset. Paste feed or website URLs (feeds are found automatically), get only items that are new since the last run, filter by date and keywords. Ideal for news, blog and podcast monitoring with alerts.

Charles Markette

Broken Link Checker: Crawl a Website, Find 404s & Redirects

charlesmarkette/broken-link-checker-crawl-website-404

Crawl your website and check every link once: find 404s, server errors, redirect chains and loops, with the pages and anchor text where each broken link appears. Optional images, scripts and external links, sitemap seeding and robots.txt. For SEO audits and migrations.

Charles Markette

Dataset Filter & Transform - Dedupe, Clean, Export CSV

gazidev/dataset-filter-transform

No-code filter, dedupe and transform for Apify datasets, CSV, XLSX and JSON files: rules (equals, contains, regex, ranges, dates, AND/OR), dedupe by fields, only-new-since-last-run, rename/select/drop, flatten, cast, sort, limit. Output to dataset plus CSV/XLSX/JSON export. Pay per row.

Cemal Atakli

PDF & Image to Text: Bulk, Markdown, Tables, OCR

charlesmarkette/pdf-image-to-text-markdown-ocr

Turn PDFs and images into clean text or Markdown for RAG, LLMs and data entry: headings, reading order, tables, PDF metadata. Scanned pages and images are read with OCR (7 languages). Bulk URLs or a dataset of links. No API key.

Charles Markette

Phone Number Validator & Formatter: Bulk, E.164, Mobile Check

charlesmarkette/phone-number-validator-formatter-bulk-e164

Validate and format phone numbers in bulk or enrich any dataset: valid/invalid, E.164, international and national format, mobile/landline/VoIP type, country, location, carrier and time zones. Finds numbers in text, removes duplicates. Offline, no API key.

Charles Markette

Domain Availability Checker: Bulk, RDAP, Name Ideas

charlesmarkette/domain-availability-checker-bulk-name-ideas

Check which domain names are free to register, in bulk, with no API key. Paste names or generate ideas from keywords × TLDs (.com, .io, .ai, .app…) with prefixes and suffixes. Official registry RDAP with WHOIS fallback, plus registrar and expiry for taken names.

Charles Markette