You might have an Excel file with all your vital contact information. It is because Microsoft Excel makes keeping contact information and any other data so easy. It cannot be done straight though if you wish to import phone numbers from Excel to Android.
First you have to make sure the Excel file—should it be in XLS or XLSX format—is converted into a CSV file in Google standard CSV style. This is so as we can upload the CSV file into the Google account and subsequently sync them with your Android phone.
Use an automated program from DataVare to convert Excel contacts into vCard format if you need a quick fix but do not want to follow all these procedures. Your Android smartphone can then straight import the vCard file.
Free Method – Import phone numbers from Excel to Android using Google Account
We first require a CSV file with Google’s usual style. Should none exist, you can follow these guidelines to acquire one:
1. Get a CSV file formatted in Google Style
- Starting the browser, log in using your Google account. Open the Contacts tool after login.
- Select any one contact and select Export from the left pane.
- Select Google CSV as your exporting choice now and click Export.
- These processes will download a Google-formatted CSV file.
- You may now copy every contact from the current Excel file from this file and paste it into a downloaded Google prepared CSV file.
Make sure you put contacts in the correct column even as you copy the contacts from the Excel file. There are all the labels in the top row of the file. You can cross-check the labels from that row and copy the contacts columns as such.
2. Load a CSV file into Google Contacts
We must import the Google formatted CSV into Google contacts next to import phone numbers from Excel to Android. For the same, you can follow the guidelines described here:
- Open Google Contacts by visiting – https ://contacts.google.com/ and login into the account you wish to import these contacts from.
- Click the Import option found in the left pane now to choose the CSV file.
- After clicking the Select File option, find the CSV file on your machine.
- Click the Import button at last to be halfway between importing phone numbers from Excel to Android.
3. Sync Contacts from Google with Your Android Smartphone
- Tap on the Accounts option (there might also be a User’s and Accounts a chance based on your smartphone) after opening the Settings program on your smartphone.
- These are a list of accounts set on your Android phone. Using the Google account you imported the CSV file from, tap here.
- Look for the Contacts choice on the list and make sure it is turned on.
- Click on the three vertical dots in the upper right corner then choose Sync now.
At last, Excel to Android will import all of your phone numbers. If you wish not to follow all these procedures, nevertheless, you can also make advantage of the automated tool below. This will enable you to translate Excel files into vCard format fit for straight Android phone imports.
Professional Method – Import Contacts from Excel to Android –
We offer a great alternative for you if you need a quick fix and find the indicated manual approach to be a bit tiresing. The ideal answer for DataVare Address Book Converter Converter. This program will enable you to effortlessly import the Excel files into vCard format straight into Android phones. Many of the utility’s given features additionally make this a popular choice for different consumers.
The program will allow you map Excel columns with corresponding vCard fields. You also have the choice to produce a single vCard for every contact or a single vCard for all the contacts. Your needs will determine the vCard version—2.1, 3.0, or 4.0. One can also let empty email addresses to be imported.
Now begins the process via the vCard file importing phone numbers from Excel to Android
First, bring the vCard file from your system to your Android smartphone.
Connecting your smartphone with the system will let you copy the vCard file to the storage of your phone.
- On your phone, launch Settings and the Contacts application now.
- First tap the Import from file option then Fix & manage option found at the bottom.
- Decide on an account to save the contacts on.
- At last find the VCF file and decide which one to import.
Using the manual approach can make importing phone numbers from Excel to Android difficult and time-consuming. Using the manual approach is entirely free if you so want. On the other hand, you can attempt the utility provided in this write-up if you require an automated solution and want to avoid all those procedures.
