Do you like doing things right the first time? If so, read through this walkthrough!

Table of Contents

INTRODUCTION - Upload CSV Templates & what you need to know before starting.

CHAPTER 1 - Organizing Your Company Data Prior to Import

CHAPTER 2 - Importing Your First CSV File into Buildr

CHAPTER 3 - Organizing and Importing Your Contact Data

CHAPTER 4 - Organizing and Importing Your Opportunities Data

CHAPTER 5 - Resolving Upload Errors


INTRODUCTION

Looking to successfully migrate your data into Buildr and get the most out of Buildr CRM? This walkthrough will show you what to do and how to do it every step of the way. The order of operations is very important, so we highly recommend reviewing this guide before getting started.

Click the links below to download the Buildr templates:

Company Import Template

Contact Import Template

Opportunity Import Template

When importing your data, we recommend the following order for successful imports:

  1. Import Companies

  2. Import Contacts

  3. Import Opportunities

Contacts must be tied to a Company, so you need your Companies set up first. Contacts are added second because the Opportunity import will reference contacts in Buildr. The Opportunity import should be done after both Companies and Contacts are set up because they are tied to Companies and Contacts.

Let's get started with our Company imports next.


CHAPTER 1: Organizing Your Company Data Prior to Import

All your companies need to be organized in a CSV in the following format:

The names of each field is in the first row. The only mandatory field in the company import is the company name. We recommend populating as much information as possible, but if you only have the name for any given company you will still be able to proceed with the import.

The other fields are fairly straight forward, but there are a few rules to keep in mind so you don't run into any errors.

The "Type" field specifies the company's scope and relation to you. Buildr has a few default company types, and you are able to add as many custom types as you want. Make sure all of your company types are created in Buildr before attempting the import. In order to add any custom company types (like "Owner", for example), go to Settings > Company Settings > Company Type as shown below.

If you try to import a company and the type is not already in Buildr, you will receive an error with that company. Not to worry though, if you accidentally make a mistake, Buildr will create an error file for you that will tell you exactly what is wrong and what needs to be fixed. We discuss the error file in greater detail in this section.

Similarly, if you have additional Industries that are not part of the Buildr default list, you will need to add the industries in Buildr before you import your companies if you want to successfully populate that field on each company. For example, if you do a lot of commercial real estate work and want to specify "Multi-family" as it's own industry, you will need to add that in Company Settings. If this is not done, you can still complete the upload, but you will need to skip this field.

If you have any custom fields that you want tied to a company, make sure the custom field is first created in Buildr through Settings > Custom Fields > Company. Then add the custom field name in an available column. Example shown below.

Once your Company sheet has its data properly formatted, we can upload it to Buildr. We'll cover the import steps in the next section.

Back to Table of Contents


CHAPTER 2: Importing your Company CSV File into Buildr

On your Companies page, click Companies and then choose "Import CSV" as shown below.

The upload modal will open, and you can drag and drop your CSV file or click "Select a file" to choose the file from a folder on your computer. Give the upload a name so that you can reference the import in case any issues come up, and optionally add a description.

Click Next to move onto to field mapping. This is where we will make sure that the columns in our spreadsheet appropriately match the fields in Buildr.

Buildr will show each column in the spread sheet in its own box with the first three column entries. Make sure check boxes are checked for every column that you want to import into Buildr. If there's a column that you do not want, uncheck it.

Select the correct field to map to in Buildr in the drop down menu in each box (if it is not automatically correct), and then scroll to the bottom of the page to continue to the Review stage.

The review stage will show you how many new companies will be imported, how many existing companies will be updated, and how many errors (if any) you have. In this example we have no errors, so we can click "Complete Import" and now will have all our companies in Buildr.

However, if there were errors, we would see a screen that looks like the following:

The good news about the errors is that Buildr automatically generates an Error File for you which will show you exactly which rows (companies in this case). You download the CSV error file, and there will be an additional column explaining the error.

You can conveniently just make the changes within the error file itself. Save the changes in the error file, and then do a new upload using your updated error file csv to get the rest of your companies in Buildr.

We will walk through the error file in detail in the last section.

Back to Table of Contents


CHAPTER 3: Organizing and Importing Your Contact Data

Once all your companies are imported into Buildr, it is time to import your contacts. Download the contacts CSV template through the link in the Introduction.

The CSV template shown above has all of the default fields that Buildr has associated with contacts. You can add custom fields in the sheet if you have additional data that needs to be associated with each contact. If you need custom fields, make sure they are first set up in Buildr (Settings > Custom Fields > Contact) before importing your CSV.

Required fields/Columns:

  1. First name

  2. Last name

  3. Email address

(If you only have a phone number, we recommend adding the phone number to the corresponding company profile.)

The email field is required because email addresses make it easier to uniquely identify contacts. Contacts may have the same first and/or last names, but an email address will always be unique.

Additionally, we recommend using email addresses when tying contacts to Opportunities (more on that later). You are welcome to use First Name/Last Name when associating contacts with Opportunities, but email is recommended when possible.

The company field is not mandatory. However, it is very helpful to have the company column populated in your contacts CSV so that you do not have to go back later and individually assign a company to your contacts.

Once your contact sheet is set up according to the format shown in the CSV template, it is time to import it. Go to Contacts and select Contacts > Import CSV. Follow the same steps we went through for the Company CSV Import.

Back to Table of Contents


CHAPTER 4: Organizing and Importing Your Opportunity CSV

The Opportunity CSV is the most detailed, but since you have already set up your Company and Contact CSVs, this will be very straight forward. Download the Opportunity CSV Template from the link in the Introduction.

The only thing to keep in mind is that the Opportunity CSV sheet will reference existing companies and contacts, so it is important to make sure your companies and contacts are set up well prior to importing your opportunities.

Required Fields/Columns:

  1. Name

  2. Stage

  3. Company

The Opportunity must have a name and stage, and it must be tied to a company. The name and stage can be edited after import as necessary.

Buildr also allows you to add custom stages, so prior to uploading your Opportunity CSV, we recommend adding any custom stages you may desire (Settings > Opportunity Settings > Opportunity Stages).

If you have stages that are not listed in Buildr's default list or that do not exactly match what is in Buildr, you will run into an import error. Add your stages in the Opportunity Settings first, and proceed with your import.

Just like for Companies and Contacts, you can add as many Custom Fields as you would like. We recommend setting these up before importing your data into Buildr.

Additional Key Details for Setting Up Your Opportunity CSV

The Opportunity CSV has some nuances that are very important to note for the fields highlighted in the image below:

All of the fields listed below are optional, but if you choose to use them please keep the following in mind:

  1. The Company name must be an exact match to a company in Buildr/your company CSV file.

  2. The 'assigned_to' column is someone who is a Buildr user and must have their email address. A common mistake is to input the person's name instead of the email address that they use to login to Buildr.

  3. The 'primary_contact' field is a contact that is tied to the company. This field requires their email address. Contacts are uniquely identified by their email address in Buildr because people often have the same names. So in order for Buildr to recognize the correct contact, the email address must be placed in this field.

  4. Probability is a number between 1 and 100. It represents the percentage.

  5. Project Category is the Market Sector. Just like for Opportunity Stages, what you put here must already be listed as a Market Sector in your Opportunity Settings.

  6. Like Stages and Project Category, the Lead Sources and Contract Types columns must correspond to options that are already in Buildr in your Opportunity Settings.

Once your Opportunity CSV is set up, go through the import process like you did for Companies and Contacts.

Back to Table of Contents


CHAPTER 5: Resolving Upload Errors

In the section on uploading your CSV files, we walked through uploading our companies. Let's take a look at the error file that we generated at the end of that section.

If you run into any errors while uploading, click "Download Error File" in the Review stage of your import (you can still complete the import, but companies that have errors will be skipped over).

When we open the CSV file with the errors, we will see our same spreadsheet, except only the rows that had problems will show up. Additionally, there will be a new column on the right side of the sheet that lists the error(s) for each row:

Each of these companies have errors. The error message lets us know the column(s) with the problem and what the problem is. If you are unsure what your error message means, please reach out to us in the chat! We will help you resolve the errors and get your import completed.

In the case of the first two companies, Trail Blazers and Lakers, the 'type' column and 'industry' columns are the problem.

Where the error says "company category missing 'Owner'", this means that 'Owner' is not yet a specified company type in Buildr. So in order to resolve this error, we first need to go to our Company Settings and add 'Owner' as a type. The same is true for "Industry missing 'Entertainment'". We need to add 'Entertainment' as a Company Industry:

Once we resolve all the errors, we can import the error file into Buildr in order to get these additional companies (or contacts / opportunities) into Buildr. When you get back to the field mapping screen, just make sure the error column is unchecked so that Buildr ignores it:

If all the errors are resolved, you will see 0 errors in the review section:

Back to Table of Contents

Did this answer your question?