Prompts · 7 min read · October 21, 2026
Last verified: October 21, 2026
100 Word & Excel AI commands
Upload a Word or Excel file to an AI assistant and type a command. 100 ready-made shortcuts that turn reports into summaries, tables into charts and notes into plans.
Skip to the commandsUpload your file to an AI assistant and type a command. I've gathered 100 ready-made shortcuts that turn reports into summaries, tables into charts and notes into plans. The first 50 are for Word documents (DOCX): document analysis, visualisation, conversion and content creation. The next 50 are for Excel spreadsheets (XLSX): charts, analysis, forecasts and reports. Tap a command to copy it.
How to use them
Upload your Word (DOCX) or Excel (XLSX) file to ChatGPT, Claude or Gemini.
Tap the command you want below to copy it, then paste it into the message box.
Add a short detail next to the command (period, goal, format) and send.
/DASHBOARD Show the last 6 months of sales, the top 5 products and a monthly growth card.Word: Visualise and convert
- 01
Turns the process in the document into a visual flowchart with decision points.
- 02
Creates a roadmap by splitting goals into phases and dates.
- 03
Turns the document's main topic and subheadings into a mind map.
- 04
Shows events and dates on a chronological timeline.
- 05
Turns the key information in the document into a one-page infographic.
- 06
Creates a diagram that connects the tasks and decisions in the document with boxes.
- 07
Creates a YES/NO tree branching from the decision options.
- 08
Visually shows how concepts relate to each other.
- 09
Turns employees, departments and reporting lines into an org chart.
- 10
Turns the script in the document into a scene-by-scene storyboard.
Word: Analyse and extract
- 11
Pulls out the most striking findings and key conclusions.
- 12
Turns a long report into a one-page executive summary.
- 13
Analyses the strengths, weaknesses, opportunities and threats in the text.
- 14
Plots risks on a matrix by likelihood and impact.
- 15
Identifies the gaps between where things are now and the goal.
- 16
Turns the claims in the document that need verifying into a source checklist.
- 17
Spots contradictions, inconsistent figures and dates in the document.
- 18
Turns the to-dos in the document into a table with owner, date and priority.
- 19
Creates questions and an answer key from the information in the document.
- 20
Turns the cause-and-effect relationships in the text into a fishbone diagram.
Word: Teaching and learning
- 21
Turns lecture notes into question-and-answer flashcards.
- 22
Prepares multiple-choice test questions with four options from the document.
- 23
Turns a long course document into a topic summary and study plan.
- 24
Creates a timed lesson plan with activities from training content.
- 25
Rewrites complex technical text in language anyone can understand.
- 26
Builds an annotated glossary of the technical terms in the text.
- 27
Explains abstract information with concrete everyday examples.
- 28
Creates a step-by-step mini quiz to check understanding of the document.
- 29
Turns a long document into a one-page quick reference guide.
- 30
Creates frequently asked questions and answers from the document's content.
Word: Work and professional life
- 31
Turns messy meeting notes into tidy minutes.
- 32
Builds a plan with tasks, deliverables and dates from a project description.
- 33
Turns a business process into a standard operating procedure.
- 34
Writes a professional job ad from notes about the position.
- 35
Turns project notes into a proposal document for a client.
- 36
Flags the critical clauses in a contract and the risks worth reviewing.
- 37
Identifies vague and missing wording in company policies.
- 38
Sorts tasks into an Eisenhower matrix by importance and urgency.
- 39
Turns the responsibilities in a project into a RACI chart.
- 40
Turns long instructions into an actionable checklist.
Word: Content and creativity
- 42
Pulls 20 different attention-grabbing video openings from the content.
- 43
Turns long text into a plan for an Instagram carousel post.
- 44
Pulls slide titles and speaker notes from a Word document.
- 45
Turns an article into a podcast dialogue between two hosts.
- 47
Builds a 30-day content calendar from the ideas in the document.
- 48
Splits a story into setup, conflict, climax and resolution.
- 49
Turns the audience information in the document into user personas.
- 50
Rewrites the same text in three ways: friendly, professional and persuasive.
Excel: Visual analysis and charts
- 01
Turns the data into a dashboard with KPI cards and charts.
- 02
Creates a heat map that compares numbers by colour intensity.
- 03
Shows change over time with line charts.
- 04
Shows which categories results are concentrated in with a Pareto chart.
- 05
Visualises where users drop off across sales or conversion stages.
- 06
Shows the relationship between two numeric variables on a scatter plot.
- 07
Compares three numeric variables on the same chart.
- 08
Shows how changes in income or costs affect the total.
- 09
Shows each category's share of the total by area size.
- 10
Calculates the correlations between numeric columns and presents them as a matrix.
Excel: Money, finance and sales
- 11
Builds an expense analysis by sorting spending into categories.
- 12
Creates a monthly budget plan from income and expenses.
- 13
Compares the profitability of products or services.
- 14
Turns money in and out into a cash flow chart by period.
- 15
Calculates the break-even point from revenue and cost data.
- 16
Compares profit and margins under different pricing scenarios.
- 17
Produces an assumption-based sales forecast from past sales.
- 18
Calculates monthly and yearly revenue growth rates.
- 19
Estimates customer lifetime value from customer history.
- 20
Sorts products into A/B/C classes by their contribution to total sales.
Excel: Social media and marketing
- 22
Finds the most successful posting times by day and hour.
- 23
Calculates engagement rates from reach or follower data.
- 24
Visualises follower growth and how it changes over time.
- 25
Ranks videos by the performance metrics you choose.
- 26
Compares performance on Instagram, TikTok and YouTube.
- 27
Analyses ad cost, clicks and conversions.
- 28
Compares the reach and engagement of hashtag groups.
- 29
Examines the click-through rates of titles and thumbnails.
- 30
Finds the drop-off points in video audience retention data.
Excel: Data cleaning and automation
- 31
Produces a cleaning plan to fix spacing, formatting and data type problems.
- 32
Identifies duplicate records and prepares a clean-up table.
- 33
Detects statistically unusual values.
- 34
Analyses missing data and suggests how to fill it.
- 35
Creates a pivot table that summarises the data by category.
- 36
Writes the Excel formulas for the calculations you need.
- 37
Suggests validation rules to check data entry.
- 38
Merges two related tables on a shared key.
- 39
Creates a report with period-over-period comparisons from the data.
- 40
Scans for formula errors, inconsistent values and data problems.
Excel: Business, decisions and forecasts
- 41
Groups customers by spending and buying behaviour.
- 42
Analyses customer churn and possible risk signals.
- 43
Identifies critical products based on stock and sales velocity.
- 44
Compares employee or team data with a weighted scoring system.
- 45
Turns targets and actual results into a KPI report.
- 46
Builds optimistic, base and pessimistic scenarios.
- 47
Calculates how results change when selected inputs change.
- 48
Shows how customer groups return and are retained over time.
- 49
Pulls seasonal and periodic patterns from past data.
- 50
Creates an alert table that flags unusual sudden spikes and drops.
Which one when?
Pick by situation:
I couldn't get through a long report
I'm studying for an exam
My meeting notes are a mess
See the data on one screen
I don't know the formula
To get longer jobs done with ready-made prompt patterns, read 10 prompt patterns for ChatGPT. For new AI tools and workflows every week, join the newsletter.
