This basetao spreadsheet tutorial walks you through every click, column, and formula you need to build a working order tracker in under 20 minutes. Whether you use Google Sheets or Excel, the steps are identical. By the end, you will have a fully functional sheet that calculates costs, converts currencies, and tracks every order from wishlist to doorstep.
Part 1: Setting Up Your First Tab
Open a blank spreadsheet. Rename the first tab to Active Orders. In row 1, type these exact headers across columns A through K: Order Date, Product URL, Item Name, Category, Size, Color, Seller Name, Original Price, Converted Price, Shipping Estimate, and Order Status. Freeze the first row so your headers stay visible as you scroll. Select row 1, click Format > Freeze > 1 row in Google Sheets. This simple setup is the foundation every basetao spreadsheet is built on.
Part 2: Adding Dropdowns and Auto-Conversions
Select the entire Order Status column. Click Data > Data Validation, choose List of Items, and type these exact values separated by commas: Wishlist, Ordered, Shipped, In Transit, Customs, Delivered, Cancelled. Now every status is selectable, not typed. For currency conversion, add a new sheet named Rates. In cell A1 type USD, B1 type 1. In A2 type CNY, B2 type 0.14. In your main sheet, set the Converted Price formula to multiply Original Price by the matching rate using VLOOKUP. Copy the formula down the column and your prices update instantly when rates change.
Part 3: Conditional Formatting That Saves Money
Select the entire Converted Price column. Go to Format > Conditional Formatting. Add a rule that says Format Cells If Greater Than, set the value to your monthly budget divided by your typical order count, and apply a red background. Now any item that pushes your average too high flashes red immediately. Add a second rule for Order Status: when the cell equals Delivered, turn the entire row light green. Visual feedback means you never scan more than you have to.
Part 4: Advanced Sorting and Filtering
Turn your data range into a proper table using Data > Create a Filter. Now every column header has a dropdown arrow. Sort by Seller Name to group orders and negotiate bulk shipping. Filter by Category to see exactly how much you have spent on sneakers versus hoodies this month. Sort by Converted Price descending to identify your biggest purchases. These four sorting views answer 90 percent of the questions you will ever have about your spending.
Continue Your Journey
Explore more basetao spreadsheet resources and start tracking your orders smarter.
Download Free Template