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

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

Android Applications with Intellij IDEA - 1

This article applies to Android applications in Windows using IntelliJ IDEA development tools. Windows 7 was used in this example but the explanation will work for other recent versions of Windows. It is quite a task learning how to use mobile application development tools. This page describes how to digitally sign your .apk file which is the  Android application package file. In short, your Android program file. Once you have created an APK file to launch it, simply copy to your device and use the Android file manager to install it. The picture below shows the digital signature keystore file, the unsigned APK file and the signed APK file. The procedure of signing the APK file is quite straighforward but first you must ensure your Java JDK is properly installed and that the Java tools are accessible on your commandline (Windows command console - what used to be called the DOS window). Most important is that your PATH environmental variable (In Windows 7 find this at: Control