Import customers or items from a CSV file

Bring in a spreadsheet of customers or items, and choose what happens to ones you already have.

How-toUpdated

  1. Open Customers (or Items) and choose Import CSV.
  2. Save your spreadsheet from Excel or Google Sheets as "CSV UTF-8". The first row must be the column names. Up to 5,000 rows.
  3. Choose Choose file.
  4. Check how each column is matched. Columns BuiltINVOICE does not use show Not in the file.
  5. Under When a row matches customers already here, choose Skip it or Update it. Update changes only the columns the file fills in; an empty cell never clears anything.
  6. Look at Rows to look at for rows with errors, then choose the Import button (it shows how many rows will be imported).
The CSV import screen

When it finishes you see how many were Added, Updated, Skipped (already there) and Not imported (errors), with the row number of each error.

Problems? See A CSV import fails.

Was this helpful?

Still need help?

Open a ticket from the app

In any BuiltSOFTHUB app, open Help & Support and choose Report a problem. Our replies appear under My tickets.

Email us

Write to support@builtsofthub.com. Tell us the store name and what you were doing when it happened.