Free Yoybuy Spreadsheet Download + Setup Guide (2026)

You do not need to build a yoybuy spreadsheet from scratch. This article provides a complete, ready-to-use template that you can copy in under 60 seconds. It includes pre-built formulas, color-coded formatting, dropdown menus, and a summary dashboard. Follow the setup guide below to customize it for your shopping habits and start tracking orders immediately.

What Is Included in the Free Template?

The template contains three pre-built sheets designed for immediate use:

• Sheet 1 — Orders: The main tracking sheet with 15 columns, auto-numbering, live currency conversion, and conditional formatting.
• Sheet 2 — Dashboard: A one-glance summary showing total orders, total spent, items pending, and monthly spending.
• Sheet 3 — Wishlist: A separate space for items you are considering but have not yet purchased.

Orders Sheet: Column Breakdown

Each column is pre-configured with the optimal format and, where applicable, formulas:

1. A — Item ID: Auto-numbered. Row 2 is 1. Row 3 uses =A2+1. Drag down forever.
2. B — Product Name: Plain text. Enter the item name.
3. C — Product URL: Hyperlink-friendly. Paste the full yoybuy product link.
4. D — Category: Dropdown with options: Shoes, Hoodies/Sweaters, T-Shirts, Jackets, Pants/Shorts, Headwear, Sets, Underwear, Jersey, Accessories. Change these to match your preferences.
5. E — Size / Color: Plain text for variant details.
6. F — Original Price (CNY): Number format. Enter the price in the seller's currency.
7. G — Exchange Rate: Uses =GOOGLEFINANCE("CURRENCY:CNYUSD") for live conversion. Update the currency pair for your local currency.
8. H — Converted Price: Formula: =F2*G2. Auto-calculates.
9. I — Shipping Estimate: Number format. Your best guess at shipping cost.
10. J — Agent Fee: Number format. Service charges.
11. K — Total Cost: Formula: =H2+I2+J2. The true price you will pay.
12. L — Order Status: Dropdown: Wishlist, Ordered, Processing, Warehouse, Shipped, In Transit, Out for Delivery, Received, Issue, Returned.
13. M — Tracking Number: Plain text. Paste the carrier tracking code.
14. N — Order Date: Date format. When you placed the order.
15. O — Notes: Free text for anything else.

Dashboard Sheet: Auto Summary

The Dashboard pulls live totals from the Orders sheet. No manual updating required. It shows:

• Total Orders: =COUNTA(Orders!B:B)-1
• Total Spent: =SUM(Orders!K:K)
• Average Order Value: =AVERAGE(Orders!K:K)
• Items Pending: =COUNTIF(Orders!L:L,"Ordered")+COUNTIF(Orders!L:L,"Warehouse")+COUNTIF(Orders!L:L,"Shipped")
• Items Received This Month: A COUNTIFS formula matching "Received" status and dates in the current month.
• Top Category: A MODE formula showing which category appears most frequently.
• Wishlist Count: =COUNTA(Wishlist!B:B)-1

Wishlist Sheet: Pre-Purchase Planning

The Wishlist sheet uses the same column structure as Orders but without cost formulas. Its purpose is research and priority ranking. Add these extra columns:

• Priority: Dropdown — High, Medium, Low.
• Budget Check: A formula that compares the item's estimated total cost against your monthly budget cell and flags items that would push you over.
• Target Buy Date: When you plan to purchase. Useful for drops and limited releases.
• Price History: Notes on past prices to identify sales or price hikes.

Setup Guide: From Copy to First Order

Follow these steps to get your template running in under 10 minutes:

1. Make a Copy: Open the template link and click File > Make a copy. Save it to your Google Drive with a clear name like "My Yoybuy Tracker 2026."
2. Customize Currency: In column G, change the GOOGLEFINANCE currency pair to match your local currency. Common pairs: CNYUSD, CNYEUR, CNYGBP, CNYAUD. If GOOGLEFINANCE is unavailable in your region, replace it with a manual rate cell.
3. Adjust Categories: Edit the data validation dropdown in column D. Add or remove categories to match what you actually buy.
4. Set Your Monthly Budget: On the Dashboard sheet, enter your monthly spending limit in a designated cell. The Wishlist budget check formula references this cell.
5. Delete Sample Data: Clear the sample rows (rows 2-6) so you start with a clean sheet. Keep row 1 headers intact.
6. Test a Formula: Add one sample row with an original price. Verify that the converted price and total cost calculate correctly.
7. Bookmark the Sheet: Add the URL to your browser bookmarks and your phone home screen for instant access.
8. Set a Weekly Reminder: Add a 10-minute recurring calendar event for Sunday evening to update statuses and export a backup CSV.

Visual Formatting Already Applied

The template includes professional formatting out of the box:

• Header row is bold with a sand-colored background and white text.
• Alternating row colors (white and cream) for readability.
• Status column has conditional formatting: green for Received, yellow for Shipped, red for Issue.
• Total Cost column highlights values over $100 in coral.
• Date columns use proper date formatting.
• Currency columns show two decimal places with the correct symbol.

Template Comparison: Free vs Paid Options

Next Steps After Setup

Once your template is live, enhance it over time:

• Week 1: Enter all active and recent orders. Get every current item into the sheet.
• Week 2: Add your first 5 wishlist items with priority rankings.
• Week 3: Review the Dashboard. Check if total spent aligns with your perception.
• Week 4: Add conditional formatting rules for your personal preferences (e.g., highlight items over $200).
• Month 2: Explore advanced formulas like SUMIF for category spending or QUERY for shipped items.
• Month 3: If volume grows, add an Archive sheet and move completed orders monthly.

This free yoybuy spreadsheet template eliminates setup friction and gets you tracking orders in minutes, not hours. Everything is pre-configured, formula-ready, and visually organized. Make your copy, customize your currency, delete the sample data, and enter your first real order. If you want to understand the formulas in depth or build additional features, read our DIY build guide or explore advanced customization tips.