You are viewing the article How to Add Contacts to Gmail Using a CSV File at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 33,879 times.
You can add email addresses in bulk to your Google account by importing from a .CSV (comma-separated value) file extension. You can create a CSV contact file, export it from your mail browser, or view the accepted fields in a blank Gmail CSV template and add your own contacts. Once done, sign in to Google Contacts and import the CSV file. Don’t forget to double check the imported contacts are correct.
Steps
Create a sample CSV file
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/07/Add-Contacts-to-Gmail-Using-a-CSV-File-Step-1-Version-4.jpg/ v4-728px-Add-Contacts-to-Gmail-Using-a-CSV-File-Step-1-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 0/07/Add-Contacts-to-Gmail-Using-a-CSV-File-Step-1-Version-4.jpg/v4-728px-Add-Contacts-to-Gmail-Using-a-CSV-File- Step-1-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output “></div>”}
Export CSV file from Gmail. You will have a sample document with data fields accepted by Gmail when importing the CSV file.
- If you have problems exporting, try adding each contact manually to make the extracted file.
- If you are importing CSV files from another email service, skip ahead and see the next section.
- If you want to create a CSV file from scratch, you can check out the full list of header fields here.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/23/Add-Contacts-to-Gmail-Using-a-CSV-File-Step-2-Version-4.jpg/ v4-728px-Add-Contacts-to-Gmail-Using-a-CSV-File-Step-2-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 2/23/Add-Contacts-to-Gmail-Using-a-CSV-File-Step-2-Version-4.jpg/v4-728px-Add-Contacts-to-Gmail-Using-a-CSV-File- Step-2-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output “></div>”}
Open the CSV file with a spreadsheet or text editor. The first line of the CSV file will show different categories for input, such as First Name, Last Name, email, and so on. The spreadsheet will divide these into different cells, and the text editor will list these values in the first line and separate them with commas.
- You can open with Microsoft Excel or Google Sheets (Google Sheets) to work on spreadsheets, while Notepad or TextEdit will be suitable for working on plain text files.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/24/Add-Contacts-to-Gmail-Using-a-CSV-File-Step-3-Version-4.jpg/ v4-728px-Add-Contacts-to-Gmail-Using-a-CSV-File-Step-3-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 2/24/Add-Contacts-to-Gmail-Using-a-CSV-File-Step-3-Version-4.jpg/v4-728px-Add-Contacts-to-Gmail-Using-a-CSV-File- Step-3-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output “></div>”}
Add contacts to CSV file. Enter the information in order in the relevant cell or value list. For specific cells that do not require a value, you can leave it blank, or enter a “,” if you are working on a text file.
- For example, first name, last name, phone number, email in a text file might show as “John,,,john@email.com”.
- Make sure you don’t delete any fields or add commas to empty fields for text files. Gmail will scan through all fields, so missing data will cause import problems.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0a/Add-Contacts-to-Gmail-Using-a-CSV-File-Step-4-Version-4.jpg/ v4-728px-Add-Contacts-to-Gmail-Using-a-CSV-File-Step-4-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 0/0a/Add-Contacts-to-Gmail-Using-a-CSV-File-Step-4-Version-4.jpg/v4-728px-Add-Contacts-to-Gmail-Using-a-CSV-File- Step-4-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output “></div>”}
Open the “File” menu and select “Save”. Changes will be saved and the CSV file is ready to be imported into your Gmail account.
Import CSV files using a web browser
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b8/Add-Contacts-to-Gmail-Using-a-CSV-File-Step-5-Version-4.jpg/ v4-728px-Add-Contacts-to-Gmail-Using-a-CSV-File-Step-5-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ b/b8/Add-Contacts-to-Gmail-Using-a-CSV-File-Step-5-Version-4.jpg/v4-728px-Add-Contacts-to-Gmail-Using-a-CSV-File- Step-5-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output “></div>”}
Navigate to your Google Contacts contacts on the browser.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/5c/Add-Contacts-to-Gmail-Using-a-CSV-File-Step-6-Version-4.jpg/ v4-728px-Add-Contacts-to-Gmail-Using-a-CSV-File-Step-6-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 5/5c/Add-Contacts-to-Gmail-Using-a-CSV-File-Step-6-Version-4.jpg/v4-728px-Add-Contacts-to-Gmail-Using-a-CSV-File- Step-6-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output “></div>”}
Sign in to your Google/Gmail account. Type in your username and password, then click “Sign in”. You will be redirected to the Google Contacts page.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a5/Add-Contacts-to-Gmail-Using-a-CSV-File-Step-7.jpg/v4-728px- Add-Contacts-to-Gmail-Using-a-CSV-File-Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a5/Add-Contacts- to-Gmail-Using-a-CSV-File-Step-7.jpg/v4-728px-Add-Contacts-to-Gmail-Using-a-CSV-File-Step-7.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the “Import Contacts” button located in the left pane. The import contact list window will pop up.
- If you are using Contacts Preview mode, the button will be “Contacts”. Preview mode no longer supports importing contacts, you need to switch back to the old interface and repeat this step.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a4/Add-Contacts-to-Gmail-Using-a-CSV-File-Step-8.jpg/v4-728px- Add-Contacts-to-Gmail-Using-a-CSV-File-Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a4/Add-Contacts- to-Gmail-Using-a-CSV-File-Step-8.jpg/v4-728px-Add-Contacts-to-Gmail-Using-a-CSV-File-Step-8.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click “Choose File”.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/5c/Add-Contacts-to-Gmail-Using-a-CSV-File-Step-9.jpg/v4-728px- Add-Contacts-to-Gmail-Using-a-CSV-File-Step-9.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/5c/Add-Contacts- to-Gmail-Using-a-CSV-File-Step-9.jpg/v4-728px-Add-Contacts-to-Gmail-Using-a-CSV-File-Step-9.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select the CSV file to upload. Browse for the file you exported or created and click “Open”. The file will be added to the pop-up.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/eb/Add-Contacts-to-Gmail-Using-a-CSV-File-Step-10.jpg/v4-728px- Add-Contacts-to-Gmail-Using-a-CSV-File-Step-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/eb/Add-Contacts- to-Gmail-Using-a-CSV-File-Step-10.jpg/v4-728px-Add-Contacts-to-Gmail-Using-a-CSV-File-Step-10.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click “Import”. Once done, your contacts will appear on the Contacts page. [1] X Research Source
- If the contact list is not imported correctly (such as information entered in the wrong field), it is possible that certain fields have been deleted or commas are missing in the CSV file. If you import multiple contacts and need to revise the CSV file, delete all the imported contacts and re-import them instead of editing them one by one.
Advice
- Currently, CSV files cannot be imported using mobile devices.
- CSV is often one of the options for exporting contacts on other email services. These files will be pre-formatted with your contact information and you just need to import it into your Google account.
Warning
- If you created the CSV file yourself, it is best to double check that the information is entered in the correct data field. For example, the name and email address should show up in the right place and be associated with the appropriate contact.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 33,879 times.
You can add email addresses in bulk to your Google account by importing from a .CSV (comma-separated value) file extension. You can create a CSV contact file, export it from your mail browser, or view the accepted fields in a blank Gmail CSV template and add your own contacts. Once done, sign in to Google Contacts and import the CSV file. Don’t forget to double check the imported contacts are correct.
Thank you for reading this post How to Add Contacts to Gmail Using a CSV File at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: