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!




Comments

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   http://luci.criosweb.ro/riot/download/   Select 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. Enjoy .       ...

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 CPT6 from 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... We...

XUBUNTU PANEL AND WINDOW BUTTONS HAVE DISAPEARED

 XUBUNTU PANELS Xubuntu can be quite troublesome when you shutdown and restart. Desktop panels may disappear as well as window minimize/maximise/close buttons.  The panel is equivalent to the Windows 10 Start menu that provides access to applications. TO MAKE THE PANEL REAPPEAR Open a terminal by right-clicking on the desktop then enter the following: xfwm4 --replace TO RECOVER THE PANEL Open a terminal by right-clicking on the desktop then enter the following: xfCE-panel --restart  That is all . As we say in Kiswahili: Mambo kwisha!