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 Visual Basic 2017 Offline

This page offers a way to avoid the long and error-prone online installation of Visual Studio which is a massive package. Our interest is limited to Visual Basic and ASP.Net. One can, later, add other tools such as C# and C++. In this page, "VS" refers to Visual Studio. Installing Visual Basic 2017 Offline is not a simple process because Visual Basic 2017 is a part of Visual Studio 2017 that comes as one huge package (up to 35GB) in three versions: Community Edition (Free) Professional Edition (intended for a few people) Enterprise (intended for larger software teams)  Visual Studio by default uses a web-based install process that starts by downloading one of three the bootstrapper package from the VS download page . When you run the bootstraper, it will initiate download of the Visual Studio components that may be up to 35GB in size and takes a very long time to complete. The purpose of this page is to explain how to avoid the headache of this long and tedious ...

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!