Importing contacts from Excel

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. 

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 FilePreferencesContact 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. 

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

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". 

Importing Contacts into WinSMS:

Open WinSMS - click on "File" then "Import..." 

Choose "Contacts from text files" and click on Next. 

Click on "Sel
ect File..." - choose the CSV file and click on Open: 

The following will now be displayed: 

Click on "Map Fields..." 

Because your file had column headings, select "Ignore First Row (Column Names)". Above each column select the corresponding WinSMS fie
lds. 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. 

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.

on Next to import the contacts. 

Once the import process is finished, click on Finish. 

    • Related Articles

    • How to use filters

      Filters allow you to search for certain information in the WinSMS desktop client. WinSMS desktop client - Filters Please make sure you are running the latest version of the WinSMS desktop client. South African users download here. International users ...
    • How to export your database from the WinSMS Desktop Software to WinSMS Mobi

      To export your database from the WinSMS desktop software to WinSMS.Mobi, you would need to open the WinSMS desktop software and also make sure you have logged on. You can log in by clicking on 'Logon' at the top left hand corner of the software and ...
    • How to add international numbers to the WinSMS desktop application

      When adding international contacts to the WinSMS desktop application, you will be able choose the country from a drop down list, this will automatically insert the correct country code in front of the number you are about to enter. If the number for ...
    • How to remove an opt out number from your database in the WinSMS desktop client

      If a recipient replies with certain words or a combination of words we automatically block your WinSMS account from sending to this recipient. Click here for more information on the WinSMS opt-out system. It is a good idea to remove this recipient ...
    • Installing multiple instances of the WinSMS desktop application

      Motivation for having multiple WinSMS installations One reason for considering running multiple installations of WinSMS would be if you need to send messages from one computer using more than one WinSMS account and each account having its own set of ...