Clean a CSV file: trim, fix case and remove duplicates

Created by

Ed Rayyis

Actor

CSV Cleaner: trim, fix case, drop empty rows, deduplicate

Cleans the sample US states CSV: trims spaces, removes empty rows and duplicate rows, and reports how many rows each step removed, with a cleaned CSV file to download. Swap in your own CSV, JSON or Google Sheets link.

Try for free

CSV Cleaner: trim, fix case, drop empty rows, deduplicateexamsens.ai/csv-cleaner

Row

Input

File URLs:https://raw.githubusercontent.com/plotly/datasets/master/2014_usa_states.csv

File format:auto

Output fields

Row

How it works

Sign up on Apify or log in

The CSV Cleaner: trim, fix case, drop empty rows, deduplicate Actor is ready to run with the inputs already set for "Clean a CSV file: trim, fix case and remove duplicates". Sign up or log in and you'll land in Apify Console with a copy of this exact task.

Start the "Clean a CSV file: trim, fix case and remove duplicates" task

The CSV Cleaner: trim, fix case, drop empty rows, deduplicate Actor will start running based on the input automatically. You can also change all the input fields, like file urls and file format, to match your specific use case.

Receive the "Clean a CSV file: trim, fix case and remove duplicates" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as row.