Grab your free Sample Sales Data Excel download pack and sharpen your analysis skills with five fully-synthetic Sales & Retail workbooks. Each file mirrors real-world scenarios: regional roll-ups, e-commerce orders, POS receipts, customer histories and inventory levels – yet is 100 % dummy (CC0). Practice PivotTables, Dashboards, Power Query, time-series charts and inventory logic – no sign-ups, no privacy risk.

1. Product Sales by Region Dataset

Perfect for executive-level dashboards, this 1 500-row file aggregates sales across five regions and multiple store locations. Analyze how discounts, promotions and payment methods influence revenue, then map results geographically or slice by salesperson. It’s an ideal sandbox for practicing multi-dimensional PivotTables and summary charts in a single afternoon.

Sales Data Product Sales by Region Dataset

Columns Included:
Date, Region, Product, Quantity, UnitPrice, StoreLocation, CustomerType, Discount, Salesperson, TotalPrice, PaymentMethod, Promotion, Returned, OrderID, CustomerName, ShippingCost, OrderDate, DeliveryDate, RegionManager

  • Create PivotTables and PivotCharts for regional performance.
  • Build dashboards with slicers for discount or promotion filters.
  • Plot filled-map charts of revenue by region.
  • Compare salesperson performance week over week.

Download Product Sales Data (.xlsx)

2. Online Store Orders Dataset

This e-commerce table follows every step of an online purchase, from cart creation to delivery tracking. With coupon codes, referral sources and order statuses included, you can quantify promotion lift, evaluate fulfilment speed or join the data to web-traffic logs. Its 1 200 records are compact enough for Excel, yet varied enough for meaningful insight.

Sales Data Online Store Orders Dataset

Columns Included:
OrderID, Date, CustomerID, Product, Quantity, UnitPrice, ShippingAddress, PaymentMethod, OrderStatus, TrackingNumber, ItemsInCart, CouponCode, ReferralSource, TotalPrice

  • Measure promotion effectiveness via CouponCode.
  • Track fulfilment stages with OrderStatus.
  • Use text functions to parse IDs and addresses.
  • Join with customer lists using XLOOKUP.

Download Online Orders Data (.xlsx)

3. Retail Store Transactions Dataset

Dive deep into brick-and-mortar sales with 2 000 POS transactions timestamped down to the minute. The sheet is designed for time-of-day, payment-type and cashier performance analysis. Discover peak shopping hours, assess manager efficiency or highlight best-selling products—perfect practice for anyone learning conditional formatting or CONCAT-based unique IDs.

Sample Sales Data Retail Store Transactions Dataset

Columns Included:
Date, Time, StoreID, Location, Product, Quantity, UnitPrice, PaymentType, TransactionID, Cashier, StoreManager, TimeOfDay, DayOfWeek, TotalPrice

  • Analyse hourly or daily sales trends.
  • Identify top cashiers or store managers by revenue.
  • Segment transactions by PaymentType.
  • Create CONCAT-based ledger keys for audit trails.

Download Retail Transactions Data (.xlsx)

4. Customer Purchase History Dataset

Understand your shoppers, not just your sales. This 1 800-row dataset captures multi-product purchase behavior, payment preferences and review ratings—ideal for cohort analysis and Customer Lifetime Value calculations. Use it to reveal cross-sell opportunities, build “top customers” reports or explore rating-based product popularity.

Sample Sales Data Customer Purchase History Dataset

Columns Included:
CustomerID, Product, PurchaseDate, Quantity, UnitPrice, CustomerName, ProductCategory, PaymentMethod, ReviewRating, TotalPrice

  • Calculate Customer Lifetime Value (CLV).
  • Rank top customers by spend or rating.
  • Analyse product popularity within categories.
  • Use PivotTables to find frequently bundled items.

Download Customer History Data (.xlsx)

5. Inventory Tracking Dataset

Effective stock management is critical in retail—this 500-row file tracks quantity on hand, reorder points, supplier contacts and unit costs. Practise conditional formatting to flag low stock, compute total inventory value or build supplier scorecards. Combine it with Sales data to estimate safety stock and avoid costly stock-outs.

Sample Sales Data Inventory Tracking Dataset Dataset

Columns Included:
ProductID, ProductName, QuantityInStock, ReorderPoint, Supplier, SupplierContact, LeadTime, StorageLocation, UnitCost

  • Highlight items below the ReorderPoint.
  • Create logical IF statements for stock status.
  • Calculate total inventory value by location.
  • Build supplier lookup tables with VLOOKUP.

Download Inventory Tracking Data (.xlsx)

Conclusion: Sample Sales Data & Next Steps

These five Sample Sales Data Excel Downloads let you experiment with every stage of the commerce pipeline—from regional revenue roll-ups to stock-reorder alerts—without risking customer privacy. Download, explore, and build your own dashboards or tutorials. When you’re ready for fresh challenges, head back to the Main Sample Data Library to grab datasets from Finance, HR, Manufacturing and more.