Pricing

from $0.40 / 1,000 results

Try for free

Go to Apify Store

CSV Cleaner

Try for free

Parse CSV text safely, normalize cells, and return structured JSON rows for APIs, automation, ETL pipelines, and data processing workflows.

Pricing

from $0.40 / 1,000 results

Rating

0.0

(0)

Developer

Luca Gallifuoco

Actor stats

Bookmarked

Total users

Monthly active users

2 days ago

Last modified

What this Actor does

Parse quoted CSV cells including embedded delimiters
Auto-detect comma, semicolon, or tab delimiters
Trim cells and skip empty rows

Input

csvText contains CSV with a header row. Choose delimiter detection and cleaning options.

Example input

{
  "csvText": "name,city\n Alice , Naples \nBob,Rome",
  "delimiter": "auto",
  "trimStrings": true,
  "skipEmptyRows": true
}

Output

One dataset item per parsed row with rowNumber and data.

Results are written to the default Apify dataset and can be consumed from the Console, API, Make, Zapier, or other automation workflows.

Common use cases

Convert CSV exports to JSON
Prepare spreadsheet exports for APIs
Clean CSV data before automation

Pricing

This Actor is designed for transparent pay-per-event pricing. Check the current Apify Store pricing before running it.

Limitations

First non-empty row is treated as the header
No automatic number/date type inference
Input is provided as text, not fetched from a URL

Privacy and safety

Input data is processed deterministically.
No credentials are embedded in the Actor source.
This utility does not require external website access.
Review sensitive or regulated data handling requirements before processing such data.

Fast Dataset Cleaner & CSV Formatter

motivational_nickel/dataset-cleaner-and-formatter

Fast dataset cleaning for CSV and JSON files. Automatically removes duplicates, trims whitespace, fixes capitalization, and normalizes fields. Works with Apify datasets or uploaded files and prepares data for analytics, CRM imports, and automation pipelines.

Leoncio Jr Coronado

CSV Cleaner & Deduplication Tool

taroyamada/csv-data-cleaner

Clean user-supplied CSV tables by trimming whitespace, removing empty rows, deduplicating selected columns, and sorting records without external data collection.

naoki anzai

Metaworld Data Cleaner

metaworldsystems/metaworld-data-cleaner

Messy CSV in — validated, deduplicated, typed records out, with a data-quality report naming every rejected row and why.

Metaworld Systems

Pinterest Easy Scraper

dainty_screw/pinterest-easy-scraper

Discover unlimited public data on Pinterest with our Easy Scraper. Dive into profiles and "pins" with more depth than ever. Your free, go-to tool for seamless Pinterest insights.

codemaster devops

157

Bulk Phone Format Validator

taroyamada/phone-number-validator

Validate and normalize user-supplied phone strings offline with libphonenumber rules. Return E.164 formatting, country, and number type without discovering people or numbers.

naoki anzai

🌐 DNS Propagation Checker

taroyamada/dns-propagation-checker

Query up to 200 domains across 8 global resolvers to extract A, NS, and SOA records and audit worldwide nameserver propagation instantly.

naoki anzai

Bulk Email Syntax & MX Validator

taroyamada/email-deliverability-checker

Audit user-supplied email data using syntax, DNS MX, and disposable-domain checks. No messages are sent and no addresses are discovered or enriched.

naoki anzai

Tech Events & CFP Calendar Scraper

taroyamada/tech-events-intelligence

Extract upcoming developer conferences, local meetups, and open Call for Papers (CFP) deadlines to build a comprehensive speaking schedule for your DevRel team.

naoki anzai

MAS Singapore Financial Institutions Directory Scraper

alwaysprimedev/mas-singapore-financial-institutions-directory-scraper

Scrape every MAS-licensed bank, insurer, payment-service provider, capital-markets licensee, and financial adviser in Singapore — with full licence breakdowns, sub-activities, key personnel, and contacts.

Always Prime

CSV & Excel Data Quality Cleaner

automation-lab/csv-excel-data-quality-cleaner

Clean CSV and Excel files under explicit rules, normalize columns and values, flag or remove duplicates, and export cleaned rows plus a structured validation report.