Format and Import Contacts from Excel to an Android

PDF download Download Article
Export a CSV file from Excel and import it into Google Contacts
PDF download Download Article

If your contacts are stored in an Excel CSV file, it's easy to import them into your Android. The trick is to make sure your CSV file is formatted using Google's standard formatting, which ensures that the name, address, phone number, and other fields are imported correctly. This wikiHow article will walk you through formatting a CSV file properly for your Android and show you how to import the file using Google Contacts.

Quick Steps

  1. Save your contacts as a CSV file.
  2. Go to contacts.google.com in a browser.
  3. Click Import and select the CSV file.
  4. Open your Android's Settings.
  5. Go to Google > All Services > Google Contacts sync > Status .
  6. Enable syncing and tap the Refresh icon.
Part 1
Part 1 of 3:

Creating a Contact Sheet in Excel

PDF download Download Article
  1. Navigate to contacts.google.com in a web browser. This is the website where you can manage your contacts over the internet. Here you can import and export contact sheets that can be used in Excel .
    • Make sure you are logged in to your Google account. If you are not, click Sign In in the upper-right corner. Select your Google Account, or click Add another account and sign in with the username and password associated with your Google account. [1]
  2. 2
    Export a contact as a CSV file. This can be any contact you wish. This will create a template you can use to format your contacts in Excel so that they can be imported into your Google Contacts. Use the following steps to export a contact as a CSV file: [2]
    • Click a contact.
    • Click the icon with three dots (â‹®) to the right of a contact.
    • Click Export .
    • Select Google CSV .
    • Click Export .
    Advertisement
  3. Open the CSV file in Excel. By default, downloaded files can be found in your Downloads folder. If Excel is your default spreadsheet application, you can simply double-click the file to open it in Excel. If this does not open the file in Excel, right-click the file, hover over Open with, and then click Excel . [3]
  4. The first row at the top contains all the labels. Enter all the correct information in the column below the label at the top. Contact names go in the "A" column. Contact phone numbers go in the "AE" column. You can enter any other information you have below the correct label at the top, or leave them blank.
    • If you don't want to keep the original contact info that you exported from Google Contacts, you can delete it.
    • If you have a list of contacts from another Excel spreadsheet, you can copy and paste them into the correct column in the Google CSV document.
  5. Once you have entered all the contact information you want to import to your Android device, click the icon that resembles a floppy disk in the upper-left corner. This saves the CSV file that can be imported into Google and used by your Android. [4]
    • Alternatively, if you already have a spreadsheet that is in the correct format, you can save it as a CSV file. To do so, click File in the upper-left corner, followed by Save as . Select “.csv (comma delineated)” in the drop-down menu next to “Save as Type.” Then enter a name for the CSV file and click Save .
  6. Excel asks if you want to keep the file in CSV format and warns that you may lose some information in this format. Click Yes to continue.
    7. Advertisement
Part 2
Part 2 of 3:

Importing a CSV File into Google Contacts

PDF download Download Article
  1. Navigate to contacts.google.com in a web browser. This is the website where you can manage your contacts over the internet. Here you can import and export contact sheets.
    • Make sure you are logged in to your Google account. If you are not, click Sign In in the upper-right corner. Select your Google Account, or click Add another account and sign in with the username and password associated with your Google account. [5]
  2. It's in the menu panel to the left. It's next to an icon that resembles a tray with an arrow pointing up.
  3. It's the blue button in the pop-up that appears when you click "Import."
  4. Navigate to the Google CSV file that you made in Excel. Double-click the file to select it and then click Open in the lower-right corner.
  5. This imports all the contacts from the CSV file into your Google account. You should see your contacts start to populate momentarily.
    6. Advertisement
Part 3
Part 3 of 3:

Syncing Your Contacts with Your Android

PDF download Download Article
  1. To do so, swipe down from the top of the screen to display the Quick Access menu. Then tap the icon that resembles a gear in the upper-right corner. [6]
    • Alternatively, you can tap the icon that resembles a gear in the Apps menu.
  2. 2
    Tap Google . This displays your Google account settings.
    • On some devices, you may need to tap Account or Account Services instead.
  3. 3
    Tap the All services tab. It’s the second tab at the top of the page. This displays the Settings menu for all Google services.
  4. 4
    Tap Google Contacts sync . It’s a little way down the menu. It’s below the “Backup & restore” header.
  5. 5
    Tap Status . This opens the menu that allows you to turn on Google Contacts sync as well as instantly sync your contacts.
  6. 6
    Turn on Google Contacts sync (optional). If you want to refresh your contacts with your Google account automatically, tap the toggle switch next to “Google Contacts sync.” This will sync your Contacts with your Android device and your Google account automatically at regular intervals.
  7. 7
    Tap the Refresh icon. It’s the icon that resembles a circle with an arrow on the end. It’s to the right of “Status.” This syncs your contacts instantly.
    8. Advertisement

Community Q&A

Search
Add New Question
  • Question
    How do I send a Whatsapp message without saving contacts?
    ajeesh sj
    Community Answer
    There are some third party applications which help to do this. Another way is through the dialpad - from the options - send message - Whatsapp.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 20 Helpful 45
  • Question
    How to import contacts from a CSV, Excel, or vCard file?
    benjamin joins
    Community Answer
    Softaken Excel to VCF Converter program is a powerful tool for converting Excel contacts to vCard files. From an Excel spreadsheet, the program extracts both official and commercial contacts and stores them in VCF/vCard format. Overall, the utility has a great deal of control in terms of allowing a customer to strengthen a business relationship. The package also has many features for converting Excel spreadsheet contacts to vCard or VCF format.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 1 Helpful 4
  • Question
    I tried to enter the phone number in AE, but it showed in the email. Where do I enter the phone number?
    Peter Rafai
    Community Answer
    To update your Samsung account with a phone number, go to Settings > Accounts > Samsung Account on your device. Log in, tap Profile Info, and look for the phone number field to update it. If it’s not available, try updating it through the Samsung Account Website. Alternatively, contact Samsung Support for assistance.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 1 Helpful 7
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      • Uploading a CSV file to your Google Contacts page will synchronize the contacts with any items using that Google Account, including your Android. You shouldn't have to import contacts directly from a file to your Android unless you want to store the contacts on your phone itself.
        Thanks
        Helpful 1 Not Helpful 1
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      You Might Also Like

      How to
      Add Contacts to Gmail Using a CSV File
      How to
      Edit, Delete, and Sync Your Gmail Contacts
      How to
      Import Contacts to Outlook from Excel
      2 Easy Ways to Back Up Contacts on an Android
      How to
      Export Contacts on Android
      7 Simple Steps to Export Your Contacts in Gmail
      How to
      Restore Google Contacts
      How to
      Download Google Contacts on Android
      3 Simple Ways to Save a New Contact on Android
      How to
      Find and Manage Your Address Book in Gmail
      Easy Guide to Importing Contacts to WhatsApp on Android
      5 Easy Ways to Add New Contacts to Gmail
      How to
      Sync Contacts to Gmail
      How to
      Find and Access Your Contacts List in Gmail
      Advertisement

      References

      1. ↑ https://support.google.com/accounts/answer/12849458?hl=en
      2. ↑ https://support.google.com/contacts/answer/7199294
      3. ↑ https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba
      4. ↑ https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba
      5. ↑ https://support.google.com/accounts/answer/12849458?hl=en https://support.google.com/accounts/answer/12849458
      6. ↑ https://support.google.com/contacts/answer/2753077

      About This Article

      Article Summary X

      1. Log in to https://contacts.google.com/ and click a contact.
      2. Click the icon with three dots (â‹®) below the contact's name and click Export .
      3. Export the file as a "Google CSV" file.
      4. Open the Google CSV file in Excel and enter all your contact information in the correct column.
      5. Save the file as a CSV file.
      7. Log back in to https://contacts.google.com/ and click Import in the menu to the left.
      8. Import the CSV file you saved from Excel.
      9. Sync your Google account in the Settings menu on your Android phone.

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 776,988 times.

      Reader Success Stories

      • Mrinal HL

        Jan 5, 2023

        "This worked like a charm, thanks a ton. Just took couple of minutes and worked exactly like explained. Fantastic!"
        Rated this article:
      More reader stories Hide reader stories
      Share your story

      Is this article up to date?

      Advertisement