Resources · Prompt Library
AI Spreadsheet
Prompt Library
Stop writing formulas. Copy and paste these engineered prompts into CSV Analyst to instantly clean, enrich, and categorize your spreadsheets.
Sales & Leads
B2B Lead Qualifier
Read the company bio. If it mentions selling to other businesses, output "B2B", otherwise output "B2C". Also extract the main industry (e.g. Healthcare, SaaS, Retail).
Try this prompt →
Support
Ticket Sentiment & Urgency
Analyze the support ticket text. Determine the sentiment (Positive, Neutral, Frustrated). If the user mentions cancelling, payment failure, or system down, set urgency to 'High'. Output as a JSON object: {"sentiment": "...", "urgency": "..."}
Try this prompt →
Ecommerce
Product Description Parser
Extract the physical dimensions (width, height, length) and the color from this product description. If dimensions are missing, output 'N/A'. Standardize colors to single basic words (e.g., 'Navy' becomes 'Blue').
Try this prompt →
Data Cleaning
Name & Title Standardizer
Clean the messy name field. Ensure proper Title Case capitalization. Split the name into First Name and Last Name. If a job title is mixed into the name field, separate it into a 'Job Title' column.
Try this prompt →
Sales & Leads
Email Verifier Regex Pattern
Find all email addresses within the messy meeting notes paragraph. Discard any emails that end with '.edu' or '.gov'. Return the remaining emails as a comma-separated list.
Try this prompt →
Data Cleaning
Address to JSON Parser
Read the unstructured address string. Output a strict JSON object with the following keys: Street, City, State, Zip_Code, Country. If any part of the address is missing, assign the value null.
Try this prompt →
Have a messy CSV?
Don't code. Just plug any of these prompts directly into CSV Analyst and watch it process thousands of rows instantly.
→ Test with your data