Advanced JSON / CSV Data Cleaner
Pricing
from $0.10 / 1,000 cleaned records
Advanced JSON / CSV Data Cleaner
Clean, deduplicate, validate and convert JSON, JSONL, CSV and XLSX files. Includes field mapping, optional type inference and heuristic PII redaction.
Pricing
from $0.10 / 1,000 cleaned records
Rating
0.0
(0)
Developer
林 吴
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
15 hours ago
Last modified
Categories
Security
Limited permissionsShare
Turn messy tabular data into validated, reusable records. Convert between JSON, JSONL, CSV and modern Excel (.xlsx), remove duplicates, rename fields, and validate records against JSON Schema.
Quick start
Paste a JSON array, JSONL or CSV into raw_text, or provide one publicly downloadable source_url. Choose your output format and run.
The result is one record: {"name":"Alice","age":"30"}. Enable infer_types to convert age to a number. Type inference is off by default to preserve identifiers and leading zeroes.
Features
- JSON / JSONL / CSV / TSV / XLSX input; JSON / JSONL / CSV / XLSX output
- Conservative JSON repair: curly quotes and trailing commas; full Markdown code fences accepted
- Exact record deduplication, top-level whitespace trimming and empty-field removal
- Top-level field mapping (
{"old":"new"}), dotted-header nesting - JSON Schema validation with up to 100 diagnostic messages
- Optional heuristic email, phone, card-like number and IPv4 redaction; this is not guaranteed anonymization
Results
The default dataset contains cleaned records. The key-value store contains OUTPUT (selected format) and SUMMARY (input/output counts, duplicates, validation errors and redactions). Obtain download links in the run's Storage tab. Standard dataset export is also available.
Malformed JSONL fails the run rather than silently discarding lines. Invalid Schema records are retained with diagnostics unless drop_invalid is enabled. CSV and XLSX are exported with formula execution prevention. Input limits: 30 MB and up to 100,000 records; default 20,000. Inputs above the record limit fail rather than truncate. XLSX formulas are read as cached values; legacy .xls is unsupported. CSV requires a header row. Do not submit duplicate headers.
Pricing
$0.10 per 1,000 output records ($0.0001 each). Failed conversions have no custom record event. Store pricing is authoritative.
Suitable workflows
Clean scraped datasets before CRM imports, normalize automation output, validate LLM records, and prepare structured data for analysis.
Platform costs
Apify platform compute, storage and transfer usage is paid separately by the user, in addition to the custom event price. No separate custom startup or dataset insertion event is configured.
