Skip to main content

Import .csv Contacts into Android

The problem is simple: You have an Android phone that is new or reset to wipe contacts or phone book. Your phone book or contacts are in a .CSV file or Excel and you want to import into the Android phone.

All kinds of strange and convoluted solutions are given out there but the one that worked for me on several occasions is a tool called CSV to VCard. It is free software that accepts .CSVfiles, allows you to make adjustments, then converts into VCard (.vcf) format. You can copy the .vcf onto your phone and then open that file via Android to import into Android Contacts.

The process is shown graphically below:

  1. Launch "CSV to VCard":
2. Open .CSV File:

3. Edit Fields in VCard (Right side is editable by clicking "select" and scrolling the list to select best filed name):

4. Edit the export file name (It is a .vcf) and location:

5. Click "Convert" to convert and save. You get the following message in about 1/2 a second...:

6. Copy the .vcf file to the phone's SD card or internal storage:

 You can now open the .vcf file using the Android file File Manage by browsing to the folder in which you saved the .vcf and tapping it to open the file.

I wish you success.

Buy someone a chocolate to cerebrate and remember, the Messiah is coming in this generation!


Popular posts from this blog

How to Install RIOT Plugin for GIMP

How to Install RIOT Plugin for GIMP:: Since this article was first written a stand-alone version of RIOT has been made available Download the plugin from the download link titled "RIOT as plug-in for other applications"   Launch the Riot-plugin.exe file by double clicking.The installer installs all the files including Riot.exe, Riot.dll, and FreeImage.dll in the location where you installed GIMP  If GIMP is open, close it and re-launch it.To optimise an image, open it then save with menu File->Save for web with RIOT  You can set the target file size by selecting "Compress to size" button  on bottom right corner of optimised image pane and providing the size in kilobytes. Alternatively you can use a slider provided to allow you to change the quality while showing you a preview of the resulting image.


How to Install Packet Tracer 6.0.1 for Linux

This article is intended to help me remember the installation process for Cisco Packet Tracer 6 details of which seems to be hard to come by on the web.

1. Log in in to your Cisco Netspace account. Yes, you need to be logged in.
2. The "Download PT 6.0.1" link on is on the NetSpace home page.
3. Click this "Cisco Packet Tracer" link shown below the folder icon as shown in the figure below:

4. Select Cisco Packet Tracer 6.0.1
5. Select download location.
6. After completion of download, use your file manager to open that folder and rename the file to something such as "CPT6". It is a shell script so no file extension is required.
7. Change the file permissions to executable using command: sudo chmod 777 CPT6from a terminal window opened in the download directory. This assumes your downloaded file is renamed CPT6
8. Launch the file with command: ./CPT6 from the terminal window. You will get the message:

Self extracting archive...

Welcome to Packet Tracer 6.0…

Connecting USB 3G Modem to Safaricom in Linux Mint

This particular modem is a ZTE HSUPA MF637U modem. Click on images to see enlarged view. Let's get started:
OS is Linux Mint version 15. Yours may be older or newer.Plug in the modem to a free USB port and check that it recognises the modem as a drive in the File Manager whose icon is shown below third from left and the File Manager view is also shown with the modem listed as the "MODEM-SDSK" drive: Fig. 1. Linux Mint Desktop Panel

Fig 2. Linux Mint File Manager view showing listed drives at left and Application Manu at top. Click on image to see enlarged view.

3. Go to the Applications Menu shown in Fig. 2 and select Settings>Network Connections

Fig. 3. Network Connections dialogue. Click on image to see enlarged view.

4.  Select Add > Mobile Broadband then click  "Create"
5. Follow the wizard to select the device, country, billing plan, service provider and deafult settings.

Fig. 4. Safaricom default settings in Linux Mint. Click on image to see enlar…