Free template
Free freelance proposal tracker template (CSV)
Short answer
Download the CSV template: a header row with the same columns as BidBoard’s CSV export, ready for any spreadsheet app. Below is what each column means and the formulas for bid cost, win rate and cost per win. Prefer a ready-made tracker? BidBoard does the maths and charts for you.
The columns
| Column | Name | What goes in it |
|---|---|---|
| A | id | BidBoard’s id for the lead (any unique text in a spreadsheet) |
| B | title | Short name for the job |
| C | link | Link to the job post |
| D | platform | Your own label for where you found it |
| E | status | applied, viewed, interview, won or lost |
| F | applied_at | When you sent the proposal |
| G | posted_minutes_before_applying | How many minutes after posting you applied |
| H | proposals | Proposals band when you applied: lt5, 5-10, 10-15, 15-20, 20-50 or 50+ |
| I | interviewing | Was the client already interviewing? yes or no |
| J | client_rating | Client rating, 0 to 5 |
| K | client_reviews | Number of client reviews |
| L | client_hire_rate_percent | Client hire rate, in percent |
| M | client_spent | What the client has spent on the platform |
| N | client_country | Client country |
| O | budget_type | fixed or hourly |
| P | budget_min | Lowest budget in the post |
| Q | budget_max | Highest budget in the post |
| R | bid_units | Bid units (credits, bids) the proposal used |
| S | cost_per_unit | What one unit cost you |
| T | bid_cost | bid_units × cost_per_unit |
| U | currency | Currency code of the money columns, e.g. USD |
| V | fit_score | Fit score, 0 to 5 |
| W | follow_up_at | When to follow up |
| X | status_history | Every status change with its date, e.g. applied@… | viewed@… |
| Y | notes | Your notes |
| Z | job_text | The job post you pasted (leave out personal details) |
| AA | created_at | When the row was created |
| AB | updated_at | When the row last changed |
Money columns are plain decimals in the currency of the currency column. Dates are ISO 8601 (for example 2026-10-30T09:00:00.000Z), which spreadsheets can sort.
Formulas to add in your spreadsheet
Open the file in any spreadsheet app. With the template’s column order, status is column E, bid_units column R, cost_per_unit column S and bid_cost column T:
- Bid cost per row:
=R2*S2in column T. - Win rate:
=COUNTIF(E:E,"won")/(COUNTA(E:E)-1)(won ÷ all proposals, header excluded). - Total spent:
=SUM(T:T). - Cost per win:
=SUM(T:T)/COUNTIF(E:E,"won").
Use one of the five statuses in the status column: applied, viewed, interview, won or lost.
Template or tracker?
The template is enough for a few proposals a month. BidBoard adds the five-point fit score as you type, dated status history, follow-ups, charts by fit score and freshness, and AI first drafts. Its CSV export uses these same columns, so a spreadsheet and BidBoard stay compatible. BidBoard does not import CSV files yet. Spreadsheet vs tracker, compared.
Track your own proposals. BidBoard is free for up to 15 active leads, with no sign-up to try. Not affiliated with any freelance platform.
Questions
Is the template free?
Yes. It is a plain CSV file with a header row; no sign-up and no tracking.
Can I import the template into BidBoard?
Not yet. BidBoard exports to this format; importing a CSV is not supported.
Which spreadsheet apps can open it?
Any app that opens CSV files. The first row holds the column names, and every later row is one proposal.