Step-by-Step Basetao Spreadsheet Tutorial for Workflow Mastery
Basetao Editorial Team
Workflow Optimization Experts
This step-by-step basetao spreadsheet tutorial is designed for users who want to go beyond the basics and build a system they can trust with every order. Whether you have never touched a spreadsheet or you are migrating from a simpler setup, this tutorial walks you through every click, formula, and formatting decision.
By the end of this basetao spreadsheet tutorial, you will have a fully functional tracking system with automatic calculations, color-coded status updates, and a structure that scales from five items to five hundred.
What You Will Learn
- How to structure your basetao spreadsheet for maximum clarity
- The exact formulas you need for automatic price calculations
- How to apply conditional formatting so status colors update automatically
- How to link product URLs directly inside cells for one-click access
- Best practices for organizing rows when you have multiple orders active
Setting Up Your First Sheet
Open Google Sheets
Navigate to sheets.google.com and sign in. Click "Blank" to create a new spreadsheet. The interface loads instantly and auto-saves every change.
Name Your File
Click the title "Untitled spreadsheet" at the top-left. Rename it to "Basetao Master Tracker 2026". A clear name makes it easy to find later.
Freeze the Header Row
Click on row number 1. Then go to View > Freeze > 1 row. Now your headers stay visible as you scroll through dozens of items.
Set Column Widths
Columns A, C, D, and I can stay narrow (100-120px). Column B (links) should be wider, around 250px. Double-click the border between column letters to auto-fit.
Core Formulas Every Basetao Spreadsheet Needs
| Formula | Cell | What It Does | Example Result |
|---|---|---|---|
| =E2*F2+G2 | H2 (Total) | Multiplies price by quantity, adds shipping | 250 (200*1+50) |
| =SUM(H2:H50) | Any empty cell | Totals all item costs in column H | 4,850 |
| =COUNTIF(I2:I50,"Shipped") | Any empty cell | Counts how many items are shipped | 12 |
Adding Your First Real Item
Paste the Product URL
Copy the item link from Taobao or Weidian. Click cell B2, paste with Ctrl+V. The link will show as blue clickable text.
Fill All Required Fields
Type the item name in A2, size in C2, color in D2, price in E2, quantity in F2, shipping estimate in G2. The total in H2 should calculate automatically.
Set Status with Dropdown
Select the range I2:I100. Go to Data > Data validation. Choose "List of items" and enter: Bookmarked, Ordered, In Warehouse, Shipped, Delivered, Problem.
Status Tracking with Color Coding
Color coding turns your basetao spreadsheet into a visual dashboard. In Google Sheets, select your Status column. Go to Format > Conditional formatting. Set these rules: "Ordered" = yellow fill, "In Warehouse" = blue fill, "Shipped" = green fill, "Problem" = red fill. Now your entire order pipeline is visible at a glance without reading a single word.
Use the same currency for every price column. Mixing yuan and USD in the same column breaks formulas and creates confusion.
Create a separate tab called "Archive" for completed orders. Cut and paste finished rows there monthly to keep your active sheet clean.
Add a "Member" column if you run group orders. This lets you filter by person when it is time to collect payments.
Set up a daily reminder to check your sheet. Five minutes every morning prevents small problems from becoming expensive disasters.
Master Your Basetao Spreadsheet Workflow
Put this tutorial into practice today. Visit our store to find items worth tracking, then build your first serious basetao spreadsheet.