100 Best Claude Excel Data Analysis Prompts for Wedding Planners

Direct Answer

The best Claude prompts for Excel data analysis for wedding planners are tailored to extract actionable insights from budget, guest, and vendor data. They produce concise reports, dashboards, and recommendations that help you optimize finances, timelines, and guest experience while keeping clients informed.

Introduction

This prompt library focuses on Excel data analysis for wedding planners. It provides ready-to-use Claude prompts you can execute against your data to drive faster, more accurate planning.

Designed for wedding planners, coordinators, and event managers, the prompts cover budgeting, guest management, vendor analysis, timelines, and client reporting so you can deliver professional results.

How to Use These Claude Prompts

• Replace placeholders like [growthRate] and [marginTarget] with your real values.
• Add constraints to outputs such as date ranges, currencies, or specific vendors.
• Request outputs in formats that fit your workflow, like CSV, table, or short narrative summary.
• Verify outputs by cross-checking a sample against your source sheets and adjust prompts as needed.
• For repeat work, save prompts with fixed parameters to build reusable templates.
• If outputs look off, ask for a quick reformulation that tightens scope and clarifies metrics.

100 Best Claude Excel Data Analysis Prompts for Wedding Planners

1. Budget variance check: You are a data analyst for a wedding planning firm. Task: compare actual expenses vs. budgeted amounts from the sheet named Budget by category and vendor. Context: use the most recent actuals column and the original budget column. Output: generate a summary table with variance amount, variance percent, and risk color (green 0-5%, yellow 5-15%, red above 15%). Constraints: include only categories with variance above zero and present results in a clean CSV format.
2. Guest list completeness: You are an event data specialist. Task: assess the completeness of the guest list across columns: names, emails, rsvps, meal choices, and seating preferences. Context: pull counts for each field, highlight missing values, and provide a priority order for data enrichment. Output: a ranked list of missing data fields with recommended actions and a summary score out of 100.
3. Vendor spend distribution: You are a procurement analyst for weddings. Task: create a distribution chart dataset from the Vendors sheet showing total spend per vendor category, convert to percentages, and identify the top 3 spenders. Context: include vendor category, vendor name, cost, share of total, and count of transactions. Output: provide a tab-delimited table ready for import into a chart tool.
4. Timeline milestone forecast: You are a project analyst for wedding planning. Task: forecast key milestones by date using historical timelines in the Activities sheet. Context: use a simple linear projection, adjust for weekends, and flag milestones likely to slip. Output: a forecast table with milestone, expected date, days to deadline, and risk flag (low/medium/high). Constraints: exclude past milestones.
5. Seasonal demand heatmap: You are a data scientist for a wedding studio. Task: build a heatmap of booking counts by month and year from the Bookings sheet. Context: count per month across years, include a color code column for intensity, and provide a brief interpretation. Output: a CSV with Month, Year, BookingCount, IntensityTier, Interpretation.
6. Rsvps and meal correlation: You are a data analyst. Task: analyze the correlation between RSVP status and meal choice in the RSVPs sheet. Context: compute chi-square test of independence, provide Cramér's V, and list any significant associations. Output: a results table with Variables, ChiSquare, PValue, CramérsV, and Recommendation.
7. Budget scenario builder: You are a financial planner for weddings. Task: create a scenario builder using the Budget sheet with sliders: guest count, vendor rates, tax, and service charges. Context: generate three scenarios (base, optimistic, conservative) and output total cost and per-guest cost for each scenario. Output: three rows with scenario name, totalCost, perGuestCost, and notes.
8. Vendor performance dashboard: You are a dashboard designer for wedding vendors. Task: generate a compact vendor performance scorecard from the Vendors sheet using metrics: on-time delivery, communication score, quality rating, and total spend. Context: compute weighted score and rank top 5 vendors. Output: a CSV ready table with Vendor, OnTime, ContactScore, Quality, Spend, WeightScore, Rank.
9. Seating optimization hints: You are an event planner. Task: from the Seatings sheet, propose optimal table assignments to maximize guest satisfaction based on relationships and dietary restrictions. Context: provide 5 alternative seating plans with explanation notes. Output: a list of 5 plans each containing PlanName, Tables, Notes.
10. A/V equipment checklist: You are a planning assistant. Task: analyze the Equipment sheet to produce a consolidated A/V requirement checklist by event area. Context: group by room, summarize quantity, rental cost, and lead time. Output: a checklist table with Room, Item, Quantity, Cost, LeadTime, Total.
11. Future earnings projection: You are a financial analyst. Task: project net profit for the wedding portfolio for the next four quarters using historical revenue and variable costs from the Portfolio sheet. Context: apply a linear growth rate of [growthRate] and a margin target of [marginTarget]. Output: a quarterly projection table with Quarter, Revenue, Costs, NetProfit, Margin.
12. Guest engagement score: You are a data analyst. Task: compute a guest engagement score from multiple columns: RSVP, meal preference, gift status, and post-event survey. Context: normalize each metric to 0-1 and average. Output: a table with GuestID, EngagementScore, and recommended follow-ups.
13. Profitability by wedding type: You are a business analyst. Task: group portfolio by WeddingType (e.g., ballroom, garden) and calculate average profit per wedding, standard deviation, and count. Context: provide a short interpretation. Output: a summary table with Type, AvgProfit, StdDev, Count, Interpretation.
14. Daily bookings trend: You are a data reporter. Task: from the Bookings sheet, compute daily booking counts for the last 60 days, and identify days with spikes. Context: output date, BookingCount, SpikeFlag, and reason notes. Output: a simple CSV.
15. Seasonal pricing guidance: You are a pricing analyst. Task: analyze price variations by season using the Rates sheet and propose a seasonal price ladder. Context: provide Season, BaseRate, AdjustedRate, Recommendations. Output: a table.
16. Deposit timing planner: You are a cash flow planner. Task: from the Contracts sheet, identify deposit due dates and amounts, and build a cash flow timeline for the next six months. Context: include earliest due date, amount, and cumulative balance. Output: a timeline table.
17. Vendor lead time forecast: You are a procurement planner. Task: forecast vendor lead times from the LeadTimes sheet by category, calculate average lead time, and flag vendors with long delays. Output: a table with Vendor, Category, AvgLeadTime, RiskFlag.
18. Event day run sheet optimizer: You are an operations planner. Task: from the RunSheet sheet, optimize task sequencing to minimize idle time and ensure critical path tasks finish before doors. Output: a revised run sheet with Task, OriginalTime, OptimizedStart, OptimizedEnd, Slack.
19. Post-event profitability report: You are a financial analyst. Task: generate a post-event profitability report from the Events sheet detailing revenue, costs, and net profit per event, with a one-sentence takeaway. Output: a summary table.
20. Client-friendly data export: You are a data export specialist. Task: create a client-ready data export from the Portfolio sheet with sanitized fields, aggregated metrics, and a narrative section. Output: a tab-delimited export with fields: Portfolio, Metric, Value, Narrative.
21. Meal option popularity: You are a dining analytics assistant. Task: analyze meal choices from the RSVPs sheet across events and identify the top 3 meals by popularity, plus a low-uptake option. Output: a table with Meal, Count, Share, Recommendation.
22. Catering cost optimization: You are a cost optimization analyst. Task: from the Catering sheet, compare per-guest costs across menu packages and suggest a cost-saving shift with impact in dollars and percentage. Output: a comparison table and recommendation.
23. Guest RSVP response rate: You are a data quality auditor. Task: calculate RSVP response rate by invitation batch from the Invitations sheet, flag batches with rate below 70%, and propose remediation. Output: a table with Batch, Sent, Responded, Rate, Action.
24. Seating capacity planning: You are an operations analyst. Task: compute optimal seating capacity for each room by event size, ensuring safety margins and accessibility. Output: a table with Room, EventSize, SpacePerGuest, RequiredTables.
25. Payment collection dashboard: You are a data dashboard designer. Task: aggregate payment status from Payments sheet, highlight overdue amounts, and generate a 3-status color code summary. Output: a compact table with Client, TotalDue, DueDate, Status.
26. Gift registry analytics: You are a market researcher. Task: analyze gift registry data from the Gifts sheet, identify top categories, and estimate average gift value per category. Output: a table with Category, Count, AvgValue.
27. Vendor diversity score: You are a compliance analyst. Task: compute a diversity score for vendors based on category coverage, geographic spread, and price competitiveness. Output: a score per vendor and a summary interpretation.
28. Budget burn rate: You are a financial monitor. Task: calculate monthly burn rate from Budget and Actuals sheets, identify months with overspend and thresholds. Output: a table with Month, Budget, Actual, Variance, Alert.
29. Email follow-up microcopy: You are a copywriter. Task: generate five variants of follow-up email microcopy for RSVP pending guests, tailored for different tones. Output: a list of 5 templates with placeholders for GuestName, EventName, and Date.
30. Contract risk flags: You are a legal data assistant. Task: scan Contracts sheet for missing renewal dates, clauses, and extra terms, and output a risk flag per contract. Output: a table with ContractID, MissingFields, RiskFlag.
31. Attendee demographics snapshot: You are a demographic analyst. Task: produce a snapshot of attendee age groups, locations, and gender distribution from Registrations sheet, with top insights. Output: a table and a short interpretation.
32. Theme alignment score: You are a creative analytics assistant. Task: rate how well each wedding theme aligns with preferred color palettes on the Themes sheet. Output: a score per theme and a brief note.
33. Cake contrast analysis: You are a culinary analyst. Task: compare cake sizes, portions, and servings from the Cakes sheet, and recommend the optimal cake size for a guest count range. Output: a table with Size, Servings, EstimatedCost, Recommendation.
34. Florals budget estimator: You are a floral planner. Task: estimate floral budget by event size and venue type using the Florals sheet, and provide a per-guest recommendation. Output: a table with EventSize, VenueType, Budget, PerGuest.
35. Dress code compliance check: You are a compliance assistant. Task: verify dress code notes against event type in the Events sheet and flag mismatches. Output: a table with EventID, DressCode, ComplianceFlag.
36. Travel logistics matrix: You are a logistics planner. Task: from the Travel sheet, create a matrix mapping guest arrival days to airport transfers and hotel blocks, with capacity notes. Output: a matrix table.
37. Wedding timeline gantt: You are a project manager. Task: generate a Gantt-like schedule from the RunSheet and Activities sheets showing task durations, dependencies, and critical path. Output: a table with Task, Start, End, Dependency, Critical.
38. Guest communication plan: You are a communications strategist. Task: craft a phased guest communication plan from Invitations and Communications sheet, with channels and timing. Output: a plan table and a summary paragraph.
39. Budget vs actual by vendor: You are a cost analyst. Task: compare budgeted versus actual spend per vendor from the Vendors sheet and highlight overruns. Output: a table with Vendor, Budget, Actual, Variance, Status.
40. Allergy and dietary alerts: You are a health compliance assistant. Task: extract guests with dietary restrictions from RSVPs and create a binder-ready alert list for catering staff. Output: a table with GuestName, Allergy, Restriction, Table.
41. Timeline risk register: You are a risk manager. Task: build a risk register from RunSheet and Events noting probability, impact, and mitigation for each risk. Output: a table with Risk, Probability, Impact, Mitigation.
42. Guest seat adjacency map: You are a seating planner. Task: produce an adjacency-friendly seating chart by grouping guests who know each other, using the Seating panel. Output: a map table with GuestID, AdjacentIDs, Rationale.
43. Event budget sanity check: You are an auditor. Task: validate that total proposed costs align with the overall portfolio budget, flag any discrepancies, and propose fixes. Output: a discrepancy report.
44. Payment term optimization: You are a financial advisor. Task: optimize payment terms with vendors to align cash flow, using the Contracts and Payments sheets. Output: a plan with Terms, Benefit, Risk.
45. Post-event survey insights: You are a survey analyst. Task: summarize post-event survey responses to identify three improvement opportunities. Output: a table with Insight, Count, Action.
46. Carbon footprint estimate: You are an sustainability analyst. Task: estimate event carbon footprint from Transportation, Vendor, and Venue sheets, and propose 2 reduction actions. Output: a table with Area, Footprint, ReductionActions.
47. VIP guest routing: You are a operations planner. Task: map VIP guest arrival and escort routes from the Travel sheet to streamline check-in. Output: a routing table.
48. Backup plan readiness: You are a risk assessor. Task: review contingency plans in Events and RunSheet, and rate readiness on a 1-5 scale for key failure scenarios. Output: a readiness table.
49. Sponsorship analytics: You are a sponsorship analyst. Task: analyze sponsor packages against delivered benefits and generate a compliance scorecard. Output: a scorecard with Sponsor, Package, Delivered, Gap.
50. Venue capacity optimization: You are a venue analyst. Task: optimize seating and space usage across rooms to maximize capacity while ensuring comfort. Output: a capacity table and layout notes.
51. Insurance and compliance check: You are a compliance officer. Task: validate insurance certificates and compliance paperwork from the Compliance sheet and flag missing items. Output: a compliance table.
52. Guest preference clustering: You are a data scientist. Task: cluster guests by preferences from Registrations sheet and output 4 clusters with centroid profiles. Output: a cluster table.
53. Weather contingency planning: You are a operations planner. Task: assess weather-related risks and build a contingency plan using historical weather data and venue capabilities. Output: a contingency plan and decision tree.
54. Venue amenity scoring: You are a facilities analyst. Task: score venues on amenities and accessibility, then rank venues. Output: a table with Venue, AmenitiesScore, Accessibility, Rank.
55. Language localization prompts: You are a localization specialist. Task: generate prompts to customize guest communications in multiple languages using the Invitations sheet. Output: 5 multilingual message templates.
56. Budget reconciliation draft: You are an accountant. Task: prepare a draft reconciliation between the portfolio budget and each event’s final costs from the Events sheet. Output: a reconciliation table.
57. Guest arrival pacing: You are an operations planner. Task: model guest arrival pacing for venue doors to avoid queues, using historical arrival data. Output: a pacing table with TimeWindow, ExpectedArrivals, Cumulative.
58. Vendor negotiation prompts: You are a procurement consultant. Task: draft negotiation prompts for top 5 vendors to secure better terms, focusing on volume discounts and delivery schedules. Output: five prompts labeled VendorName and NegotiationPoints.
59. Color palette alignment: You are a design analyst. Task: compare color palettes across decor items and venue branding sheets, and propose a cohesive palette with usage guidelines. Output: a palette table and usage notes.
60. Guest regional segmentation: You are a market analyst. Task: segment guests by region from Registrations and Invitations, and provide localized messaging recommendations. Output: a regional table and guidance.
61. Gift value distribution: You are a data analyst. Task: analyze registry gift values to estimate average per guest and total registry value per event. Output: a table with EventID, AvgGift, TotalValue.
62. Revenue sensitivity: You are a financial modeler. Task: perform a sensitivity test on event revenue by changing attendance by plus/minus 10 percent and report impact. Output: a table with Scenario and NetProfitImpact.
63. Invoice aging report: You are an accounting assistant. Task: generate an aging report from the Invoices sheet, flag overdue invoices, and provide collection next steps. Output: a table with InvoiceID, DueDate, Amount, AgeDays, Status.
64. Quote comparison matrix: You are a procurement analyst. Task: compare vendor quotes in the Quotes sheet by item and total, and recommend best value. Output: a matrix table.
65. Attendee affinity heatmap: You are a data analyst. Task: build an affinity heatmap showing how attendee attributes co-occur (e.g., age group with seating preference). Output: a table ready for heatmap.
66. Deposit tracking dashboard: You are a cash flow analyst. Task: build a per-event deposit tracking dashboard from Contracts sheet, showing due dates, amounts, and status. Output: a compact dashboard table.
67. Meal service timing: You are an operations planner. Task: optimize meal service timing to minimize wait times based on DinnerTime and ServiceWindow data. Output: a timing plan with Course, Start, End, Window.
68. Vendor contact summary: You are a relationship manager. Task: compile a vendor contact digest from the Vendors sheet listing key contacts and response times. Output: a digest table.
69. Eco-friendly vendor tips: You are a sustainability advisor. Task: list 6 eco-friendly vendor practices and rate current vendors on sustainability readiness. Output: a table with Vendor, Practice, Readiness.
70. Outfit and dress code notes: You are a UX writer. Task: generate clear dress code notes for guest communications, aligned with event theme. Output: five variant notes.
71. Guest preference forecast: You are a predictive analyst. Task: forecast next event's guest preferences using current event data, and provide confidence levels. Output: a table with Preference, Forecast, Confidence.
72. Emergency contact roster: You are a safety coordinator. Task: compile an emergency contact roster from Staff and Volunteers sheets with roles and phone numbers. Output: a roster table.
73. Checklist harmonization: You are a project coordinator. Task: align all checklists across Invitations, RunSheet, and Vendor Deliverables and flag gaps. Output: a harmonized checklist table.
74. Venue lighting plan: You are a lighting designer. Task: build a lighting plan from the Venue and Themes sheets, including mood, intensity, and control notes. Output: a plan table.
75. Table assignment rationale: You are a seating planner. Task: document rationale for top 10 seating decisions to aid client review. Output: a table with PlanName, Rationale.
76. Revenue by service line: You are a revenue analyst. Task: break down revenue by service line (planning, coordination, design) from Portfolio sheet and report margins. Output: a table with ServiceLine, Revenue, Margin.
77. Guest feedback extraction: You are a data extraction expert. Task: pull key quotes from post-event surveys and categorize by sentiment. Output: a table with Category, Quote, Sentiment.
78. Catering portion guidance: You are a catering consultant. Task: translate guest count to portions for each menu package and provide a headcount margin. Output: a table with Package, Guests, Portions, Margin.
79. Timely reminders automation: You are an automation designer. Task: draft reminder prompts for RSVP deadlines and payment milestones, ready for automation. Output: five prompts with trigger and content.
80. Venue accessibility map: You are a facilities planner. Task: create an accessibility map from venue layout and stage plans, noting entrances and exits. Output: a table with Area, AccessLevel, Notes.
81. Insurance coverage snapshot: You are a risk manager. Task: compile a coverage snapshot from Insurance sheet by event and summarize limits and carriers. Output: a table with Event, Carrier, Coverage, Limit.
82. Waste management plan: You are an sustainability planner. Task: draft a waste management plan with categories, disposal methods, and target reductions. Output: a table with Category, Method, TargetReduction.
83. Client deliverable pack: You are a project pack creator. Task: assemble a client deliverable pack from multiple sheets with executive summary, metrics, and next steps. Output: a pack table.
84. Attendee travel coordination: You are a travel planner. Task: coordinate group transportation by event date, airport, and hotel, with pickup windows. Output: a coordination table.
85. Post-event revenue recap: You are a financial analyst. Task: recap total event revenue after taxes and refunds, with NetRevenue and RevenueMargin. Output: a recap table.
86. Sourcing risk analysis: You are a procurement risk analyst. Task: identify sourcing risks per vendor and propose risk mitigation actions. Output: a risk table.
87. Theme-to-venue alignment: You are a design strategist. Task: assess how well themes align with venue aesthetics and propose adjustments. Output: a recommendation table.
88. Volunteer shift plan: You are an operations coordinator. Task: assign volunteer shifts for event day with roles and coverage, and flag gaps. Output: a schedule table.
89. Guest data privacy checks: You are a compliance auditor. Task: verify that guest data handling complies with privacy policy, flag potential risks. Output: a risk table.
90. Wedding day contingencies: You are a risk planner. Task: compile a contingency list for common disruption scenarios and assign owners. Output: a contingency table.
91. Budget reallocation suggestions: You are a financial planner. Task: suggest 3 reallocation options to free up budget for higher-priority items, with impact notes. Output: a table with Option, Impact, Risk.
92. Vendor onboarding checklist: You are a vendor manager. Task: create a vendor onboarding checklist covering documentation, SLAs, and compliance. Output: a checklist table.
93. Event KPI dashboard: You are a data analyst. Task: define and compute key performance indicators for the wedding portfolio and present as a compact dashboard-ready table. Output: a KPI table.
94. Guest email personalization prompts: You are a copywriter. Task: generate 6 personalized email variations using guest attributes from Registrations. Output: six templates with placeholders.
95. Post-event follow-up plan: You are a client relations specialist. Task: draft a 4-week post-event follow-up plan with touchpoints and goals. Output: a plan table.
96. Seating changeImpact forecast: You are a data analyst. Task: simulate seating changes and forecast impact on guest satisfaction and flow. Output: a table with Scenario, ImpactScore, Rationale.
97. Content repurposing prompts: You are a content strategist. Task: outline 3 repurposing prompts to convert event data into client case studies and social posts. Output: three prompts with sections.
98. Refund and adjustment log: You are a finance clerk. Task: maintain a log of refunds and adjustments from the Events sheet and ensure accuracy. Output: a table with Event, RefundAmount, AdjustmentReason, Date.
99. Client handoff summary: You are a project manager. Task: generate a client handoff summary with key metrics, decisions, and next steps. Output: a summary table.
100. Executive summary prompt: You are a senior analyst. Task: draft an executive summary for the wedding portfolio from all data sources, focusing on insights, risks, and recommended actions. Output: a concise summary table.

Best Practices

• Test prompts on a small data sample before applying to large portfolios.
• Combine prompts that produce tables with those that generate narrative insights for client reports.
• Use consistent column naming across sheets to reduce mapping errors.
• Document parameter values used in prompts for auditing and reuse.
• Regularly review prompts to align with evolving wedding planning processes.

Common Mistakes to Avoid

• Using vague prompts that lack concrete output formats, leading to ambiguous results.
• Overloading prompts with too many variables, causing confusion and errors.
• Neglecting data cleaning steps before analysis, producing unreliable outputs.
• Failing to validate outputs against known benchmarks or sample data.
• Assuming a single prompt works for all event types without customization.

FAQ

What is the best way to start using these Claude prompts for Excel data analysis?

Begin with a core set of prompts that match your most frequent tasks (budget, guest lists, vendor spend), run them on a clean data extract, and then iterate based on the results and client feedback.

Can I run these prompts on multiple wedding events at once?

Yes. Use a separate worksheet or data partition for each event, and adjust prompts to reference the correct event scope by including an EventID or EventName field in your data.

How should I format outputs for client reports?

Ask for outputs in CSV or tab-delimited tables for easy import into reports, and include a brief interpretation note to accompany the table.

What if data is incomplete or missing in my sheets?

Add a data quality check prompt to identify missing fields, then create a task list to fill gaps before running deeper analyses.

Are these prompts safe to use with confidential wedding data?

Yes, but ensure you mask or anonymize sensitive fields when sharing results externally and follow your privacy guidelines.

How can I keep prompts current with evolving wedding planning needs?

Periodically review metrics, add new prompts for emerging tasks, and retire prompts that no longer meet your workflow.