← All help

Bring your leads over from a spreadsheet

You can move a list of leads into Sunbear in a few minutes. Sunbear reads a file called a CSV, which is a plain table that every spreadsheet program can save. Nothing is added until you have checked it.

Step 1: Save your sheet as a CSV

The first row of your sheet should hold the column names, like Name, Phone and Note. Your file can have up to 500 rows at a time, and you can import again for the next batch.

Step 2: Open the import page

In Sunbear, open Me, then tap Import leads from a sheet.

Step 3: Choose your file

Tap Choose your .csv file and pick the file you saved. You can also copy rows from your sheet and paste them into the box below it.

Step 4: Check the columns

Sunbear guesses which column is which, such as first name, phone and note, and shows you its guesses. Change any that are wrong. A first name and a phone number are needed for every lead. Rows that cannot be used are listed with the reason, and they are skipped.

Step 5: Import

Tap the import button. You will see how many leads were added. A lead whose phone number is already in Sunbear is skipped, so importing the same file twice does not make doubles.

Want a template?

On the import page, tap Download the template. It has the right columns in the right order and one sample row. Fill it in with Google Sheets or Excel, save it as a CSV and follow the steps above. Rows that start with (example) are skipped.

Tips

Something still not working? Send us a message with the first few rows of your file (change the names and numbers first if you prefer).