How To Convert Facebook Uid To Facebook Email With Excel, Facebook Uid To Email Converter

Currently, there are many ways to help individuals or businesses reach Facebook users, in which the most common way is to use Facebook UID. The following article will introduce to you how to convert Facebook UID to Facebook Email by Excel so you can easily reach customers.

Bạn đang xem: How to convert facebook uid to facebook email with excel

With its continuous development, Facebook entails a lot of benefits for businesses, Facebook users for business purposes with a huge customer base on Facebook. However, not everyone knows how to approach this huge amount of customer resource. So Facebook UID what? Facebook Email what? How can that be convert Facebook UID to Facebook Email by Excel?

How to convert Facebook UID to Facebook Email with Excel

There are many softwares and tools that can help us get a person’s Facebook UID, most of which are quite expensive paid software. The following article friend.com.vn will introduce to you a free tool to perform transfer Facebook UID to Facebook Email by Excel. Please follow up.

HOW TO MOVE FACEBOOK UID TO FACEBOOK EMAIL BY EXCEL

First we will find out what Facebook UID and Facebook Email are first.

– Facebook UID: When you create a Facebook account, you will be assigned a default number to identify your account called FacebookUID. Facebook UID will not have all personal information about your account such as registered phone number, email, name, year of birth … see Facebook id here

This sequence of numbers is the number right behind on your Facebook link.

Also, if your Facebook link has been named with a certain number or letter, you can check your Facebook UID by pointing to your Avatar and see the link below. Facebook UID’s is going to be the fb_id number.

friend.com.vn with the username everything behind the dash of “facebook.com/” on your profile.

Example: I have a Facebook address, friend.com.vn/taimienphi.vn, my email address will be friend.com.vn. Very simple, right.

Xem thêm: Boki: Hd Videos Downloader For Facebook Hd Video Downloader Online

Step 1: You can download the Seotools tool to your computer Here: Download SeoTools for Excel

Step 2: After downloading, you proceed to install the file

How to convert UID to Email format

Step 3: You proceed to install normally. After successful installation, an Excel window will be opened, you will see the SeoTools tab on the Menu bar.

Instructions to convert UID to facebook email and vice versa

Step 4: Because Facebook UIDs are integers, you need to format the column containing Facebook UID as an integer without decimals. You choose column A, choose Format Cells. In the Format Cells dialog box, select the tab Number, in Decimas places set the value to 0.

How to Convert Facebook UID to Facebook Email Using Excel

Step 5: You enter the Facebook UID that you already have in column A.

Step 6: You enter the following command line in cell B4: = “http://graph.facebook.com/” & A4. This command line will take the UID of facebook into the URL form with the header friend.com.vn/

You proceed to copy the formula down to the lines below to complete the cells below

Step 7: You enter the following command line in cell C4: = JsonPathOnUrl (B4, “username”). This command line will have the function of getting the facebook user’s username from the UID

You proceed to copy the formula down to the lines below to complete the cells below

Step 8: Finally, we will get Facebook Email by entering the following command: = C4 & “ friend.com.vn”

Guide to convert Facebook UID to Facebook Email by Excel fastest

You proceed to copy the formula down to the lines below to complete the cells below

So you can get it Facebook Email of Facebook users. The article on how to convert Facebook UID to Facebook Email by Excel above detailed instructions on how to get Facebook Email from Facebook UID. If you use Facebook for business purposes, then you will be able to easily send product information to Facebook users’ mailboxes so you can promote your products directly to users. If during the process of implementation, you have any difficulties, do not hesitate to comment that the technical team of friend.com.vn will assist you.

.