Free Spreadsheet Tools & Templates

Building a tracker from scratch takes time and spreadsheet knowledge that not everyone has. That is why we built three production-ready templates designed specifically for buying-agent shoppers. Each template includes example data, protected formulas, built-in instructions, and a clean visual design that makes tracking enjoyable rather than tedious.

All templates are free. No email required. No signup walls. Simply click the format you prefer, make a copy, and start tracking. If you find them useful, share the link with friends or link back from your blog.

Template Library Overview

Basic Order Tracker

The Basic Order Tracker is the perfect entry point. It contains nine columns: product name, URL, marketplace, item price, estimated weight, agent, status, notes, and total landed cost. You enter data into the first eight. The ninth calculates automatically.

The tracker includes five rows of example data so you can see how formulas work before entering your own products. Simply overwrite the examples or delete them. The dashboard tab counts your total items and spending. The status column uses a dropdown so you cannot accidentally misspell a stage.

Use this template if you are shopping for yourself, buying fewer than twenty items per haul, and working with a single agent. It is intentionally simple so you spend time shopping, not configuring spreadsheets.

Advanced Haul Manager

The Advanced Haul Manager is where the spreadsheet becomes a command center. It supports unlimited agents, each with its own fee configuration. It includes a shipping matrix that estimates costs for EMS, DHL, FedEx, SAL, and sea mail based on weight brackets. It has a refund tracker, a dispute log, and a QC photo checklist.

The dashboard in this template is significantly richer. It shows spending by agent, average delivery time per shipping line, monthly spending trends, and a pie chart of categories. You can filter the main tracker by agent, status, or category to focus on specific subsets of your order history.

This template also includes a packing optimizer. Enter your warehouse inventory and the sheet recommends the most cost-effective shipping line for your total weight. It even warns you if your declared value exceeds common customs thresholds.

Advanced Template Feature List

Reseller Profit Sheet

If you buy through agents to resell on local marketplaces, you need more than a tracker. You need a profit calculator. The Reseller Profit Sheet adds columns for resale price, platform fees, shipping to buyer, and net profit per item.

It also includes an ROI dashboard showing which product categories yield the highest returns. One power user discovered that hoodies had a 42% ROI while accessories only returned 18%. That insight alone reshaped their entire buying strategy.

The sheet includes a restock reminder system. Enter your sell-through date and the sheet flags items that sold quickly, suggesting you reorder them. Slow movers turn red, warning you to avoid that style next season.

How to Use Any Template

Step 1: Make a copy. Open the template link and click File > Make a Copy in Google Sheets, or save the Excel file to your computer. Never edit the original shared file.

Step 2: Read the Instructions tab. Every template includes a dedicated instructions sheet with screenshots and explanations. Spend two minutes reading it before you start.

Step 3: Configure your settings. Go to the Settings or Fee Config tab and enter your agent's fee structure and your preferred currency. This step is critical for accurate totals.

Step 4: Delete example rows. Remove the pre-filled sample products so you start with a clean slate.

Step 5: Enter your first haul. Add real products from your wishlist. Watch the dashboard populate with live data.

Step 6: Update weekly. Keep statuses current. A stale tracker is worse than no tracker because it gives you false confidence.

Why Templates Beat Building From Scratch

Building a spreadsheet sounds easy until you need to handle currency conversion, conditional formatting, data validation, and chart generation. Our templates have been refined through feedback from hundreds of users. They handle edge cases you might not think of: per-item minimum fees, volumetric weight exceptions, multi-currency rounding, and platform-specific agent fees.

Using a proven template also means your data stays portable. When you switch agents or expand to a second marketplace, the template adapts. You do not rebuild from zero. You simply update a few configuration cells and keep tracking.

Frequently Asked Questions