Pricing

from $10.00 / 1,000 results

Data Cleaning & Transformation Toolkit

A powerful, multi-mode Apify actor that transforms messy, unstructured data into clean, structured JSON — ready for APIs, databases, or downstream processing.

Pricing

from $10.00 / 1,000 results

Rating

0.0

(0)

Developer

Jamshaid Arif

Actor stats

Bookmarked

Total users

Monthly active users

7 days ago

Last modified

Categories

Developer tools

Automation

Integrations

Transformation Mode

mode

Required

Select the type of data transformation to perform.

Type:string

Default:messy_text

Options:

messy_textexcel_csvhtml_scrapekey_valueurl_fetch

Input Text / Raw Data

inputText

Optional

Paste your messy text, key-value config, or raw HTML here. Not needed if uploading a file or fetching a URL.

Type:string

File URL (Excel / CSV / HTML)

fileUrl

Optional

Direct URL to an .xlsx, .csv, or .html file to download and process.

Type:string

Default:

URLs to Scrape

urls

Optional

List of web page URLs to fetch and extract data from (for url_fetch and html_scrape modes).

Type:object[]

Default:

[
  {
    "url": "https://books.toscrape.com/"
  }
]

Text Parsing Strategy

textParseStrategy

Optional

How to parse the messy text. 'auto' detects the format automatically.

Type:string

Default:auto

Options:

autodelimitedkey_valueblock

Key-Value Format

kvFormat

Optional

Format of the key-value input. 'auto' detects automatically.

Type:string

Default:auto

Options:

autoenvinilogyaml

HTML Extraction Mode

htmlExtractMode

Optional

What to extract from the HTML content.

Type:string

Default:tables

Options:

tableselementslinkstextauto

CSS Container Selector

cssSelector

Optional

CSS selector for repeating items (e.g., 'div.product-card', 'li.item'). Used in 'elements' HTML mode.

Type:string

Default:article.product_pod

Field Mapping (JSON)

fieldMap

Optional

JSON object mapping output field names to CSS selectors within each container. Example: {"title": "h3 a", "price": ".price_color"}

Type:string

Default:{ "title": "h3 a", "price": ".price_color", "availability": ".availability", "rating": "p.star-rating" }

Sheet Name

sheetName

Optional

Specific Excel sheet to read. Leave empty to read all sheets.

Type:string

Default:

Skip Empty Rows

skipEmptyRows

Optional

Remove rows that are entirely blank from the output.

Type:boolean

Default:true

Forward-Fill Columns

forwardFillColumns

Optional

Comma-separated list of column names to forward-fill (for merged cells in Excel). Leave empty to skip.

Type:string

Default:

Page Size (Pagination)

pageSize

Optional

Number of records per page in the output. Set to 0 for no pagination.

Type:integer

Minimum:0

Maximum:10000

Default:0

Output Format

outputFormat

Optional

How to structure the final output in the dataset.

Type:string

Default:records

Options:

recordswrappedflat

Proxy Configuration

proxyConfiguration

Optional

Proxy settings for fetching URLs. Uses Apify Proxy by default.

Type:object

Default:

{
  "useApifyProxy": true
}

Max Request Retries

maxRequestRetries

Optional

Maximum number of retries for failed HTTP requests.

Type:integer

Minimum:0

Maximum:10

Default:3

Text-to-JSON Structured Extractor

moving_beacon-owner1/my-actor-68

A versatile Apify actor that converts unstructured text and HTML into clean, structured JSON. Supports four extraction modes with auto-detection, URL fetching, and batch processing.

Jamshaid Arif

Structured Data Crawler

tempting_district/structured-data-crawler

Crawl public web pages and convert unstructured content into clean, deterministic, schema-first structured records.

Lone

🔥 AI HTML to JSON Extractor (Fast, Free LLM for Data)

autoscaler/ai-html-to-json-extractor

Eliminate messy HTML cleanup and high LLM costs. This Actor uses a high-speed, zero-cost large language model to turn unstructured content (HTML, text, reviews, blog posts) into valid, structured JSON.

Mooo

Code Converter Toolkit

moving_beacon-owner1/my-actor-64

A universal code conversion actor that transforms between 6 popular code formats in a single run. Supports both single and batch conversions with structured JSON output.

Jamshaid Arif

JSON To XML Converter

zsoftware/json-to-xml-converter

Easily convert structured JSON data into well-formed XML. This actor accepts raw JSON text or a file and outputs clean, standards-compliant XML—perfect for data transformation pipelines, integrations, or legacy system compatibility.

Karim

Image To Text Ai

welcoming_fireplace/image-to-text-ai

A powerful OCR tool that goes beyond standard text extraction. Powered by a Premium Vision AI model, it accurately reads handwriting, preserves table structures, and converts messy receipts or documents into structured JSON or Markdown. Supports batch processing for high-volume workflows.

Richmond Nkrumah

apx-toolkit

irun2themoney/apx-toolkit

Discover APIs. Generate code. Save weeks of work.

Jose Gorbea

Linkedin Jobs Scraper

dead00/linkedin-jobs-scraper

A LinkedIn job scraper this scraper extracts comprehensive job listings from LinkedIn with advanced data processing and cleaning capabilities.

Dead

job-scraper-supabase

raviskydive/jobscraper

Modular Apify actor that scrapes job listings from LinkedIn, Indeed, Glassdoor, and Monster, normalizes data, and optionally upserts results into Supabase for downstream use.

Ravi

PDF AI Extractor MCP

devaditya/pdf-ai-extractor-mcp

Extracts text, tables, summaries, and structured data from any PDF using OpenAI, Google Gemini, or Claude. Supports bulk AI processing, clean JSON exports, and an AI-ready MCP mode for agent workflows.