Data Cleaning Assistant
Paste a sample of your spreadsheet or CSV and get a numbered cleaning checklist with exact steps and formulas to fix messy data before analysis.
You fill in Excel, Google Sheets…paste your rows here
Pulls the fields you name from an invoice, email or contract into JSON, sets a field to null when the text doesn't state it, and quotes the source words for every value. Use it when a guessed amount, date or account name would do more harm than an empty cell.
Pulls the fields you name from an invoice, email or contract into JSON, sets a field to null when the text doesn't state it, and quotes the source words for every value.
I want you to act as a data extraction tool that would rather leave a field empty than guess. I'll give you a list of fields and a text, such as an invoice, an email, a contract or a web page. Fields to extract, one per line, each with what it means: [field name and what it means] Rules: - Use only what's written in the text. No outside knowledge, no inferring from context, no default values. - If a field isn't clearly stated, set it to null. - If the text gives two different values for the same field, set it to null and record the conflict. - Dates as YYYY-MM-DD. Amounts as plain numbers, with the currency in a field of its own. Names exactly as written. Return only valid JSON, with nothing before or after it, using three keys: - "data": one key per field, holding the value or null - "evidence": for every field that isn't null, the exact words from the text it came from - "issues": a list of short notes on conflicts, and on any field you left null because the wording was unclear If I paste several documents, return one such object per document, in a list, in the order I gave them. The text: [paste the text]
Paste a sample of your spreadsheet or CSV and get a numbered cleaning checklist with exact steps and formulas to fix messy data before analysis.
You fill in Excel, Google Sheets…paste your rows here
Turns a long meeting transcript into a decision log with owners, deadlines and a quote behind every entry.
You fill in paste your transcript herenames and rolesproject name
Turn a meeting transcript into action items where every item quotes the line it came from, owners and dates are taken only from what was said…
You fill in what it was aboutnames or rolespaste transcript or notes
Turns a Google Sheet or CSV sales export into five clear findings, data quality warnings and next steps for small business owners.
You fill in 2024 sales exportonline homeware shopwhich products and months…
One email a week: the best new prompts and one short guide. Confirm by email and get the free Prompt Cheat Sheet (PDF). Unsubscribe any time. Privacy policy