How To Extract Phone Numbers From Excel

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 brand certain your CSV file is formatted using Google's standard formatting, which ensures that the name, address, phone number, and other fields import correct. This wikiHow article will walk y'all through formatting a CSV file properly for your Android and show you how to import the file using Google Contacts.

i

Navigate to https://contacts.google.com in a web browser. This is the website where you can manage your contacts over the internet. Here you tin can import and export contact sheets that can exist used in Excel.
2
Brand sure you are logged in to the right account. If you are not signed in to Google, click Sign In in the upper-right corner and sign in using the e-mail address and password associated with the Google account you employ on your Android phone.
- If you lot are signed in to a different account, click your profile icon in the upper-right corner and click Add some other business relationship. So sign in to the Google account you use with your Android smartphone. Click the profile icon in the upper-right corner and click whichever account you want to sign in to.
Advertisement
3

Click a contact. It doesn't matter which contact you lot click, as you can use whatever one of them to create a CSV file for Excel.
4

Click ⋮ . It's the button with three vertical dots. It's below the contact's name at the acme and to the left of the blue "Edit" push button. This displays a pop-up menu.
v

Click Export . It's the 2d option in the pop-up menu. It's next to an icon that resembles a deject with an arrow pointing down.
6

Select "Google CSV" and click Export . Click the radio option adjacent to "Google CSV". Information technology's the first option in the menu. So click Export in the lower-right corner of the pop-up. This exports the contact as a CSV file in Google's format.
7

Open the CSV file in Excel. By default, downloaded files tin can exist found in your Downloads folder. If Excel is your default spreadsheet awarding, you can simply double-click the file to open information technology in Excel. If this does not open up the file in Excel, right-click the file, hover over Open with, and and so click Excel.
8
Enter all your contact information into the CSV sheet. The starting time row at the peak contains all the labels. Enter all the correct information in the column below the label at the top. Contact names go in the "A" cavalcade. Contact phone numbers go in the "AE" column. You can enter whatever other information you lot have beneath the correct label at the top, or leave them blank.
- If you don't want to continue the original contact info that y'all exported from Google Contacts, you tin delete it.
- If you have a list of contacts from some other Excel spreadsheet, you can copy and paste them into the correct column in the Google CSV document.
9
Relieve the CSV file. Once you lot take 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.
- Alternatively, y'all can click File in the upper-left corner, followed by Save equally. And then enter a name for the CSV file and click Save.
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 you may lose some information in this format. Click Aye to continue.

Advertising

1

Navigate to https://contacts.google.com/ in a web browser. This is the website where you tin can manage your contacts over the net. Here you can import and consign contact sheets.
2
Make certain you are logged in to the correct account. If you are non signed in to Google, click Sign In in the upper-right corner and sign in using the e-mail accost and password associated with the Google account you lot apply on your Android phone.
- If you are signed in to a different account, click your profile icon in the upper-right corner and click Add together another account. Then sign in to the Google account you use with your Android smartphone.
3

Click Import . It'due south in the menu to the left side. Information technology's adjacent to an icon that resembles a tray with an arrow pointing up.
four

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

Select your CSV file and click Open . Navigate to the Google CSV file that y'all made in Excel. Double-click the file to select it and then click Open in the lower-correct corner.
6

Click Import . This imports all the contacts from the CSV file into your Google account. You should come across your contacts start to populate momentarily.^[ane]

1
Open the Settings app on your Android phone. To do so, swipe down from the top of the screen to brandish the Quick Access carte du jour. 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

Tap Accounts . This displays all accounts you are signed into on your Android device. It'southward on the main menu of most stock Android devices. Depending on your telephone's brand and model, this may exist establish under "Accounts and fill-in" or "Users and Accounts" or something similar.
three

Tap the Google account you imported the CSV file to. It'll be listed past email address. It has an icon that resembles a green, red, yellow, and bluish "G" next to it.
four

Tap Sync Account . It'southward the second option in the account menu.
five

Ensure "Contacts" is turned on . Scroll through the list of items in the Sync Account menu. Make certain the toggle switch next to "Contacts" is turned on.
half-dozen

Tap ⋮ . Information technology's the icon with iii vertical dots in the upper-right corner. This displays the More menu.
7
Tap Sync Now . This syncs your Google account with your Android telephone and imports all your new contacts into your Android telephone.
- If y'all don't encounter "Sync At present" in the More menu, you may take Auto-sync turned on, and a sync may already exist in progress.

Advertizement

Add New Question

Question

How to send Whatsapp message without saving contacts?

ajeesh sj

Community Respond

At that place are some third party applications which aid to do this. Another 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

Community 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 bargain of control in terms of allowing a client to strengthen a business relationship. The package also has many features for converting Excel spreadsheet contacts to vCard or VCF format.

Ask a Question

200 characters left

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

Submit

Video

Uploading a CSV file to your Google Contacts folio will synchronize the contacts with any items using that Google Account, including your Android. Yous shouldn't accept to import contacts directly from a file to your Android unless you want to shop the contacts on your phone itself.

Advertising

About This Article

Article Summary X

one. 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.
three. Consign the file as a "Google CSV" file.
4. Open the Google CSV file in Excel and enter all your contact data in the correct column.
5. Salvage the file as a CSV file.
7. Log back in to https://contacts.google.com/ and click Import in the carte du jour 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 assistance yous?

Thanks to all authors for creating a page that has been read 519,088 times.

Is this commodity up to date?