Import contacts from Excel to Android

Import contacts from Excel to Android

Import contacts from Excel to Android

Some of the information most valuable data that we usually have inside our mobile devicesapart from the photos, files and music; are usually the telephone contact data. Both, personal contacts (family, friends and neighbors), as well as those of study and work, tend to have great value for many of us. Above all, because we are no longer used to saving them (backing them up) offline, that is, on paper.

But, possibly many do, they take the precaution of saving them periodically in office spreadsheet files, either, en líneaas out of line, En a spreadsheet program, like the known Microsoft Windows Excel. For this reason, it becomes useful and important to know how we can “Import contacts from an Excel file to an Android mobile”, to restore said information as soon as possible. As we will see below.

Block pop-ups on Android

Block pop-ups on Android

And, before starting this post on how “Import contacts from an Excel file to an Android mobile”, we recommend exploring later, other android related content.

Such as:

Block pop-ups on Android
Related article:
Block pop-ups on Android
block all calls android
Related article:
How to block all calls on Android step by step

Tutorial on importing contacts from Excel to Android

Tutorial on importing contacts from Excel to Android

Steps to follow to import contacts from an Excel to an Android mobile

Step 1 – Run spreadsheet software

As a first step we must open our spreadsheet app, which should be Excel if we use Windows. However, without any problem we could use any other equivalent such as macOS numbers, and GNU/Linux calc. Also, you can use other spreadsheet programs, free or paid, free or private, and even online tools, such as, Google Sheets (Spreadsheet) or others.

And in one Blank sheet of said software, we must insert the following content in the aforementioned way:

  • The first line for the headers: Where the cells must have the following contents, Cell A1, content FirstName; Cell B1, content LastName; Cell C1, Phone content; and Cell D1, Email content.
  • following lines: In each following lower line, the Name(s) must be inserted consecutively; the Surname(s); the telephone number; and Email.

As shown below:

Spreadsheet

  • Save the file in CSV format: Finally, and once we have all the content of our contacts ready, we must save it in a .csv format file. To do this, we must go to the “Menu bar”, choose the “File option”, and then press the “Save as…” option. In the new pop-up window, we must click on the “Save as type” bar, and select the CSV UTF-8 (comma delimited) (* .csv) option from said drop-down menu. And of course, indicating in which folder we want to save it, for example, Downloads, Documents or Desktop.

Step 2 – Upload the CSV file to Google Contacts web

Once we have saved and ready the .csv file, we must go to the website of Google Contacts, logging in with our Google user account associated with Android mobile where we want import the contacts from the file.

Google Contacts - Screenshot 1

Yeah, inside the Google Contacts website, we press the Import option, located at the bottom of the left side column. Once this is done, a pop-up window will be shown to us, in which we will have to press the select file button. Then, search and select our CSV file created and saved previously. As shown below.

Google Contacts - Screenshot 2

Google Contacts - Screenshot 3

Once this step is done, the system will show us the previous popup, indicating the name of the selected file. Therefore, the next logical step is to press the import button. Once this is done, and if we have correctly elaborated our CSV file, the web will show us all the imported contacts of the same. As shown in the image below.

Google Contacts - Screenshot 4

Google Contacts - Screenshot 4

Step 3 – Verify the import of the contacts on the mobile

To finish, we must obviously validate that the contacts imported through the Google Contacts website. To do this, we must unlock our mobile, and open the Contacts app and search among our current contacts, the new imported ones. As shown in the image below.

Google Contacts - Screenshot 5

Ringtones
Related article:
How to change the ringtone on Android
change letter android
Related article:
How to change the font on Android very easily

post summary

Summary

In short, this android walkthrough It makes it clear to us again, along with many other previous ones, how easy it is to execute certain actions, common or not common, on our mobile devices. And specifically about power “Import contacts from an Excel file to an Android mobile”, quickly and efficiently, without major problems or difficulties, it is clear that it is totally feasible and possible with a few simple tips and steps.

And remember that, if you liked the content, leave us your comment and share it with others. Also, do not forget to visit our website «Android Guías» to explore more content about Android.


Leave a Comment

Your email address will not be published. Required fields are marked with *

*

*

  1. Responsible for the data: Miguel Ángel Gatón
  2. Purpose of the data: Control SPAM, comment management.
  3. Legitimation: Your consent
  4. Communication of the data: The data will not be communicated to third parties except by legal obligation.
  5. Data storage: Database hosted by Occentus Networks (EU)
  6. Rights: At any time you can limit, recover and delete your information.