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…”

import5

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

import6

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

import7

The following will now be displayed:

import8

Click on “Map Fields…”

import9

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. Click here to watch a viewlet on how to create additional fields.

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

import10

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.

import11

Click on Next to import the contacts.

import12

Once the import process is finished, click on Finish.

import13

 

Share This