Importing contacts from Excel
WinSMS - Importing contacts from Excel
Clean up your list:
Open the Excel spreadsheet that contains your contacts and do the following to clean your list:
• Check that all the contacts have valid cell numbers.
• Delete any contacts that don't have cell numbers.
• Remove any empty rows.
• Remove all commas (,) from the spreadsheet.
Note that if the above guidelines are not followed, you will probably encounter errors when trying to import.
[pic]
In this 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.
[pic]
When you click on the "Save" button, the following dialog box will prompt you, click on "Yes".
[pic]
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".
[pic]
Importing the CSV file into WinSMS: Open WinSMS - click on "File" then "Import..."
[pic]
Choose "Contacts from text files" and click on Next.
[pic]
Click on "Select File..." - choose the CSV file and click on Open:
[pic]
The following will now be displayed:
[pic]
Click on "Map Fields..."
[pic]
Because your file had column headings, select "Ignore First Row (Column Names)".
Above each column select the corresponding WinSMS fields.
Once you have matched the fields click on OK then Next.
[pic]
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.
[pic]
Click on Next to import the contacts.
[pic]
Once the import process is finished, click on Finish.
[pic]
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- importing data from pdf to excel
- get contacts from lost phone
- retrieve contacts from old phone
- retrieve iphone contacts from computer
- access iphone contacts from computer
- retrieve contacts from android phone
- download contacts from android phone
- export contacts from outlook 2010
- importing contacts into outlook csv
- how to export contacts from outlook online
- saving contacts from outlook
- export contacts from outlook csv