Clean a CSV or Google Sheet by URL and Export to Excel

Created by

Adam Pearce

Actor

Dataset Cleaner & Exporter

Load a public CSV, Excel, JSON file or Google Sheet by link (here the open ISO country-codes CSV on GitHub), keep only the columns you want, trim and normalise every field, deduplicate on a key, and download the result as CSV and Excel. Capped at 50 records so a test click costs about 12 cents; remove the cap for the full file. Swap in your own file or sheet link.

Try for free

Dataset Cleaner & Exporternerolabs/dataset-cleaner-exporter

Company Name

Phone

Website

+7 fields

Input

File URL (CSV, Excel, JSON or Google Sheet):https://raw.githubusercontent.com/datasets/country-codes/main/data/country-codes.csv

Deduplication mode:normalized

Deduplication keys:ISO3166-1-Alpha-2

Columns to keep:ISO3166-1-Alpha-2+6

Rename columns:ISO3166-1-Alpha-2:iso2+2

Export file formats:csv+1

Max output records:50

Output fields

Company Name

Phone

Website

Bio

Founded

Active

HQ City

HQ State

How it works

Sign up on Apify or log in

The Dataset Cleaner & Exporter Actor is ready to run with the inputs already set for "Clean a CSV or Google Sheet by URL and Export to Excel". Sign up or log in and you'll land in Apify Console with a copy of this exact task.

Start the "Clean a CSV or Google Sheet by URL and Export to Excel" task

The Dataset Cleaner & Exporter Actor will start running based on the input automatically. You can also change all the input fields, like file url (csv, excel, json or google sheet), deduplication mode, and more, to match your specific use case.

Receive the "Clean a CSV or Google Sheet by URL and Export to Excel" 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 company name, email, phone, and more.