Start a conversation

Contact / Client (Company) Import From MS Excel

If you have a list of companies in an MS Excel sheet, it is possible to quickly/easily import these into your Influence database. 

From Release v1.00.18.157 or later, whenever an import is performed the system will create a GROUP containing details of the Companies/contacts which were imported. (See below)

How it Works

1) Login to the database as the user "ADM" (or your own login if you have access to the [Maintenance] part of the system)

2) Choose Maintenance > Tools > Client/Contact import from Excel

3) Once the client import screen opens, click the [New] button at the bottom left to open an Excel template for you to use.
The template will have the column headings you can use,  e.g.
FORENAME  SURNAME   JOB TITLE   ORGANISATION   EMAIL   TELEPHONE   MOBILE .....etc

If you are using the spreadsheet to import contacts then you must specify a Forename/Surname in addition to any company information.

Important: Please leave the column titles as they are, i.e. UPPER CASE. Items in Blue are the minimum needed for a client (Company) import.

4) Copy/Paste the information from your excel sheet into the template under the correct column heading(s).
When done, save the template using Save As.... and save the file as an MS Excel 97-2003 type sheet. (i.e. *.xls)
Tip: When saving the spreadsheet please ensure that there are no Filters/Auto-filters and no rows or columns are "Hidden".

5) Before importing create a test spreadsheet by re-saving it with the first 2-3 lines only.

6) From the Influence Client/Contact import from Excel, click the [Next] button. A window will appear asking for the spreadsheet containing the information to be imported.

Simply Drag/Drop the test spreadsheet that you saved in step (5) onto the window, and press [OK]. The system will then import the contacts into your database.

7) Ensure the information has import correctly from the test spreadsheet. When satisfied repeat step 6 with the full spreadsheet.

Note: When importing data the system will ignore the "TITLE" row, and will then import rows until it hits a blank ROW. The first totally blank row will stop the import at that point and any data below this will not be imported.

Important considerations when using the Import Tool

A) If a company already exists, then it will not be added again if  the name in the import spreadsheet is IDENTICAL. If any part is different (Including CASE), then the import will add a new company.  
(i.e. Due to the case,  ABC Co Ltd  is different to Abc Co Ltd )

Ai) As a result of the above, if your import data contains two different organisations, with different addresses, but the same NAME then the import will create only ONE company, and all contacts at the firm with this name will be added to this ONE company/organisation.
e.g.
Woodland School, 28 Bromley Road, Bromley Kent, BR2 5LJ   John Jones, Maths Teacher.
Woodland School, 71 Harbour Street, Christchurch, Hants, BN11 2DW    Martin Lovell, Science Teacher.

This example will create ONE organisation called Woodland School, even though they are both at different addresses.

B) It is possible to load "Branches" by indicating the branch in brackets, i.e. (xxxxx)
e.g. Importing a spreadsheet with
ABC Tools Ltd (Leeds)  and also
ABC Tools Ltd (Bristol)     would create a single client called ABC Tools Ltd, with two branches. (Leeds & Bristol)

C) If you import a client only, with no contact (i.e. Forename/Surname are left <blank>) then the email field will only store the domain part of the email, i.e . Info@XYX-Products.com would be stored simply as @XYX-Products.com.  If you wish to store the whole email address you must specify a contact.

D) When entering fields such as 'Status' the code must be entered instead of the description, i.e. 'ACT' instead of 'Active'

E) If data is imported incorrectly it will need to be removed form the database before re-importing. If it is not removed then any future imports will be treated as duplicates and not imported.

F) It is good practice to test the import routine first. If you wish to import 2000 client records, we would suggest that your run an import using just the first 2 or 3 lines of your spreadsheet to start with - then if that works as intended, proceed to import the rest. If you have made  mistake with your data, this will make it much easier to undo before importing the bulk of your data.


Automatic Creation of Groups

From version 1.00.18.157 or later, whenever an import is run the system will automatically create a GROUP containing the details of any companies/Contacts which were added during the import.

The name of the group will be of the format Import dd/mm/yyyy as shown above.
This makes it much easier to remove or delete these records should there be any need to undo the import.


[ Keywords: Company import, excel import, company import from excel, import companies from excel, excel client import, excel company import, load companies.]

Choose files or drag and drop files
Helpful?
Yes
No
  1. Graeme Orchard

  2. Posted
  3. Updated

Comments