How to add WhatsApp friends quickly with Google account

If you are still one by one customer contact information entered into the address book plus customer What's App, then this article please do not miss it !

All you need is a Google Gmail account, and an Apple mobile phone, and you're done in 7 seconds (provided you have your customer data ready, of course). Google Contacts is fast in that it can export vCard (for iOS Contacts) so that Apple phone users can directly store and import .vcf files directly into Contacts and sync with WhatsApp.

It only takes 4 steps:

1⃣Record customer's mobile phone in comma separated values table (Google CSV) (bulk change display name + phone)

2⃣Import to Google Contacts and then export to vCard (for iOS Contacts).

3⃣Download .vcf file to copy to iPhone address book storage (groupable)

4⃣Instant sync to open whatsapp to tease customers

(prefix indicating ordinal number, e.g. first, number two etc)1⃣Step:

The main point is how to properly batch record customer information in a comma-separated value (.CSV) form:

1. Enter a customer's information into Google Contacts, and then export a comma-separated value (.CSV) table as a template for entering the customer's information that needs to be imported (or see the attached template contacts.csv).

百度云盘下载链接: https://pan.baidu.com/s/1Lp5jHVj5dJ_UO6uWvohZww 提取码: ikex

To add a customer to WhatsApp, you only need to edit the information in the Name and Phone 1 - Value columns. (If you also use Gmail and Ring Chat, please fill in as much information as possible.)

1. About name: Mainly for distinguishing customers, grading and labelling. ( Given Name,Family Name Google will automatically recognise can directly fill in the full name so faster )

For example, an enquiry from Ali can be labelled as ALI-A.–Bill Gates

Select the table with the mouse, right mouse button to find "set cell formatting" and click.

Under the "Numbers" tab of the pop-up menu, click "Customise" at the bottom.

Enter "ALI-A-"@ in the G/Common Format text box and click "OK".

After clicking OK, all data will show the prefix added (as shown in the figure).

If the prefix to be added is purely numeric, enter "XXX "0 in the type.

If the prefix to be added is text, enter "XXX"@ in the type.

Do not understand the self Tuo Niang fumble a excel practical exercises

Portal: https://jingyan.baidu.com/article/851fbc379c1b113e1f15ab22.html

https://zhidao.baidu.com/question/548721590.html?qbl=relate_question_1&word=excel%20%CC%ED%BC%D3%D7%D6%B7%FB

2. Pay attention to the format of Phone 1 - Value mobile phone numbers.

For international phone numbers, do not use any prefix "0" or end codes. Start with a + sign, enter the country code, and then the phone number.

For example, dialling a US phone number +1 XXX-XXX-XXXX

When entering phone information, you can directly fill in the 10-digit phone number XXX-XXX-XXXX in the form, and then batch operation of the phone number to change the phone number before +1 area code letters and separators.

First of all, select the table with the mouse, the right mouse button to find "set cell formatting" and click.

Under the "Numbers" tab of the pop-up menu, click "Customise" at the bottom.

Change the G/Common Format to the customary "3-3-4" segmented display. Enter "+1 000-000-0000" in the text box and click "OK".

At this point, view the table phone number has been set up in accordance with the "+1 3-4-4" segmentation effect.

For other countries, you can follow the above way to set the number to the customary phone number segmentation of each country, "+ 49 333-4444-4444", "333-333-55555", " 4444-4444-333" and so on.

If you don't know what you're looking for, please feel free to use the portal:

https://zhidao.baidu.com/question/1946120814970544548.html?qbl=relate_question_0&word=excel%B1%ED%B8%F1%20%B5%E7%BB%B0%BA%C5%C2%EB

(prefix indicating ordinal number, e.g. first, number two etc)2⃣Step:

Once you've sorted out your name and phone number just log in to your Google account - Contacts - Import to Google Contacts!

Then export the vCard (for iOS contacts) contacts.vcf file

(prefix indicating ordinal number, e.g. first, number two etc)3⃣Step:

Download the .vcf file and send it to your mobile phone, open it with another app - just select copy to address book (can be grouped)

For Mac computers, you can directly click on the downloaded contacts.vcf file to import it to your address book.

(Theoretically, Android mobile phones can also be connected to the data line through a third-party assistant to export the file vCard to the root directory of the mobile phone android, and then open the phone's address book and click on the import can be - I don't have an android mobile phone can't test whether it will be messy, there are android machine partners can try).


(prefix indicating ordinal number, e.g. first, number two etc)4⃣Step:

Open up whatsapp and flirt with your customers!

Above is the fastest way I have done so far to import customer information to WhatsApp, I hope it helps you guys.

This article is from WeChat: Global Foreign Trade Customer Information