Ecommerce Sales Dataset preview Free

Ecommerce Sales Dataset

Sales Intermediate CSVXLSXSQL
CategorySales
DifficultyIntermediate
Rows51K (51,290)
Columns12
File Size6.4 MB
FormatsCSV, XLSX, SQL
LicenseFree for commercial & personal use
Downloads18,420+
Last Updated2 Jul 2026
CreatorDataVix

About this dataset

This Ecommerce Sales Dataset contains a complete online-store data model: orders, customers, products, payments, shipping information and returns, linked by clean foreign keys. It’s the ideal all-rounder for building end-to-end analytics — perfect for Power BI dashboards, SQL practice, Excel analysis and Python projects. Use it to calculate revenue and profit KPIs, analyse customer behaviour, measure return rates and build a sales dashboard from raw transactions.

#ecommerce#orders#revenue#retail#kpi

Dataset Contents

The tables included in this dataset and what each one holds.

TableDescriptionRows
Orders One row per order with order date, status, channel and order value. 51K
Customers Customer profiles with segment, city, signup date and lifetime value. 9.2K
Products Product catalog with category, sub-category, cost and list price. 1.9K
Payments Payment records with method, amount, and payment status per order. 51K
Shipping Shipping mode, cost, dispatch and delivery dates per order. 51K
Returns Returned orders with reason code and refund amount. 3.9K

Columns Included

Key columns with their datatypes and meaning.

ColumnDatatypeDescription
order_id VARCHAR Unique order identifier (primary key).
order_date DATE Date the order was placed.
customer_id VARCHAR Foreign key to the Customers table.
product_id VARCHAR Foreign key to the Products table.
quantity INT Number of units ordered.
unit_price DECIMAL Selling price per unit.
discount DECIMAL Discount applied to the line (0–1).
sales DECIMAL Net line revenue after discount.
profit DECIMAL Profit for the line after cost.
payment_method VARCHAR UPI, Card, Netbanking, COD, Wallet.
ship_mode VARCHAR Standard, Express or Same-Day shipping.
order_status VARCHAR Delivered, Shipped, Cancelled or Returned.

Skills You Can Practice

Power BI Dashboard
SQL Queries
Excel Analysis
Python Pandas
Data Cleaning
KPIs
Sales Analysis
Customer Segmentation
Profit Analysis
Forecasting

Recommended Projects

01 Create a Sales Dashboard
02 Top Customers Analysis
03 Monthly Revenue Report
04 Profit Analysis
05 ABC Analysis
06 Customer Retention
07 Inventory Dashboard

Preview

Click any image to enlarge.

Related Datasets

Coffee Shop Sales Dataset
BeginnerSales

Coffee Shop Sales Dataset

Transaction-level cafe sales by product, store, hour and day — great for a first Excel/Power BI project.

 Superstore Retail Dataset
BeginnerRetail

Superstore Retail Dataset

The iconic Superstore orders with region, segment, category, sales and profit — perfect for a first dashboard.

 Netflix Movies & TV Shows
BeginnerMarketing

Netflix Movies & TV Shows

Full Netflix catalog: titles, genres, cast, countries, ratings and release years for content analytics.

Frequently Asked Questions

Is this dataset free to download?
Yes. Every dataset on DataVix is 100% free to download — no signup, no paywall, no hidden cost. Just click “Download Dataset”.
How do I download the files?
Click the green “Download Dataset” button. Your download starts instantly as a single package containing all included file formats (CSV, XLSX, SQL).
Can I use this dataset for commercial projects?
Free for commercial & personal use. You’re free to use it in your portfolio, client work, YouTube tutorials, blog posts and courses — attribution to DataVix is appreciated but not required.
Which tools does this dataset work with?
It’s ready for Power BI, SQL, Excel, Python. The CSV/XLSX files import directly into Excel, Power BI, Python (pandas) and any SQL database.
Is this real or synthetic data?
It’s realistic, analysis-ready practice data modelled on real-world business scenarios and cleaned for learning — safe to share publicly with no personal or confidential information.