Housecall Pro price book: the export, edit, and reimport workflow
If you exported a Housecall Pro price book, edited hundreds of rows in Excel, and are about to import it again, the difficult part is not the upload. It is knowing exactly what changed while the file was outside Housecall Pro. This guide walks the whole round trip and points you to the specific check for each step.
Housecall Pro has its own importer, with field mapping, validation, and inline error correction built in. Nothing here replaces it. What this guide adds is the discipline around it: what to keep, what Housecall Pro genuinely requires versus what is merely good hygiene, how to read the changes you made, and the one comparison most people skip.
Start with the question you actually have
Most people arrive here mid-problem. Find your question below and go straight to the page that answers it; come back to this guide for the full workflow.
The round trip, step by step
- Export, then keep the export. Save the untouched file somewhere you will not edit it. It is your only reliable rollback and the only honest baseline for a comparison later. Why this matters more than it sounds.
- Decide native tool or spreadsheet. For a uniform change such as a flat percentage increase, Housecall Pro's own bulk tools are usually the safer route. Reach for a spreadsheet when the change is uneven, conditional, or touches categories and names. How to choose.
- Edit on a copy, carefully. Excel will silently reformat numbers, strip leading zeros, and let a filter hide rows during a save. The specific things to guard against.
- Compare the edited file against the export. Before you validate anything, look at what changed: which rows, which columns, which prices went to zero, which categories went blank, which rows disappeared. This is the step that turns “the file uploaded” into “the file is right”. Why comparison is a different check from validation.
- Check the requirements, not just the format. Run the reimport checklist and fix anything in the requirement rows of the table below.
- Import a few rows, then the rest. Open the test items in Housecall Pro and confirm placement and prices before the full upload. If the wizard reports an error, the error guide maps each message to a fix.
What Housecall Pro requires, and what is only good hygiene
These two things get blurred constantly, and the blur causes bad advice in both directions: people either panic over harmless duplicates or wave through a genuinely blocking industry mismatch. The requirement rows below come from Housecall Pro's published import and error documentation. The rest is labelled for what it is.
| Check | Basis | Detail |
|---|---|---|
| Industry must match an industry already in your account, spelled exactly | Housecall Pro requirement | "HVAC" is rejected; "Heating & Air Conditioning" is accepted. The value is checked against your account’s industry list. |
| Category is required on every row | Housecall Pro requirement | Error text: "Category: Name is Required". Blank categories are the classic fill-down casualty. |
| Name is required for every service and material | Housecall Pro requirement | Error text: "Service: Name is required" / "Material: Name is required". |
| Name must be 190 characters or fewer | Housecall Pro requirement | The error reports a 191-character maximum; keep names at 190 and move the rest into the description. |
| Subcategory counts must match across categories | Housecall Pro requirement | If one category has subcategories, the others need a matching count, and services should not sit beside subcategories in the same category. |
| File must be a supported type with no hidden characters | Housecall Pro requirement | "Your CSV could not be uploaded" points at .xls files that should be .csv, or non-printable characters pasted from another document. |
| Price is optional | Housecall Pro behaviour | A blank price imports as $0. That is not an error, which is exactly why an accidental blank is dangerous. |
| No duplicate names or SKUs | Good hygiene, not a rejection | Housecall Pro’s import fields do not include a SKU and it does not reject duplicates on that basis. Duplicates still make a price book hard to maintain. |
| Prices formatted as plain numbers | Good hygiene, not a rejection | "$1,299.00" is a data-quality problem to clean, not a documented Housecall Pro rejection. Normalise it before import anyway. |
| Keep the identifier columns that came with the export | ImportFix recommendation | Housecall Pro’s exact update-versus-create behaviour for exported identifiers is not spelled out in public documentation. Dropping the column is an irreversible edit; keeping it costs nothing. |
Learn to read a change audit: six kinds of change
The question behind a safe reimport is not “is the CSV valid?” It is: can you explain every meaningful change between the file you exported and the file you are about to import? Sorting changes into these six groups is how you answer that in minutes instead of hours.
Expected
A change you decided to make and can explain.
Example: AC Tune-Up, Price 149 → 179. You raised tune-up pricing this season. Fine.
Unexpected
A change you did not decide to make.
Example: Furnace Filter Replacement, Category "Maintenance" → blank. The fill-down stopped early. Housecall Pro will reject the row; the real problem is that you did not know.
Risky
A change that is technically valid and commercially dangerous.
Example: Water Heater Install, Price 1,850 → 0. Blank prices import as $0 without complaint. Nothing stops a technician quoting it.
Removed
A row present in the export that is gone from the edited file.
Example: Twelve drain-cleaning services vanished after a filter was left on during save. No validator can flag a row that does not exist.
Added
A row in the edited file that was not in the export.
Example: New "Smart Thermostat Install" rows. Expected if you built them; worth a look if you did not.
Unchanged
Everything else, and the bulk of most files.
Example: Hundreds of rows that should stay exactly as they were, which is why you review the changed ones first instead of re-reading the whole sheet.
Two of the six deserve most of your attention. Removed rows are invisible to every validator, because you cannot validate a row that is not there. Risky changes pass validation by design, because a $0 price is a legal value. Both only show up when you put the original and the edited file side by side.
Where ImportFix fits, and where it does not
ImportFix is an independent tool and is not affiliated with Housecall Pro. It does not connect to your account and does not move data anywhere: parsing, comparison, and validation run in your browser. Its free Change Audit does the side-by-side comparison above and groups every difference into blockers, risky changes, data-quality warnings, and ordinary edits; its scan checks the final file for the requirement rows in the table. It does not guarantee that Housecall Pro will accept a file, and a small test import remains the last word.
Compare your original export with the edited file before you upload it.
FAQ
- Do I have to reimport the price book to change prices?
- No. Housecall Pro has native bulk-edit tools for rates, durations, and tax settings, and for a uniform change they are usually the safer route. A spreadsheet reimport earns its place when the change is uneven or conditional, or when it touches categories and names.
- Can I edit a Housecall Pro price book in Excel?
- Yes. The risks are Excel’s own habits: reformatting numbers, stripping characters, and letting a filter hide rows while you save. Edit a copy, keep the original, and compare the two before importing.
- Will reimporting the file overwrite or duplicate my existing items?
- Housecall Pro’s public documentation does not spell out the exact collision behaviour for every case, so do not assume either outcome. Keep any identifier columns the export gave you, review the duplicates guide, and confirm with a small test import before loading the full file.
- What should I check first if I only have ten minutes?
- Compare the edited file with the export and look only at what changed: removed rows, blank categories, prices that went to zero, and industry values that no longer match your account. Those four catch most of the damage.
Edited a price-book file already?
Compare the original and edited CSV/XLSX first, then scan the final file for supported import issues. No account or Housecall Pro API key required.
Findings preview is free. Payment is required only to unlock a corrected-file download.