Clean up a spreadsheet

Remove duplicates, standardize formats, fill gaps and flag outliers — get a clean file, a cleanup report and a reusable Python script.

Prompt

Clean up my uploaded customer list: remove duplicate rows, standardize phone numbers and date formats, fill in missing cities. Flag obviously wrong values like negative amounts or future dates for me to review instead of changing them. Give me the cleaned file (keep the original) and tell me how many rows each step changed.

Make one like this
Source
Ofox

How to use

  1. 1

    Tap “Make one like this”

    Ofox Chat opens with this request already written. Sign in first if you haven’t.

  2. 2

    Make it yours

    Edit the highlighted parts of the prompt to swap in your own details.

  3. 3

    Send and create

    Send it and Ofox Chat writes and runs the code, then you can preview or download the result. Keep chatting to change it.

FAQ

What do I get?

A web page you can open right away. Ofox Chat writes the code and runs it in a sandbox; you can preview the result in the chat and download the code files.

Do I need to know how to code?

No. Describe what you want in plain words and upload any files it should work on — Ofox Chat writes and runs the code.

Can I edit the prompt?

Yes. The prompt goes into the Ofox Chat input box — swap in your own topic, add requirements or drop what you don’t need before sending.

Can I copy and use the prompt directly?

Yes. Tap “Copy” on the prompt card to get the plain text — it works in other AI coding tools too.

More like this

More Data prompts

Have an idea of your own? Start creating

Describe the image you want in one sentence, and Ofox Chat creates it from scratch.

Start creating