Housecall Pro: CSV could not be uploaded

What this means

Housecall Pro imports a price book from a CSV or Excel file and walks you through an import wizard that matches your columns to its fields. If the file can’t be read — wrong type, no usable headers, or a structure the wizard can’t interpret — the upload fails before you ever get to mapping columns.

Documented causes and how to fix them

• Unsupported file type. Save the file as .csv or Excel (.xls/.xlsx). Exporting to PDF, Numbers, or Google Sheets’ native format won’t upload — use “Save as” / “Download as” CSV or Excel.
• No column headers. Housecall Pro expects a header row naming each field. If your first row is already data, add a new top row with column names so the wizard can map them.
• More than one row per item. Each item should be a single row. Data split across multiple rows for the same item won’t upload successfully — combine it into one row per item.
• Multiple sheets or merged cells. Flatten the workbook to a single sheet with plain rows and columns; merged cells and extra tabs confuse the parser.

File issues ImportFix catches for you

Beyond Housecall Pro’s own requirements, a CSV can be structurally broken in ways that are hard to see. The CSV validator and price book checker detect and repair the usual culprits: the wrong delimiter, unbalanced quotes, an unquoted comma inside a value that shifts every column, inconsistent column counts, and invisible control characters or encoding artifacts pasted from another app.

Common mistakes

• Renaming a file to .csv without actually re-exporting it as CSV.
• Leaving a title row or empty rows above the real header.
• Exporting a multi-tab spreadsheet and uploading the whole workbook.
• A stray unquoted comma inside a description or price that breaks the column alignment.

Prevent it next time

Start from a known-good structure — the price book template gives you the right headers and one row per item — and run the file through the checker before you upload, so structural problems are fixed while the file is still on your computer.

FAQ

What file types can Housecall Pro import a price book from?

A CSV or an Excel file. Save your data as .csv or .xlsx before importing; other formats such as PDF or a spreadsheet app's native format will not upload.

Why does my file fail before I can map columns?

The upload step fails when the file can't be read at all — usually an unsupported type, a missing header row, multiple rows per item, or multiple sheets. Fix the structure and the wizard will let you map columns.

Does my price data get uploaded when I use the checker?

No. The checker and validator run entirely in your browser — your price data is not uploaded to a server while you scan and repair the file.

See also the full list of import errors.