How Do I Upload a Spreadsheet of Contact Information to My Apple Contacts

Download Article

Download Article

If your contacts are stored in an Excel CSV file, it'southward 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 proper name, accost, phone number, and other fields import right. 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.

1. ane

   Navigate to https://contacts.google.com in a web browser. This is the website where you tin can manage your contacts over the internet. Hither you lot tin can import and export contact sheets that can be used in Excel.

2. ii

   Make sure you are logged in to the right account. If you are not signed in to Google, click Sign In in the upper-correct corner and sign in using the email address and password associated with the Google business relationship y'all use on your Android phone.

   • If you are signed in to a different business relationship, click your profile icon in the upper-correct corner and click Add another business relationship. Then sign in to the Google account yous use with your Android smartphone. Click the contour icon in the upper-right corner and click whichever account you want to sign in to.

   Advertisement

3. 3

   Click a contact. It doesn't matter which contact y'all click, as you can use any ane of them to create a CSV file for Excel.

4. 4

   Click ⋮ . It's the button with three vertical dots. It's below the contact'south name at the top and to the left of the blueish "Edit" button. This displays a popular-up carte.

5. 5

   Click Export . Information technology's the 2d option in the pop-upwards menu. It'due south next to an icon that resembles a cloud with an arrow pointing down.

6. 6

   Select "Google CSV" and click Export . Click the radio pick next to "Google CSV". It'south the beginning choice in the menu. Then click Export in the lower-right corner of the popular-up. This exports the contact as a CSV file in Google's format.

7. seven

   Open the CSV file in Excel. By default, downloaded files can exist found in your Downloads folder. If Excel is your default spreadsheet awarding, you tin can just double-click the file to open it in Excel. If this does not open up the file in Excel, right-click the file, hover over Open with, so click Excel.

8. 8

   Enter all your contact information into the CSV canvas. The offset row at the top contains all the labels. Enter all the correct data in the column below the characterization at the top. Contact names become in the "A" column. Contact telephone numbers go in the "AE" column. You tin can enter whatsoever other information you have beneath the correct label at the top, or go out them blank.

   • If you lot don't want to go along the original contact info that yous exported from Google Contacts, you can delete information technology.
   • If y'all have a list of contacts from another Excel spreadsheet, you tin can copy and paste them into the correct cavalcade in the Google CSV document.

9. 9

   Relieve the CSV file. One time y'all have entered all the contact information you lot desire 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.

   • Alternatively, you can click File in the upper-left corner, followed by Save as. So enter a proper name for the CSV file and click Salve.

10. 10

    Click Yes to keep the file in CSV format. Excel asks if you desire to go on the file in CSV format and warns that yous may lose some data in this format. Click Yeah to continue.

    Advertisement

1. ane

   Navigate to https://contacts.google.com/ in a spider web browser. This is the website where you can manage your contacts over the internet. Here you tin import and export contact sheets.

2. ii

   Make certain you lot are logged in to the right business relationship. If you are not signed in to Google, click Sign In in the upper-right corner and sign in using the electronic mail address and password associated with the Google business relationship yous use on your Android phone.

   • If you lot are signed in to a different business relationship, click your profile icon in the upper-right corner and click Add another account. Then sign in to the Google account you use with your Android smartphone.

3. 3

   Click Import . Information technology's in the menu to the left side. It's next to an icon that resembles a tray with an arrow pointing upwards.

4. 4

   Click Select File . It's the blue button in the pop-upwards that appears when you click "Import."

5. 5

   Select your CSV file and click Open up . Navigate to the Google CSV file that you made in Excel. Double-click the file to select it so click Open in the lower-correct corner.

6. vi

   Click Import . This imports all the contacts from the CSV file into your Google account. You should see your contacts outset to populate momentarily.^[1]

   Advertisement

1. 1

   Open the Settings app ((android|settings}} on your Android phone. To do and then, swipe down from the top of the screen to brandish the Quick Access card. And then tap the icon that resembles a gear in the upper-right corner.

   • Alternatively, you can tap the icon that resembles a gear in the Apps menu.

2. 2

   Tap Accounts . This displays all accounts you lot are signed into on your Android device. Information technology'due south on the main menu of most stock Android devices. Depending on your telephone'due south make and model, this may exist found under "Accounts and backup" or "Users and Accounts" or something like.

3. 3

   Tap the Google account you imported the CSV file to. Information technology'll exist listed by e-mail accost. It has an icon that resembles a green, red, yellow, and blue "G" adjacent to it.

4. 4

   Tap Sync Account . It's the second choice in the account carte.

5. v

   Ensure "Contacts" is turned on . Curl through the list of items in the Sync Account menu. Make sure the toggle switch next to "Contacts" is turned on.

6. 6

   Tap ⋮ . Information technology'due south the icon with iii vertical dots in the upper-correct corner. This displays the More menu.

7. seven

   Tap Sync Now . This syncs your Google account with your Android phone and imports all your new contacts into your Android telephone.

   • If you don't see "Sync At present" in the More carte, y'all may accept Auto-sync turned on, and a sync may already be in progress.

   Advert

Add together New Question

• Question

  How to send Whatsapp bulletin without saving contacts?

  

  ajeesh sj

  Community Answer

  There are some third party applications which help to practise this. Some other way is through the dialpad - from the options - ship message - Whatsapp.

• Question

  How to import contacts from a CSV, Excel, or vCard file?

  

  benjamin joins

  Customs Answer

  Softaken Excel to VCF Converter program is a powerful tool for converting Excel contacts to vCard files. From an Excel spreadsheet, the programme 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 parcel also has many features for converting Excel spreadsheet contacts to vCard or VCF format.

Ask a Question

200 characters left

Include your electronic mail address to get a message when this question is answered.

Submit

Advertisement

Video

• 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 shop the contacts on your phone itself.

Advertisement

Nigh This Commodity

Commodity Summary Ten

1. Log in to https://contacts.google.com/ and click a contact.
2. Click the icon with three dots (⋮) beneath the contact'due south proper noun and click Export.
iii. Export the file as a "Google CSV" file.
4. Open up the Google CSV file in Excel and enter all your contact data in the right 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.
ix. Sync your Google account in the Settings menu on your Android phone.

Did this summary aid you?

Thanks to all authors for creating a page that has been read 483,817 times.

Is this article up to date?

guzmanthearegaven.blogspot.com

Source: https://www.wikihow.com/Import-Contacts-from-Excel-to-an-Android-Phone

Share this post