Learning how to use basetao spreadsheet step-by-step is the single biggest upgrade you can make to your shopping workflow. This tutorial assumes zero spreadsheet experience and walks you from blank page to fully automated tracker in under twenty minutes.
Step 1: Choose Your Platform
Google Sheets is recommended for beginners because it is free, cloud-based, and has a mobile app. Open sheets.google.com, sign in with your Google account, and click Blank to start a new spreadsheet. If you prefer desktop software, Microsoft Excel works identically.
Step 2: Build Your Column Headers
In row one, type these exact headers across the top cells: Item Name, Product Link, Size, Color, Seller Price, Agent Fee, Shipping Estimate, Total Cost, Order Status, Warehouse Date, Arrival Date, Notes. These twelve columns cover every detail you will ever need.
Step 3: Add Your First Product Row
Paste a product link into the Product Link column. In Item Name, write a short description like White Nike Dunk Low. Fill in Size and Color. Enter the seller price in the Seller Price column. Now you have a complete record that you will never lose.
Step 4: Create Auto-Calculating Totals
Click the first cell under Total Cost. Type = then click the Seller Price cell, type +, click Agent Fee, type +, click Shipping Estimate, and press Enter. Now drag the small square at the bottom-right corner of that cell down to copy the formula to every row below.
Step 5: Color-Code Your Status
Select the entire Order Status column. Click Format, then Conditional Formatting. Create three rules: text contains Ordered turns yellow, text contains Shipped turns orange, text contains Arrived turns green. Now your sheet becomes a visual dashboard.
| Step | Action | Time Required | Difficulty |
|---|---|---|---|
| 1 | Choose Google Sheets or Excel | 2 minutes | Easy |
| 2 | Add 12 column headers | 3 minutes | Easy |
| 3 | Paste first product link | 2 minutes | Easy |
| 4 | Build total cost formula | 5 minutes | Medium |
| 5 | Apply conditional formatting | 5 minutes | Medium |
| 6 | Add ten products | 10 minutes | Easy |
Advanced Workflow Tips
- Create a separate tab for each shopping haul so your history stays organized.
- Use the Notes column to store seller WeChat IDs or special instructions.
- Set a data validation dropdown for Order Status to prevent typos.
- Link directly to basetao product pages in the Product Link column for one-click access.
Want more basetao spreadsheet guides? Check out these related articles:
Conclusion
Now you know how to use basetao spreadsheet step-by-step. The hardest part is starting. Open a blank sheet, add your first product, and let the system carry you forward. Within one week, organized shopping will feel completely natural.
Get Spreadsheet Tools