Can you run a field service business on Excel or Google Sheets?

When a spreadsheet is enough

I like spreadsheets for service businesses at the start. They are free, you already know how to use them, and building one forces you to decide what you really need to track. The IRS says you can use any recordkeeping system suited to your business that clearly shows income and expenses, and a well-kept sheet qualifies.

A spreadsheet is usually enough when you have:

• One to three people doing jobs
• Up to roughly 15 to 20 jobs a week (my rule of thumb, not a fixed limit)
• One person who does all the data entry
• Mostly one-off jobs, not many recurring contracts

Excel itself is not the limit. A worksheet holds 1,048,576 rows by 16,384 columns, according to Microsoft, far more than a small service company will ever use. The limit is people and process, not size.

The four-tab starter sheet

Make one workbook with these tabs. Use the same column names every time so formulas and filters keep working.

Tab 1: Customers

Customer ID, name, phone, email, service address, billing address, notes (gate code, dog, parking), how they found you, and first job date.

Tab 2: Jobs

Job number, customer ID, job type, description, status (new, quoted, booked, done, invoiced, paid), quote amount, date booked, tech, hours, parts cost, total price, and a link to photos.

Tab 3: Schedule

Date, start time, end time, tech, job number, address and travel notes. A weekly grid works well here, one column per day and one row per hour.

Tab 4: Invoices

Invoice number, job number, date sent, amount, tax, date due, date paid, and a column for "days late" using a formula. Filter this tab every Monday to see who owes you money. For the invoice layout itself, see invoicing apps for contractors.

Trade-specific columns for HVAC and plumbing

Once the base is working, add columns that fit your trade. Keep them on the Jobs tab or give the equipment its own tab.

Trade	Useful extra columns
HVAC	Equipment type, make, model, serial number, install date, refrigerant type, filter size, maintenance plan (yes/no), next service due
Plumbing	Fixture or system (water heater, drain, main line), install date, water heater age, permit needed, emergency (yes/no), callback date

The "next service due" column for HVAC is the most valuable one. Sort by it each month and you have a call list for tune-ups, which is steady revenue. If you want more on this trade, read HVAC CRM and plumbing software.

A small worked example (made-up figures)

Say a two-person HVAC shop does 12 jobs in a week. Each job has a row on the Jobs tab, so the owner can filter by status in under a minute. Three jobs are "quoted" with no reply, which means three calls to make. Two are "done" but not invoiced, worth $640 and $1,150. Those are $1,790 of work sitting un-billed. That is the kind of thing a sheet shows you if you look at it weekly.

Now picture the same week with 35 jobs and a third tech. The owner is updating the sheet at 9 p.m., the tech's text about a new customer never reached the Jobs tab, and two techs edit the schedule at the same time. That is where the sheet stops helping.

Signs you have outgrown it

• Double entry. You type the same customer in the jobs sheet, the invoice and QuickBooks (accounting software).
• Lost jobs. A job lives in a voicemail, a text or a sticky note and never makes it into the sheet.
• Schedule collisions. Two techs, one slot, or a customer told the wrong time.
• No field access. Techs call the office for the address or the last repair.
• Late invoices. Work finishes on Tuesday and the bill goes out Friday because it is someone's night job.
• No customer messages. You do not send appointment reminders or follow-ups because it would take too long by hand.
• Several versions. There is "schedule_final_v3" in three places.

If three or more of those are true, you have outgrown it. More on this pain in replacing five spreadsheets with one customer database.

Your options when you move

A ready-made field service app. This is the usual next step. As of November 2026, ServiceM8, a job management app for trades, lists a free plan for one user with 30 jobs a month and a Starter plan at $29 a month with unlimited users and 50 jobs a month. Jobber, a scheduling, quoting and invoicing app for home service businesses, lists its Core plan at $29 a month billed annually for one user, and its Connect plan at $99 a month billed annually. Both charge more as you grow, and limits differ, so check each pricing page. For a full comparison, see field service management software.

A simple custom app built from your sheet. If your sheet already works and it is only the sharing and the mobile access that fail, a custom web app can copy your exact columns and screens. Read turning a spreadsheet into a web app for how that works. It makes sense when your process is unusual, or when per-user fees on a ready-made tool would grow faster than you do.

How to move without losing data

1. Clean the Customers tab first. Fix duplicates, one phone number per cell, one address per row.
2. Export each tab as CSV. Most apps import customers from a CSV file.
3. Run both for two weeks. Enter new jobs in the app and the sheet, and compare totals each Friday.
4. Move recurring work next. Maintenance plans benefit most from automatic scheduling.
5. Keep the old workbook. Save it read-only, since you may need old invoices for taxes.

How I'd approach this

If you have fewer than three people, start with the four-tab sheet and be strict about one entry point for every new job. Review it every Monday. The first time you notice unbilled work or a missed appointment, write down what it cost you. That number is your budget for moving to an app.

When you do move, try the free or lowest plan of a ready-made app first. Only consider a custom build if your process does not fit, since a ready-made tool is cheaper to start. For help seeing where automation would save the most time, read business process automation.