how to upload contacts csv to gmail

Download Article

Download Commodity

You tin add together email contacts in bulk to your Google account by importing them from a .CSV file (comma-separated value). Contact CSV files tin can be made from scratch or exported from your email client of choice. You tin can apply a bare Gmail CSV file as a template to run across the adequate fields, and then add your own contacts. In one case consummate, sign into your Google Contacts and import the CSV file. Don't forget to double check your imported contacts for accuracy.

1. 1

   Export a CSV file from Gmail. This can provide a template for which fields Gmail will accept for CSV importing.

   • If y'all are having problems exporting without whatsoever contacts, try manually adding a single contact to create an export file.
   • If you are importing a CSV from another email service, yous can skip to the import method.
   • If you want to create CSV file from scratch, a full list of the field headers can be found hither.

2. 2

   Open the CSV file with a spreadsheet or text plan. The first line of the CSV volition brandish the different categories for information entry (e.g. Get-go Name, Final Proper name, email, etc.). Spreadsheets will dissever these categories into different cells, while text editors will list these values on the beginning line separated past commas.

   • Microsoft Excel or Google Sheets will work for working with a spreadsheet, Notepad or TextEdit will work for working with a plaintext file.

   Ad

3. 3

   Add together your contacts to the CSV. Enter information to the related jail cell or list values in lodge. If no value is needed for a sure area, the cell tin can be left bare, or in the example of a text file, filled with a ",".

   • For example, a Outset Name, Terminal Name, Telephone, Email on a text file could exist "John,,,john@email.com".
   • Make certain to not to remove any fields or to include a comma in place of a bare field in the case of a text file. Gmail will scan for all fields, so missing fields volition cause issues with the import.

4. 4

   Open the "File" menu and select "Save". Changes to the CSV file must be saved before they can be imported into your Gmail account.

   Advertisement

1. 1

2. ii

   Sign into your Google/Gmail business relationship. Enter your username and password and click "Sign in". You volition exist redirected to your Google Contacts page.

3. iii

   Click the "Import Contacts" push button. This button is listed in the left panel and will open an import popup window.

   • If you are using the new Contacts preview, this button will exist labeled "Contacts". The preview does not currently support importing contacts and you will be redirected to the quondam contacts interface and volition need to redo this stride.

4. iv

   Click "Choose File".

5. 5

   Select your .CSV file to upload. Scan for the file you exported or created and click "Open". The file will be added to the import popup window.

6. vi

   Click "Import". Subsequently a few moments the import volition complete and your contacts will appear listed on your Contacts folio.^[ane]

   • If yous find that your contacts did non import correctly (i.eastward. information imported into the wrong field), yous may take removed a field or missed a comma on your CSV file. If you imported many contacts, it may be easier correct the CSV file, delete all imported contacts, and re-import, rather than editing each contact ane past one.

   Advertisement

Add New Question

• Question

  Can I import a CVS file from AOL mail?

  

  Yes, follow these steps: (1) One time logged into AOL Mail service, click on "Contacts" on the left. (two) Click on the Tools menu and choose "Import." (3) Pick a CSV file on your estimator. (4) Select an import format (CSV, TXT, or LDIF). (five) Click on the "Import" button.

• Question

  How do I import my contacts to a specific group?

  

  Each imported contact features a flag (group) that y'all tin select and rename as desired.

• Question

  How tin I run across the contacts that are imported to a Gmail account?

  

  A list of your contacts tin be viewed at contacts.google.com or in the Contacts app of your mobile device (if it has been linked to your Gmail account).

• Question

  Volition emails exist sent to my contacts if I do this?

  

  This process only adds contacts to your account. No emails will be sent.

• Question

  Why doesn't the telephone number testify up when add contacts to Gmail using a CSV file?

  

  The phone number is added into the 'notes' section.

Ask a Question

200 characters left

Include your email accost to go a bulletin when this question is answered.

Submit

Advertizing

• CSV files currently cannot exist imported using mobile devices.

• CSV is likely to be one of the options when exporting your contacts from some other electronic mail service. These files volition be preformatted with your contacts' data and ready to import into your Google account.

Thanks for submitting a tip for review!

Ad

• If you created your ain CSV file, it is a good thought to double bank check that the information imported to the correct fields. For example, make sure names and emails appear in the right space and are associated with the correct contacts.

Advertisement

About This Commodity

Article Summary X

1. Add together addresses to your CSV file.
ii. Sign in to https://contacts.google.com.
3. Click Import.
4. Click Chose File.
five. Select the .CSV file and click Open.
6. Click Import.

Did this summary aid you?

Thanks to all authors for creating a folio that has been read 663,430 times.

Is this commodity up to date?

culpepperfearch.blogspot.com

Source: https://www.wikihow.com/Add-Contacts-to-Gmail-Using-a-CSV-File

Share this post