Walk through every step of creating your first basetao spreadsheet. From opening Google Sheets to tracking your tenth order, this tutorial covers it all with screenshots in mind.
This basetao spreadsheet tutorial assumes you have never created a tracking document before. By the end, you will have a fully functional order tracking system and a clear understanding of how to maintain it going forward.
Step 1: Choose Your Platform
Open Google Sheets in your browser. Sign in with any Google account. Click the plus icon to create a blank spreadsheet. Rename it to "Basetao Orders" or anything memorable. This is your foundation. Everything else builds on this single file.
Microsoft Excel Online works similarly if you prefer the Microsoft ecosystem. The steps are nearly identical. Apple Numbers users can follow along too, though some advanced features differ slightly.
Step 2: Create Your Column Headers
In row one, type these headers into cells A1 through I1: Item Name, Product Link, Order Date, Price, Agent Order Number, Shipping Method, Tracking Number, Status, Notes. Use bold formatting by selecting the entire row and pressing Ctrl+B or Cmd+B.
Freeze row one so it stays visible as you scroll. In Google Sheets, click View, then Freeze, then 1 row. This simple step prevents confusion once your sheet grows beyond the visible screen.
Step 3: Format for Readability
Select the entire sheet and set the font size to 11. Choose a clean font like Arial or Inter. Set column A to 200 pixels wide, column B to 300 pixels, and distribute the remaining width evenly. These widths accommodate most product names and links without truncation.
Apply alternating colors to rows starting from row two. In Google Sheets, select rows two through twenty, click the paint bucket, and choose a light cream fill. Repeat with white for rows twenty-one through forty. This zebra pattern makes scanning much faster.
Step 4: Add Your First Order
Find an item you have already ordered or plan to order. In cell A2, type a short descriptive name like "Nike Dunk Black White 42". In B2, paste the original product link. In C2, enter today's date. In D2, type the total price including agent fees. Leave E2 and F2 empty until the agent confirms. In H2, type "Pending".
Repeat this process for two or three more orders. Do not worry about perfection. The goal right now is getting comfortable with the rhythm of data entry.
Step 5: Build a Simple Status System
Your status column drives the usefulness of the entire spreadsheet. Create a consistent vocabulary and stick to it. We recommend: Pending, Confirmed, Shipped, In Transit, Delivered, Issue, Cancelled. Anything beyond these seven creates ambiguity.
Use color coding sparingly. Green for Delivered, yellow for In Transit, red for Issue, and gray for Cancelled. Avoid coloring every cell. Color should highlight exceptions, not decorate everything.
Step 6: Add a Summary Row
Below your data, leave one blank row, then create a summary section. In a cell to the left of your price column, type "Total Spent". In the price column, enter a SUM formula that adds all your order prices. This gives instant visibility into your spending without scrolling through individual rows.
As your sheet grows, move the summary to a separate tab called "Dashboard". This keeps your main tracking sheet clean while providing a quick overview page.
Step 7: Set a Maintenance Schedule
A basetao spreadsheet only works if you update it. Set a recurring reminder on your phone for the same day each week. Spend five minutes marking delivered items, adding tracking numbers for newly shipped orders, and noting any issues. Five minutes weekly is infinitely better than an hour-long catch-up session once a month.
Step 8: Back Up Your Work
Click File, then Download, then Microsoft Excel. Save this file to your computer. Repeat weekly. Cloud services are reliable but not infallible. A local backup costs nothing and prevents disaster.
By following these eight steps, you have built a complete basetao spreadsheet that will serve you through hundreds of orders. The system works because it is simple. Resist the urge to overcomplicate it.
Frequently Asked Questions
How long does it take to set up a first basetao spreadsheet?
The initial setup takes fifteen to twenty minutes. After that, each order entry takes thirty seconds. The time investment pays for itself after your third or fourth order.
Can I use this tutorial with mobile devices?
Yes, though we recommend the initial setup on a desktop or laptop. Once configured, updating the spreadsheet from your phone works perfectly through the Google Sheets app.
What if I mess up a formula?
Google Sheets has an undo button and version history. Click File then Version History to restore any previous state. You cannot permanently break anything.