Are you also worried about saving too many numbers in your contact list? If you work in a company or you also have a list of contacts in bulk which you want to save in your phone, then you can do this easily. In today’s video, we have brought an easy method for you with the help of which you will be able to save contacts in bulk in your phone’s contacts at once. You will need an Excel sheet for this. So, let’s start the video. Welcome to my channel Tech Gitter Official and please subscribe my channel.
Excel Sheet Data
Here I have an Excel sheet where I have saved the names of customers in one column and their phone numbers in the other column. You can save the list of as many numbers as you want in an Excel sheet and add them to your contacts. Here I have created a list of only 30 contacts.
Here we will see how to move these contacts to your phone’s contact list.
Google Chrome Browser
Open your Google Chrome. After this, you will see the menu button. Click on it. You will see a lot of options here which will also include contact. These are the same contacts that you see on your phone.
After opening the contact you will see a screen like this in which you will see create contact and other contact options. Click on create contact option.
Here you will see the option to create one contact and create multiple contacts. You can save numbers in bulk by creating multiple contacts.
First of all, we will see how we can save one number with create contact and then we will learn to save multiple contacts with its help.
You will see a screen where you have to save your contact. First type the name. If there is any surname then type it. If you want to save the company name or job title, you can. If you have an email address, please enter it. I am adding phone number from Excel sheet. You can also add date of birth.
By adding all this, you can save the number. You will see the number in your contact list like this.
Convert Excel File to CSV File
We need to create an Excel CSV file to save multiple contacts.
First click on multiple contact list option. Here you will see that it imports only CSV file or vCard file. To save contacts from Excel file, you have to convert the Excel file to CSV file.
Click on the previously saved number to create a CSV file. Now click on the three dot button visible on the screen. Here you have to click on export. On clicking on export you will see the option of Google CSV file. Select it and click on export.
You will see an Excel file on the screen which will be in CSV format. Open it. Once the file is opened, your data will appear in a contact form.
You have to copy the name from your old Excel file and paste it into the Excel CSV file. And copy the numbers from the old file and paste it into the CSV file. If you have an email ID, you can copy it also.
Now go to group membership and scroll down to the contacts till where your data is.
Now this file has to be saved and to save the file go to the file option and click on save as option. Go to browse and select the location of the file and save the file.
Add Bulk Contacts on Your Contact List
To save contacts from your Excel file, go to create multiple contacts. Select the same file that you have converted into your CSV file. If you already have a CSV file whose contacts you want to import, then you can do that also.
You will see the name of your file shown on the screen. Click on import. Your data will start importing. After some time, you will see that the contacts of your Excel file will start showing in your contact list.
The contacts will be shown in your phone’s contact list. All you have to do is use the same email ID on your phone and PC. The contacts will be automatically stored in your phone.
Similarly, no matter how many contacts data you have, you can save all the contacts in your phone in one click instead of saving each number one by one.
Stay tuned to the channel for such amazing tricks. Don’t forget to like and share the video. We will meet again with some new videos. Have a good day.
