100 Best Claude Excel Data Analysis Prompts for Grocery Stores

Direct Answer

The best Claude prompts for Excel data analysis for grocery stores are designed to extract actionable insights from store data, covering sales, inventory, promotions, and customer behavior. Use them to drive better stock decisions, pricing, and promotions while maintaining accuracy and simplicity in outputs.

Introduction

This page provides a practical prompt library for analysts and store managers focused on Excel data analysis in the grocery sector. Each prompt is tailored to real-world grocery store tasks, from sales by department to vendor performance.

Use these Claude prompts to accelerate data-driven decisions, standardize analyses across multiple stores, and reduce manual spreadsheet work.

How to Use These Claude Prompts

• Replace placeholders like [store], [region], [period], [category] with your actual values before running the prompt.
• Add constraints such as target margins, lift thresholds, or time windows to focus results.
• Request outputs in clear formats like tables, bullet lists, and concise summaries for downstream reports.
• Verify outputs by cross-checking against source data and performing spot audits on sample results.
• If outputs include charts, specify preferred chart types and labeling requirements.

100 Best Claude Excel Data Analysis Prompts for Grocery Stores

1. Sales by department: You are an analytics consultant in a grocery chain. Your task is to analyze monthly sales by department from the provided Excel data. Context placeholders: [store], [month], [department], [data]. Output format: a structured table with totals, year-over-year comparison, and a 1-sentence takeaway. Constraints: include only departments with at least a five percent YoY growth or decline. Provide a one-paragraph executive summary.
2. Top SKUs by store: Act as a category analyst for a specific store. Given the SKU-level sales data in Excel, identify the top ten SKUs by revenue for [store] in [period]. Output format: ranked list with SKU, revenue, share of category, and trend vs previous period. Include a brief note on potential promotions.
3. Inventory aging report: You are an inventory planner. From stock data in Excel, create an aging report for [store] across [category]. Output: a table with SKU, current stock days, gross margin, turnover rate, and recommended action (reorder, slow-move, discontinue). Include safety stock notes.
4. Promotion effectiveness: Act as a marketing analyst for grocery promotions. Using Excel data for [promo], compare sales lift, margin impact, and ROI across channels. Output: a findings table and a 2-sentence conclusion with actionable recommendations for optimizing future promotions.
5. Margin analysis by product: As a pricing analyst, compute gross margin by product for [store/region] in [period]. Output: a matrix showing cost, selling price, margin percentage, and margin delta vs last period. Highlight products with margins under [threshold] flag and propose price adjustments.
6. Shelf space ROI: Act as a space planning analyst. Given shelf data and sales in Excel, calculate return on shelf space for [category] in [store]. Output: a ranking by product with space allocated, sales per square foot, and recommended reallocations.
7. Sell-through rate by department: You are an efficiency analyst. From inventory and sales data, compute weekly sell-through rate by department for [store]. Output: table with percent sell-through, weeks to clear, and recommended shrink vs replenish actions.
8. Pricing elasticity test: As a data scientist for a grocery retailer, design an elasticity test using historical price and demand in Excel for [product]. Output: outline of groups, control vs test, expected lift ranges, and KPIs to monitor.
9. Forecast by week: Act as a demand forecaster. Build a 12-week forecast in Excel for [category] in [store/region], using historical weekly data [data]. Output: weekly forecast, confidence bands, and top drivers of demand.
10. Customer churn proxy: You are a customer analytics specialist. Using basket data in Excel, identify potential churn risk indicators for [segment] in [store/region]. Output: list of customers or baskets with risk scores and recommended retention actions.
11. Promo lift delta: Role: promotions analyst. Compare sales during [promo period] to baseline for [store/region]. Output: lift delta by product, category, and store cluster, plus recommended adjustment for future promos.
12. Cookbook SKU recommendations: You are a category manager. Generate a set of 12 cookbook-friendly SKUs to promote in [season] for [store], based on current sales, margin, and cross-sell potential. Output: SKU list with rationale and expected impact.
13. Daypart sales mix: Act as an operations analyst. Analyze sales by daypart in Excel for [store] to identify peak hours. Output: table by hour for [weekdays/weekends], with mix percentages and staffing suggestions.
14. Vendor performance scorecard: As a procurement analyst, create a vendor scorecard from Excel data for [vendor] across [metrics]. Output: table with on-time delivery, quality, cost variance, and overall score plus improvement actions.
15. Waste and shrink: You are a loss-prevention analyst. From inventory and shrink data in Excel, identify products with the highest wastage and propose mitigation for [store]. Output: list of SKUs, waste %, and recommended controls.
16. Category profitability map: Role: business analyst. Build a profitability map by category across [store group]. Output: map-like table showing revenue, cost, margin, and ROI by category with top and bottom performers.
17. Forecast accuracy review: You are a QA analyst. Compare forecast vs actual for [period] by store. Output: accuracy metrics (MAPE, RMSE), bias, and action plan to improve forecasting processes.
18. Promotions calendar: Act as a promo planner. Create a calendar of planned promotions for [quarter] by store cluster in Excel, including dates, expected lift, required shelf space, and budget.
19. Basket-level profitability: Role: finance analyst. Using basket-level data in Excel, compute average profit per basket for [store/region]. Output: profit per basket, contribution margin, and drivers of high-profit baskets.
20. Leakage analysis: You are a leakage analyst. From shopper data in Excel, quantify leakage by channel for [store region]. Output: leakage amount, key product gaps, and recommended in-store actions.
21. Store clustering by performance: As a data scientist, cluster stores in [region] by performance metrics in Excel. Output: cluster labels, representative stores, and recommended best practices for each cluster.
22. Inventory turnover heatmap: Act as an inventory planner. Create a turnover heatmap in Excel for [store] by product family. Output: heatmap with turnover rate and color coding, plus top slow movers.
23. Discount strategy impact: You are a pricing analyst. Evaluate discount depth and breadth for [store] in [period]. Output: table with discount level, lift, margin impact, and recommended discount ranges.
24. Procurement price variance: Role: procurement auditor. From purchase data in Excel, calculate price variance by supplier for [timeframe]. Output: variance by SKU, supplier, and recommended negotiation points.
25. Seasonal demand patterns: Act as a demand planner. Analyze seasonal patterns for [category] in [region]. Output: seasonal index, peak week, and recommended stock levels by week.
26. New product viability: You are a product analyst. Assess potential new SKU [SKU] for [store] using historical sales, margin, and cannibalization risk. Output: go/no-go decision with rationale.
27. Customer basket diversity: As a customer insights analyst, measure average items per basket and diversity index for [store/region]. Output: metrics, trend, and improvement ideas.
28. Pricing by channel: Role: pricing strategist. Compare price levels and elasticity by channel for [product] across [store types]. Output: channel-wise price recommendations and expected effect.
29. Stockout risk heatmap: You are an operations analyst. From inventory data, identify stockout risk across [store] by product and week. Output: risk score, affected items, and mitigations.
30. Loyalty impact analysis: Act as a CRM analyst. Assess loyalty program impact on [store] sales using Excel data. Output: percent lift, average order value change, and recommended program tweaks.
31. Cross-sell opportunities: You are a category planner. From basket data, identify cross-sell opportunities between [A] and [B]. Output: list of pairs with uplift and suggested promotions.
32. Cost-to-serve model: Role: cost analyst. Build a cost-to-serve model in Excel for [store] by channel. Output: per-customer cost, margin impact, and optimization suggestions.
33. Operational efficiency benchmark: Act as an analytics auditor. Benchmark store ops metrics in Excel for [region]. Output: KPI gaps, best practices, and a 90-day improvement plan.
34. SKU rationalization: You are a category manager. Propose SKU cuts/replacements for [category] in [store] based on sales velocity, margin, and cannibalization risk. Output: list with rationale.
35. Promotional timing optimization: Role: promotions planner. Suggest optimal timing for promotions in [store/region] based on historical lift and planogram constraints. Output: calendar and rationale.
36. Customer segment profiling: Act as a segmentation analyst. Profile [customer segment] in [store/region] using purchase history. Output: segment traits, preferred products, and messaging ideas.
37. End-of-life stock plan: You are an inventory strategist. For [store], create a plan to liquidate end-of-life stock in [category] with pricing, placement, and timelines. Output: actions and expected results.
38. Weekend vs weekday demand: You are a demand analyst. Compare weekend vs weekday demand for [store] in [region]. Output: daily sales split, drivers, and staffing recommendations.
39. High-margin product focus: Role: category strategist. Identify top three high-margin products in [category] for [store]. Output: list with margins, share, and recommended promotions.
40. Stock level dashboards: Act as a dashboard designer. Build a scorecard in Excel for [store] showing stock levels, turns, and availability by department. Output: table and one-sentence insights.
41. Seasonality cash flow: You are a finance analyst. Analyze seasonality effects on cash flow for [store] using sales and cost data in Excel. Output: seasonal cash flow chart and mitigation steps.
42. Cashier shift optimization: Role: operations analyst. Using sales and labor data, propose cashier shift schedules for [store] to maximize throughput with constraints [constraints]. Output: schedule and rationale.
43. Supplier lead time risk: Act as a procurement risk analyst. Evaluate supplier lead times for [category] in [region]. Output: risk matrix, contingency options, and order-point adjustments.
44. Waste reduction plan: You are an operations optimizer. From waste data, produce a 90-day waste reduction plan for [store]. Output: actions, owners, and KPIs.
45. Retour analysis: Role: reverse logistics analyst. Analyze return reasons and rates for [store] in [period]. Output: root causes, affected SKUs, and mitigation steps.
46. Ad hoc profitability query: You are a finance analyst. Generate a profitability answer for an ad hoc question: what is the contribution margin impact of reducing prices on [SKU] in [store]? Output: calculation steps and final result.
47. Inventory safety stock: Act as an inventory planner. Determine safety stock for [SKU] in [store] using demand variability and service level [SL]. Output: stock level and justification.
48. Churn reduction roadmap: You are a customer retention strategist. Develop a 90-day churn reduction plan for [store] based on purchasing behavior. Output: initiatives with owners and metrics.
49. Markdown optimization: Role: markdown planner. Propose a markdown plan for [category] in [store], including timing, depth, and expected margin impact. Output: schedule and rationale.
50. New store kickoff metrics: Act as a launch data analyst. For a new store in [region], define key launch metrics in Excel and how to track them. Output: metrics list and data sources.
51. Baskets by channel: You are a channel analytics specialist. Compare average basket size by channel for [store/region]. Output: table by channel with drivers and recommendations.
52. Shelf availability report: Role: shelf analytics. From shelf and stock data, produce an availability report by product in [store]. Output: items out of stock and recommended replenishment actions.
53. Coupon rotation strategy: Act as a promotions analyst. Design a coupon rotation plan for [store/region], balancing lift and margins. Output: coupon schedule and expected impact.
54. Forecast bias reduction: You are a forecast process engineer. Identify causes of forecast bias in [region]. Output: root causes, monitoring plan, and corrective actions.
55. Loyalty tier analysis: Role: CRM analyst. Analyze loyalty tiers performance for [store] using purchase history data. Output: tier profitability, upgrade/downgrade recommendations.
56. Vendor consolidation plan: Act as a procurement strategist. Propose a vendor consolidation plan for [category] across [region]. Output: list of preferred vendors, savings estimate, and rollout steps.
57. Stop-gap demand surge plan: You are a contingency planner. Outline a stop-gap plan to meet sudden demand surge in [store] for [season]. Output: actions, responsible parties, and timing.
58. Promotional reach analysis: Role: media planner. Estimate in-store and external reach for [promo] in [store/region]. Output: audience reach, frequency, and expected lifts.
59. Product cannibalization map: Act as a category analyst. Analyze cannibalization between new and existing SKUs in [store]. Output: table of cannibalization impact and recommendations.
60. Food waste heatmap: You are an sustainability analyst. Create a heatmap of food waste by department in [store]. Output: waste amount, rate, and mitigation ideas.
61. Pricing guardrails: Role: pricing strategist. Define guardrails for price changes on [category] in [store] to avoid over-discounting. Output: thresholds and review triggers.
62. Checkout bottleneck analysis: Act as an operations engineer. Identify checkout bottlenecks in [store] using point-of-sale data. Output: bottleneck items, impact, and proposed fixes.
63. Seasonal staffing plan: You are a workforce planner. Create seasonal staffing for [store] by week for [season]. Output: headcount, shifts, and coverage notes.
64. SKU-level cash flow: Role: finance analyst. Compute cash flow impact by SKU for [store] using revenue and cost data. Output: cash flow by SKU and recommended portfolio adjustments.
65. Shelf temperature compliance: Act as a compliance auditor. Check shelf temperature compliance for refrigerated items in [store]. Output: non-compliant SKUs and remediation steps.
66. Seasonal promos ROI: You are a promotions analyst. Compare ROI of seasonal promos across stores in [region]. Output: ROI by store with top and bottom performers.
67. Product return reasons: Role: customer service analytics. Analyze return reasons by product in [store]. Output: top reasons and product-level remediation plan.
68. Inventory by supplier: Act as a procurement analyst. Create an inventory report by supplier for [category] in [store]. Output: stock levels, turnover, and supplier risk notes.
69. Pricing wrap-up summary: You are a price optimization analyst. Summarize last quarter pricing actions and their effects for [store]. Output: succinct recap and recommended adjustments.
70. Cross-category promos: Role: promotions planner. Design cross-category promotions for [store] involving [category A] and [category B]. Output: plan, expected lift, and budget.
71. Coupon redemption funnel: Act as a CRM analyst. Map coupon redemption funnel in Excel for [store], showing steps from exposure to purchase. Output: funnel metrics and optimization ideas.
72. Promo leakage fix: You are an optimization advisor. Identify leakage points in promotions for [store] and propose fixes. Output: leakage list and impact estimates.
73. Open-to-buy plan: Role: inventory controller. Create an open-to-buy plan for [store] for [season], including budgets and priorities. Output: plan summary.
74. Low-margin product review: Act as a margin analyst. Review low-margin SKUs in [store]. Output: list of SKUs, margin issues, and recommended actions.
75. Order frequency optimization: You are a supply chain planner. Optimize order frequency for [supplier] in [region]. Output: frequency changes, inventory impact, and cost savings.
76. Basket-level segmentation: Role: customer analytics. Segment baskets in [store] into high-value, mid-value, and low-value groups. Output: segment profiles and targeted actions.
77. Product life cycle planning: Act as a lifecycle analyst. Place [SKU] on lifecycle plan in [store], with launch, growth, maturity, and withdrawal signals. Output: timeline and actions.
78. Sales volatility guard: You are a risk analyst. Identify items with high sales volatility in [store]. Output: list, causes, and mitigation actions.
79. Store-level KPI dashboard: Role: dashboard designer. Build a KPI dashboard in Excel for [store] showing revenue, margin, and stock health. Output: dashboard layout and data sources.
80. Demand-supply reconciliation: Act as a supply planner. Reconcile demand forecast with supply plan for [store]. Output: reconciliation table and action steps.
81. Cash flow by item: You are a finance analyst. Compute cash flow impact by item for [store] using price and cost data. Output: cash flow per item and recommendations.
82. Shrink detection rules: Role: loss prevention analyst. Define rules to detect shrink patterns in Excel for [store]. Output: alert criteria and follow-up actions.
83. Inventory localization: Act as a data strategist. Localize protein-free or gluten-free items in [store] based on demand. Output: item list and placement recommendations.
84. Seasonal markdown calendar: You are a planner. Create a seasonal markdown calendar for [store] with dates, depth, and forecast impact. Output: calendar and rationale.
85. Traffic-to-sales mapping: Role: traffic analyst. Map store foot traffic to sales in [store] to identify conversion opportunities. Output: conversion rate by time and recommended actions.
86. Forecast scenario planning: Act as a scenario planner. Produce optimistic, base, and pessimistic sales scenarios for [store] in [region]. Output: scenario table and triggers.
87. Product mix optimization: You are a category optimizer. Propose a product mix adjustment for [store] to balance high-margin and fast-turning items. Output: recommended mix and expected impact.
88. Store aging analysis: Role: data scientist. Analyze performance aging of products across [store group]. Output: aging curve, hotspots, and focus items.
89. Non-sale demand lift: Act as a demand planner. Estimate lift from non-sale marketing actions for [store]. Output: lift estimates and recommended actions.
90. Supplier performance alert: You are a procurement monitor. Create alerts for underperforming suppliers in [category] for [region]. Output: alert triggers and response plan.
91. Pricing parity check: Role: pricing auditor. Check price parity across channels for [product] in [region]. Output: parity gaps and fix plan.
92. Product substitution map: Act as a category planner. Map fastest substitute options when a SKU is unavailable in [store]. Output: substitute list and impact estimates.
93. Promo compliance audit: You are a promotions auditor. Verify execution of [promo] in [store] against plan and detect deviations. Output: findings and remediation steps.
94. Seasonal inventory build: Role: inventory strategist. Build seasonal inventory by week for [store] with risk flags and budget. Output: plan and justification.
95. Customer lifetime value: Act as a CRM analyst. Estimate LTV for customers in [store/region] using purchase history. Output: LTV by segment and retention recommendations.
96. Digital vs in-store mix: You are a channel analyst. Compare online vs in-store sales mix for [store] in [region]. Output: share, lift opportunities, and action steps.
97. Cost savings opportunities: Role: cost optimization analyst. Identify cost-saving opportunities in [store] by category. Output: list with potential savings and implementation steps.
98. Storage constraints plan: Act as a logistics planner. Plan storage allocation for seasonal goods in [store] with space limits. Output: plan and justification.
99. Product return prevention: You are a product quality analyst. Propose actions to reduce returns for [store] on [category]. Output: root causes, changes, and expected impact.
100. Executive summary q&a: Role: business analyst. Prepare an executive summary prompt for quarterly results in Excel for [store], including key metrics, risks, and opportunities. Output: concise bullet list and recommended actions.

Best Practices

• Keep prompts specific to your data schema and naming conventions to avoid misinterpretation.
• Reuse prompts by storing common parameters outside the core prompt and re-invoking with new data slices.
• Validate Claude-derived results with small manual checks on random samples.
• Document assumptions and thresholds used in each prompt to maintain consistency across analyses.

Common Mistakes to Avoid

• Using vague goals like analyze sales without specifying period or store scope.
• Forgetting to replace all placeholders, leading to incorrect or generic outputs.
• Overloading prompts with too many constraints, causing no viable results.
• Ignoring data quality issues, which produces misleading conclusions.
• Relying on a single prompt for all analyses instead of combining multiple focused prompts.

FAQ

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

Begin with a clear objective, replace placeholders with your data, and request outputs in a structured format like tables or bullet lists to fit your reporting workflow.

How should I format outputs for executive reports?

Ask for tables with key metrics, one-sentence takeaways, and a short limitations note to ensure the outputs are presentation-ready.

Can Claude prompts handle large store networks?

Yes, use prompts that specify store clusters or regions and aggregate results at the desired level to manage complexity.

What metrics should I track for promotions?

Lift by product, margin impact, ROI, and recommended next steps based on the data.

How can I ensure accuracy in outputs?

Cross-check results with a sampling of the source data and specify validation steps in the prompt.

Where can I learn more about these prompts?

Review related prompts in this library and explore additional resources on the site for prompt best practices.