← All use cases

Clean and prepare messy data

Work through tabular data while leaving the original untouched.

Drop in a disorganized CSV or spreadsheet, or mention it by name, explain what looks wrong, and ZeroTwo saves a tidied copy while leaving the source file exactly as it was.

Easy
5m

Skills & Plugins

  • Spreadsheets
    Cleans .csv, .tsv, and .xlsx files into outputs you can review ($spreadsheets).

Starter prompt

I've attached an export from our billing system (invoices_q3.csv). It has dates in three formats, amounts mixed between $ and EUR, some duplicate invoice IDs, and subtotal rows scattered through it. Write a cleaned copy as a new CSV with ISO dates and one currency column, leave the original untouched, and add a short note listing every row you changed, dropped, or weren't sure about.

Introduction

Have ZeroTwo clean a copy of the file and leave the original alone.

How to use

Attach the file, describe known problems, name the output you need, and review the cleaned copy and quality note before downstream use.

Related use cases