Above are Excel templates to show how import spreadsheets should be formatted. It includes:
Commonly-used fields (Do not alter the field names in the first row)
Field length restrictions (Hover over field names to see comments)
Sample data (Replace with your own data)
The following is a list of the column headers we’ve included for you. The character maximum length will be indicated in brackets.
CompanyName (41): Lead’s company name.
Name (41): Required field. A combination of the First and Last Name fields.
FirstName (25): Required field only for QuickBooks Online. First name of your lead.
LastName (25): Last name of your lead.
Contact (41): Name of the contact for your lead.
Method automatically creates a contact for each lead based on the Name field.
Phone (21): Main phone number for this lead.
Email (1023): Lead’s email address.
BillAddress fields (each at 41): There are three fields marked BillAddressAddr and are provided in addition to BillAddressCity, BillAddressCountry, BillAddressState and BillAddressPostalCode. The BillAddressAddr fields are typically used for the lead name, street address, and suite number if necessary.
If you require further fields of information, you can add them yourself.
Now it’s time to start your first lead import!
In the upper right corner, click the Gear icon and select Preferences, then click Integrations > Launch Import/Export. This will open your import/export tool.
Import - Step 1: Import / Export menu
Select Import into a table from a file.
Pick the table Customer Lead.
You must choose Customer Lead from the dropdown. Failure to do so may result in your leads being imported and synced to QuickBooks as customers.
Click Choose file and choose your import file.
Click Import Data... to go to the next step.
Import - Step 2: Prepare Data
Leave alignment set to Vertical.
Keep only First Row is List of Field Names checked.
All of your columns should import To Existing Field (if you followed our import templates).
If everything looks fine, click Import data.
Import - Step 3: Validation
Click Begin Import. When it's complete, click Finished.
If any errors are generated at this point, you will be informed the import is “finished, but with a few errors” and brought to a screen to address them. For more information on common errors, please see Troubleshooting.
When you have completed your import, you can go to your Contacts app and filter your Contacts List for active leads to ensure your records have been successfully imported.
And that’s it! You’ve successfully imported a list of leads to Method! Keep in mind that leads do not sync to QuickBooks, so they will not appear in your QuickBooks file after your next sync (they will only sync once they have become customers).
Before you decide to import a customer list, please keep in mind that Method’s sync with QuickBooks will automatically pull your QuickBooks customers into Method when you conduct your first sync. It may not be necessary to import customer lists if they are already in your QuickBooks file!
Importing customers requires almost the exact same steps as our Formatting and Importing steps above, assuming you are using our template to import your records. The only difference is this:
In Import - Step 1: Import / Export menu, when asked to choose a table to import to, choose Customers (instead of Customer Lead).
Otherwise, follow the steps above to complete your import.