Import customers from a spreadsheet
Bring companies and contacts in from a CSV file, with nothing overwritten.
If your customers are in another app or a spreadsheet, you can bring them all in at once. You see what every row will do before anything is saved.
Before you start
- Importing is switched off for everybody to begin with. An admin can import, or can allow somebody else to.
- Save your spreadsheet as a CSV file. In Excel or Google Sheets that is under Save as or Download.
- Use one row per company, or one row per contact. Rows for the same company become one company with several contacts.
Steps
- Open Companies from the menu and press Import.
- Choose your file. It is read, and nothing is saved yet.
- Under Match the columns, check that each detail points at the right column of your file. The columns are guessed from your file's first row. Choose Not in this file for anything you do not have.
- Under What each row will do, read through the rows: new, filled in, or refused, with the reason.
- Press Import at the foot. The button says how many companies it will bring in.
What it does with a company you already have
A company that is already here is matched by its email, website or name. Only its blanks are filled in. Nothing already there is overwritten.
If rows are refused
A row is refused when it cannot be used, for example a row with no company name or an email address that is not one. Press Download refused rows for a file listing each one and why. Fix them in your spreadsheet and import that file again: rows already brought in are matched, not doubled.