Search: clean-code — AI Prompts

excel Intermediate

Clean a Messy Excel Customer List Where Names Are in Six Different Formats

I have an Excel sheet with about 4,000 customer records. The Name column is a di...

#excel #data-cleaning #names

👁 4 views

excel Advanced

Replace a fragile nested IF with a clean LET-based formula

Here is a nested IF that has grown to 7 branches and is breaking when someone ad...

#LET function #nested IF #refactor

👁 4 views

excel Advanced

Reconcile two messy spreadsheets when the join keys don't match

I have two Excel files I need to reconcile, but the join columns aren't clean ma...

#excel #power-query #reconciliation

👁 4 views

excel Intermediate

Turn a messy date column into clean, consistent dates in Excel

I have an Excel column of dates entered in mixed formats (some text, some real d...

#excel #dates #data cleaning

👁 4 views

email Beginner

Turn Messy Notes into a Clear Status Update Email

Act as an executive communication assistant. I will paste rough, unstructured no...

#email #status update #summary

👁 4 views

legal Intermediate

Draft a Simple NDA or Service Agreement Template

Act as a legal drafting assistant who produces clear starter templates for small...

#legal #nda #contract

👁 4 views

data Intermediate

Design a Simple Data Model for My Spreadsheet

You are a spreadsheet/data modeling expert. Help me structure my data so it's cl...

#data #data-modeling #spreadsheets

👁 4 views

excel Intermediate

Clean up a sheet where dates are stored in five different formats

I inherited a spreadsheet where the 'Date' column has dates entered as '3/5/26',...

#excel #data cleaning #dates

👁 3 views

business Intermediate

Evaluate a partnership pitch that sounds great in the deck but feels off in the gut

A bigger company pitched me a partnership. The deck shows complementary audience...

#business #partnerships #due diligence

👁 3 views

data Intermediate

Clean a messy dataset without losing the rows that actually mattered

I have a dataset with [N] rows and [LIST PROBLEMS: missing values, duplicates, m...

#data #cleaning #preprocessing

👁 3 views

writing Advanced

Turn a chaotic interview transcript into a clean Q&A piece

I will paste a 90-minute interview transcript that is full of 'um's, tangents, a...

#writing #interview #editing

👁 3 views

excel Beginner

Clean and Deduplicate a Messy Excel Contact List

Act as an Excel data-cleaning specialist. I have a contact list with inconsisten...

#excel #data cleaning #deduplicate

👁 3 views

data Beginner

Design a Clean Data Collection Spreadsheet or Schema

You are a data architect who helps people set up clean data from the start so it...

#data #schema #spreadsheet

👁 3 views

coding Advanced

Design a REST API for a Feature

You are an API designer. Based on the feature I describe, design a clean REST AP...

#coding #api #rest

👁 3 views

legal Advanced

Decide whether a compliance gap is worth disclosing proactively

You're a compliance counsel. We've found a gap — we missed a notification, a con...

#compliance #disclosure #regulatory

👁 2 views

excel Intermediate

Turn a messy exported report into a clean pivot-ready table

You're an Excel power user. I pasted in an export from another system and it's a...

#power-query #data-cleaning #pivot

👁 2 views

excel intermediate

Clean Messy Excel Data Step by Step

Act as a data cleaning specialist. My Excel sheet has these issues: [list proble...

#excel #data cleaning #power query

👁 2 views

data Intermediate

Clean and Deduplicate a Raw Dataset

Act as a data engineer. I have a raw dataset with these issues: [DESCRIBE — dupl...

#data #cleaning #etl

👁 2 views

writing Intermediate

Line-Edit My Draft for Clarity and Flow

You are a meticulous line editor. I will paste a draft and you will improve it s...

#writing #editing #proofreading

👁 2 views

business Beginner

Turn Meeting Notes Into Action Items

You are an executive assistant. I will paste raw, messy meeting notes and you wi...

#business #meetings #productivity

👁 2 views

productivity Beginner

Turn a Messy Brain Dump into a Task Plan

You are a productivity coach. I will paste a messy brain dump of everything on m...

#productivity #task-management #gtd

👁 2 views

excel Beginner

Clean Messy Imported Data with Formulas

You are an expert Excel data-cleaning specialist. Help me clean a messy column o...

#excel #data-cleaning #trim

👁 1 views

excel Intermediate

Clean Messy Spreadsheet Data Step by Step

You are a data-cleaning specialist. I have a messy Excel sheet with these proble...

#excel #power-query #data-cleaning

👁 1 views

coding Intermediate

Design a Clean REST API Endpoint

You are an API designer. Help me design a REST endpoint for [DESCRIBE RESOURCE/A...

#coding #api #rest

👁 1 views

Search: "clean-code"

Clean a Messy Excel Customer List Where Names Are in Six Different Formats

Replace a fragile nested IF with a clean LET-based formula

Reconcile two messy spreadsheets when the join keys don't match

Turn a messy date column into clean, consistent dates in Excel

Turn Messy Notes into a Clear Status Update Email

Draft a Simple NDA or Service Agreement Template

Design a Simple Data Model for My Spreadsheet

Clean up a sheet where dates are stored in five different formats

Evaluate a partnership pitch that sounds great in the deck but feels off in the gut

Clean a messy dataset without losing the rows that actually mattered

Turn a chaotic interview transcript into a clean Q&A piece

Clean and Deduplicate a Messy Excel Contact List

Design a Clean Data Collection Spreadsheet or Schema

Design a REST API for a Feature

Decide whether a compliance gap is worth disclosing proactively

Turn a messy exported report into a clean pivot-ready table

Clean Messy Excel Data Step by Step

Clean and Deduplicate a Raw Dataset

Line-Edit My Draft for Clarity and Flow

Turn Meeting Notes Into Action Items

Turn a Messy Brain Dump into a Task Plan

Clean Messy Imported Data with Formulas

Clean Messy Spreadsheet Data Step by Step

Design a Clean REST API Endpoint