ProSheet Studio

How Much to Charge for Excel Work: Hourly Rate, Fixed Prices by Job Type and a Minimum Charge

By Roger Ramey· Updated · 11 min read· Every number shows its working

Short answer

Work out one hourly rate from your own numbers, then price every job from it: rate = (take-home goal / (1 - tax reserve) + yearly expenses) / billable hours. $63,000 take-home, a 30% reserve, $7,200 of expenses and 1,080 billable hours give $90.00; a 12-hour dashboard with a 20% buffer is $1,296.

On this page
  1. How much to charge for Excel work: the formula and a worked rate
  2. Excel freelancer rate calculator: enter your own numbers
  3. Excel work rate card by job type: fixed prices from one hourly rate
  4. Minimum charge for a 20-minute Excel fix
  5. Hourly vs fixed price vs value: what an overrun does to your rate
  6. Scope before price: the questions that turn into hours
  7. Platform fees: gross up the rate, do not add the percentage
  8. How much to charge for Excel work per month: a support block after delivery
  9. One published fixed price for spreadsheet work: what $497 buys
  10. Excel rate formulas, common mistakes and what goes on your rate sheet
  11. Step-by-step
  12. FAQ

How much to charge for Excel work: the formula and a worked rate

Set one hourly rate from your own income target, then build every Excel price on it: job price = hours x rate x (1 + buffer). The rate is (take-home wanted / (1 - tax reserve) + yearly business expenses) / (billable hours a week x working weeks).

Worked through: $63,000 / 0.70 = $90,000 before tax. Expenses of $7,200 (software, add-ins, a laptop, insurance: all assumed) lift the revenue target to $97,200.00. Selling 24 hours a week across 45 weeks gives 1,080 billable hours, and $97,200.00 / 1,080 is $90.00 an hour.

Worked example: Excel freelancer hourly rate: $63,000 take-home, $7,200 yearly expenses, 30% tax reserve, 24 billable hours a week for 45 weeks. All assumptions: replace them with yours.

Inputs (assumptions — replace with your own) and results
ItemValue
Business expenses a year (input)$7,200.00
Tax reserve % (input)30%
Billable hours a week (input)24
Working weeks a year (input)45
Target margin % (input)0%
Take-home income you want (input)$63,000.00
Revenue needed$97,200.00
Billable hours a year1,080
Hourly rate to charge$90.00
Day rate (8 hours)$720.00
Naive rate (income / 2,080 hours)$30.29

Computed with the same formulas as the free calculators on this site. Change any input in the calculator above to see your own numbers.

What not to do. Dividing a $63,000 salary by 2,080 office hours is the last row of that table: $30.29. Charge it for 1,080 hours and you invoice $32,713.20; take out expenses and the 30% reserve and you keep $17,859.24, which is $45,140.76 under the target.

A disclosure: this site sells pricing templates and one fixed-price custom build, covered near the end. I build pricing maths and do not take hourly Excel jobs. No market rate is quoted here: every figure is an assumption to replace with your own.

Excel freelancer rate calculator: enter your own numbers

The five boxes are the five inputs of the formula. Change them and the highlighted row, "Hourly rate to charge", is the number the rate card, the minimum charge and the support block below are built on.

Only hours that land on a client's invoice count as billable. Scoping calls, writing quotes, learning a new add-in and chasing payment do not, so the example sells 24 hours a week, not 40. For a longer treatment of billable hours and the reserve, see the freelance hourly rate calculator guide.

The 30% is a placeholder, not advice. Part of it is self-employment tax: in the IRS's words, "The self-employment tax rate is 15.3%", made up of 12.4% for Social Security and 2.9% for Medicare (IRS: Self-employment tax). Income tax comes on top of that. The same agency says a self-employed individual is generally "required to file an annual income tax return and pay estimated taxes quarterly" (IRS: Self-employed individuals tax center), and that individuals generally have to make estimated tax payments if they expect to owe tax of $1,000 or more when their return is filed (IRS: Estimated taxes). Pages read 13 October 2026. A tax professional can tell you the percentage that fits your situation.

The freelance rate and quote calculator holds the same sum in an Excel or Google Sheets file you keep.

Excel work rate card by job type: fixed prices from one hourly rate

Fixed price = estimated hours x hourly rate x (1 + risk buffer). At $90.00 an hour, a 6-hour template build with a 15% buffer is $621 and a 12-hour dashboard with a 20% buffer is $1,296.

Excel work rate card at $90.00 an hour (every hour and buffer figure is an assumption: replace it with your own job log)
Job typeAssumed hoursHours x rateRisk bufferFixed priceHours the price covers
Formula fix or audit of one workbook2$18010%$1982.2
Template build: one input sheet, one output sheet6$54015%$6216.9
Data clean-up or Power Query import8$72025%$90010
Dashboard with charts and slicers12$1,08020%$1,29614.4
VBA or macro automation16$1,44030%$1,87220.8
Multi-sheet model with scenarios30$2,70025%$3,37537.5

The buffer pays for scope you cannot see when you quote. It is larger where the unknown sits in the client's data or process (a clean-up job, a macro that must survive odd inputs) and smaller where the whole job is visible in the file.

None of these hours or percentages is a standard. Log estimated against actual hours, then replace each row with your own average.

Minimum charge for a 20-minute Excel fix

Minimum charge = (minutes on the fix + handling minutes) / 60, rounded up to your billing block, x hourly rate. A 20-minute fix with 55 minutes of handling is 75 minutes, 1.25 hours, $112.50.

The handling minutes are assumed: 10 for reading the request and replying, 20 for opening the file and finding the cause, 15 for testing and writing a short note, 10 for invoicing. They barely change with the size of the fix, so a small job carries them in full.

Small Excel fixes at $90.00 an hour with 55 assumed handling minutes a job, billed in quarter-hour blocks
Minutes on the fixMinutes in totalHours billedChargeIf you bill the fix onlyWhat that pays per hour worked
20751.25$112.50$30$24.00
40951.75$157.50$60$37.89
601152$180$90$46.96

Bill only the 20 minutes and the invoice is $30 for 75 minutes of work: $24.00 per hour worked, under the $30.29 salaried shortcut.

Hourly vs fixed price vs value: what an overrun does to your rate

Hourly billing leaves the overrun with the client; a fixed price moves it to you. Effective hourly rate = fixed price / hours worked.

The $1,296 fixed-price dashboard job at four outcomes (assumed hours)
OutcomeHours workedEffective hourly rateAgainst billing every hour at $90.00
As estimated12$108.00$216 ahead
Buffer fully used14.4$90.00level
25% over the estimate15$86.40a loss of $54
50% over the estimate18$72.00a loss of $324

The 20% buffer absorbs 2.4 extra hours. At 25% over, the job pays $86.40 an hour; at 50% over, $72.00, a loss of $324 against hourly billing.

A value check, not a value price. If the client says the dashboard saves 3 staff hours a week and puts their own cost at $40 an hour (both assumed), that is $120 a week, and $1,296 / $120 = 10.8 weeks to pay back. Use only the client's own numbers; this is arithmetic, not a promise of savings. The freelance quote template guide covers the document the price goes into.

Scope before price: the questions that turn into hours

Every answer below adds or removes hours, so ask before you quote and write the answers into the quote.

Scope questions for a spreadsheet job and what each one changes
Ask aboutQuestionsWhat it changes
InputsHow many source files, how clean, refreshed how often?Import and clean-up hours; the buffer
OutputsWhich numbers, charts and printable pages?Build hours, output by output
UsersHow many people, which Excel version, Google Sheets too?Protection, input checks, testing per platform
Edge casesBlank cells, duplicate IDs, a new month or product row?Error-handling hours
HandoverNotes, a walkthrough call, locked formula cells?Hours after the build

Ask for one test case: inputs with the answer the client worked out by hand. The buyer's guide to hiring someone to build an Excel spreadsheet tells clients to write one.

Revisions and later changes. State how many revision rounds the price includes and define a round as one consolidated list. Price an extra round as a block: an assumed 1.5 hours is $135. Work requested after sign-off is new work at $90.00 an hour, with the $112.50 minimum.

Platform fees: gross up the rate, do not add the percentage

If a marketplace keeps a percentage of what the client pays, list rate = hourly rate / (1 - fee %). With an assumed 10% fee, $90.00 / 0.90 = $100.00.

Listing rate that still nets $90.00 an hour after a platform fee (the fee percentages are examples; read your platform's current fee page)
Fee on what the client paysRate to list (rate / (1 - fee))Rate if you add the fee %What that nets after the fee
10%$100.00$99.00$89.10
20%$112.50$108.00$86.40

Adding 10% gives $99.00, which nets $89.10 after the fee: $0.90 an hour short, $972 over 1,080 hours. The gap widens with the fee.

No platform's fee is quoted here: fees differ and change, so read your platform's current fee page and use its percentage. Fixed prices gross up the same way.

How much to charge for Excel work per month: a support block after delivery

Monthly support price = hours reserved x hourly rate. At $90.00, a 4-hour block is $360 a month.

Monthly Excel support blocks at $90.00 an hour, against 90 billable hours a month (assumed inputs)
Support blockMonthly priceShare of your billable month
2 hours a month$1802.22%
4 hours a month$3604.44%
8 hours a month$7208.89%

Check capacity before selling blocks. 1,080 billable hours a year / 12 = 90 a month. Six clients on the 4-hour block reserve 24 hours, 26.67% of the month, for $2,160 of revenue that does not depend on new projects.

Decide in writing what the block covers and whether unused hours expire at month end or roll over once. That is your policy, not a rule. The consulting fee guide prices both options.

One published fixed price for spreadsheet work: what $497 buys

One fixed price I can state as fact is this site's own: ProSheet Studio's done-for-you custom job-pricing calculator is $497 one-time.

Its page lists the scope: a calculator tailored to the buyer's trade with their materials, labour tasks, equipment and rates pre-loaded; a branded client quote or proposal page; a job log and win-rate dashboard; delivery in Excel and Google Sheets; one round of revisions. It says the build usually takes 2-3 business days after the intake form, with scope confirmed by email first.

That is one seller's price for one defined scope, not a market benchmark. What it shows is the division any fixed price implies:

What a $497 fixed price works out to per hour at three ASSUMED build times (the product page does not publish hours)
Assumed hours on the buildEffective hourly rate
6$82.83
10$49.70
14$35.50

At the example's $90.00 rate, $497 pays for 5.52 hours. A fixed price holds up when the scope repeats and the hours are known.

Excel rate formulas, common mistakes and what goes on your rate sheet

The five formulas below rebuild the rate, a fixed price, the minimum charge, a fee gross-up and the overrun check. Each note says which cell holds which input; enter percentages as percentages.

Hourly rate

=ROUND((B2/(1-B4)+B3)/(B5*B6),2)

B2 = take-home goal (63000), B3 = yearly expenses (7200), B4 = tax reserve (30%), B5 = billable hours a week (24), B6 = working weeks (45). Put the result in B7. Returns 90 for the example.

Fixed price for a job type

=ROUND(B8*B7*(1+B9),2)

B8 = estimated hours (12), B9 = risk buffer (20%). Returns 1296. Use one row per job type to build the rate card.

Minimum charge for a small fix

=ROUND(CEILING((B10+B11)/60,0.25)*B7,2)

B10 = minutes on the fix (20), B11 = handling minutes (55). CEILING rounds 1.25 hours up to the next quarter hour. Returns 112.5.

List rate after a platform fee

=ROUND(B7/(1-B12),2)

B12 = the platform's fee as a % of what the client pays (10%). Returns 100. Adding the fee (=B7*(1+B12)) returns 99, which nets 89.10.

Effective rate on a fixed-price job

=ROUND(B13/B14,2)

B13 = the fixed price (1296), B14 = hours actually worked (18). Returns 72. Log it after every job and adjust the hours on the rate card.

Common mistakes: a salary divided by 2,080; billing a small fix by the minute; a fixed price with no buffer or revision limit; adding a platform fee as a percentage; support promised without reserved hours.

What to put on your rate sheet: the hourly rate; the minimum charge and what it covers; a fixed price per job type; revision rounds included and the price of an extra round; the rate after sign-off; support block prices and the unused-hours rule.

Freelance Rate & Quote Calculator

A freelance rate and quote sheet for Excel & Google Sheets. It works out the hourly rate in this guide from your income goal, tax set-aside, expenses and billable hours, then quotes a project from hours x that rate plus costs and a rush markup. It has no job-type rate card: enter each job's hours as the project hours and use its rush or complexity markup for the buffer. One-time $14.99, no subscription, instant download.

See the freelance pricing template →Buy now — $14.99All 7 templates — $49

Instant access by email after checkout via Payhip.

The freelance pricing template ($14.99 one-time, Excel and Google Sheets) does the first half of this page in a file. Its first step takes a take-home goal, billable hours a week, working weeks, yearly expenses and a tax set-aside and returns a break-even rate, which is the rate on this page, plus a recommended rate at whatever profit margin you enter. Its second step multiplies project hours by the rate and adds a materials or software cost and a rush or complexity markup. Its page lists no job-type rate card, minimum-charge line or platform-fee line, so type each job's buffered hours in as the project hours. It prices; it does not produce a branded quote.

Step-by-step: How Much to Charge for Excel Work: Hourly Rate, Fixed Prices by Job Type and a Minimum Charge

  1. Work out the hourly rate. Take-home goal / (1 - tax reserve) + yearly expenses, all divided by the hours you can sell in a year. The example returns $90.00.
  2. Estimate hours by job type. List the kinds of Excel work you sell and the hours each took on past jobs.
  3. Add a risk buffer and fix the price. Hours x rate x (1 + buffer). Twelve hours at $90.00 with a 20% buffer is $1,296.
  4. Set the minimum charge. Add handling minutes to the fix time and round up to your billing block. Twenty minutes plus 55 is 1.25 hours: $112.50.
  5. Gross up for any platform fee. Divide the rate by (1 - fee %). A 10% fee turns $90.00 into $100.00.
  6. Write the terms as numbers. Revision rounds included, the price of an extra round ($135 in the example), the rate after sign-off and the support block price.

Freelance Rate & Quote Calculator

A freelance rate and quote sheet for Excel & Google Sheets. It works out the hourly rate in this guide from your income goal, tax set-aside, expenses and billable hours, then quotes a project from hours x that rate plus costs and a rush markup. It has no job-type rate card: enter each job's hours as the project hours and use its rush or complexity markup for the buffer. One-time $14.99, no subscription, instant download.

See the Freelance Rate & Quote Calculator →Buy now — $14.99All 7 templates — $49

Instant access by email after checkout via Payhip.

Frequently asked questions

How much should I charge for Excel work per hour?

Divide the revenue your year needs by the hours you can sell. Revenue is the take-home goal grossed up for a tax reserve, plus yearly business expenses. In the worked example a $63,000 goal needs $97,200.00 of revenue, and 1,080 billable hours make that $90.00 an hour.

What is the average hourly rate for freelance Excel work?

No average is quoted on this page. The published figures come from marketplaces and forum threads, which report other sellers' inputs, and none was verified against an official source. The rate that matters is the one your own income goal, expenses and billable hours produce in the calculator above.

How much should I charge to build an Excel spreadsheet?

Charge estimated hours times your hourly rate, plus a risk buffer. In the example, a template build assumed at 6 hours with a 15% buffer is $621 at $90.00 an hour, and a 30-hour multi-sheet model with a 25% buffer is $3,375.

Can I pay someone to do an Excel spreadsheet?

Yes. You can hire a freelancer, a specialist who builds one type of spreadsheet, or use a ready-made template. If you are the buyer, the <a href="/guides/hire-someone-to-build-excel-spreadsheet/">guide to hiring someone to build an Excel spreadsheet</a> covers scoping the job and the questions to ask before you pay.

How do I calculate my hourly rate in Excel?

Put the take-home goal in B2, yearly expenses in B3, the tax reserve in B4, billable hours a week in B5 and working weeks in B6. Then =ROUND((B2/(1-B4)+B3)/(B5*B6),2) returns the rate. The example inputs return 90.

Should I charge hourly or a fixed price for Excel work?

Charge a fixed price for job types you have built before, and hourly when the client cannot yet describe the finished file. A fixed price moves the overrun to you: the example's $1,296 dashboard pays $72.00 an hour if it takes 18 hours, not 12.

Sources

Roger Ramey
By Roger Ramey
I'm not a contractor, landlord or accountant. I build the pricing maths, and every number on this page shows its working so you can check it instead of trusting it. Guides are drafted with AI assistance; every worked figure is computed by the same code as the free calculators. How these guides are made → · Watch the breakdowns on YouTube →
ProSheet Studio · Templates · Guides · Free calculators · Free spreadsheet · Custom build · About · Privacy · Refunds
Pricing maths and templates, not financial, tax or legal advice. Calculators run in your browser; the numbers you type are never sent anywhere.