Importing Contacts from Excel

WinSMS Desktop Client – How To Import Contacts From Excel

Open the Excel spreadsheet that contains your contacts and do the following to clean your list:

  1. Check that all the contacts have valid cell numbers.
  2. Delete any contacts that don’t have cell numbers.
  3. Remove any empty rows.
  4. Remove all commas (,) from the spreadsheet.

Note that if the above guidelines are not followed, you will probably encounter errors when trying to import.

import1

In the above example, the “Acc Number” field is an optional field which can be imported into a custom field in WinSMS. To set up custom fields in WinSMS, go to File > Preferences > Contact Additional Info.

Save As CSV file:

Now you must save your spreadsheet as a CSV (Comma delimited) (*.csv) file before you can import your contacts into WinSMS.

Click on File and select “Save As”, the following window will prompt you for a file name – you must also set the file type to CSV.

Remember to take note of the “Save in:” location where you are saving your file.

import2

When you click on the “Save” button, the following dialog box will prompt you, click on “Yes”.

import3

The last step before importing into WinSMS is to close the CSV file, otherwise WinSMS will be unable to open it for importing.

When you close the file or close Excel, the following prompt will appear, select “No”.

import4

Importing Contacts into WinSMS:

Open WinSMS – click on “File” then “Import…”

v3702ImportWizard

Choose “Contacts from text files” and click on Next.

v3702ImportWizard2

Click on “Select File…” – choose the CSV file and click on “Open”.

The following will now be displayed:

v3702ImportWizard3

Click on “Map Fields…”

v3702ImportWizard4 - Copy

Because your file had column headings, select “Ignore First Row (Column Names)”.

Above each column select the corresponding WinSMS fields.

Note that the “Acc Number” field is an additional field that can be created by going to File > Preferences > Contact Additional Info.

Once you have matched the fields click on OK then Next.

v3702ImportWizard5

At this stage, if you want the imported contacts to belong to a group, you can either select an existing group or create a new group. Once you are done click on Next.

v3702ImportWizard6

Click on Next to import the contacts.

v3702ImportWizard7

Once the import process is finished, click on Finish.

v3702AfterImport

Home | RegisterKnowledge Base | Affiliates | Blog | Privacy | TermsAbout Us | Contact Us

Copyright © WinSMS International LLC - All Rights Reserved

WinSMS South Africa