upload contacts into google not importing correctly

Download Article

Download Article

Y'all can add email contacts in bulk to your Google account by importing them from a .CSV file (comma-separated value). Contact CSV files can be fabricated from scratch or exported from your e-mail client of choice. You tin can use a blank Gmail CSV file equally a template to see the acceptable fields, and so add your own contacts. Once consummate, sign into your Google Contacts and import the CSV file. Don't forget to double bank check your imported contacts for accurateness.

1. one

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

   • If y'all are having bug exporting without any contacts, try manually adding a single contact to create an export file.
   • If you are importing a CSV from some other e-mail service, you lot tin can skip to the import method.
   • If you want to create CSV file from scratch, a total list of the field headers can exist found here.

2. 2

   Open up the CSV file with a spreadsheet or text program. The first line of the CSV volition display the different categories for data entry (e.chiliad. Offset Name, Last Proper noun, electronic mail, etc.). Spreadsheets will divide these categories into different cells, while text editors will listing these values on the start line separated by commas.

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

   Advertisement

3. three

   Add your contacts to the CSV. Enter data to the related cell or list values in guild. If no value is needed for a certain surface area, the cell can be left blank, or in the instance of a text file, filled with a ",".

   • For example, a First Proper name, Concluding Name, Telephone, E-mail on a text file could be "John,,,john@e-mail.com".
   • Make sure to not to remove any fields or to include a comma in identify of a blank 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 up the "File" card and select "Save". Changes to the CSV file must be saved before they tin be imported into your Gmail account.

   Advertizing

1. 1

2. 2

   Sign into your Google/Gmail account. Enter your username and countersign and click "Sign in". You volition exist redirected to your Google Contacts folio.

3. 3

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

   • If y'all are using the new Contacts preview, this push button will be labeled "Contacts". The preview does not currently support importing contacts and you volition be redirected to the old contacts interface and will need to redo this step.

4. 4

   Click "Choose File".

5. v

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

6. 6

   Click "Import". After a few moments the import volition complete and your contacts will appear listed on your Contacts page.^[1]

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

   Advertisement

Add New Question

• Question

  Tin I import a CVS file from AOL mail?

  

  Yes, follow these steps: (ane) In one case logged into AOL Mail, click on "Contacts" on the left. (2) Click on the Tools menu and choose "Import." (3) Pick a CSV file on your computer. (4) Select an import format (CSV, TXT, or LDIF). (v) Click on the "Import" button.

• Question

  How practice I import my contacts to a specific group?

  

  Each imported contact features a flag (group) that you can select and rename as desired.

• Question

  How can I run into the contacts that are imported to a Gmail account?

  

  A listing of your contacts can 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

  Will emails be sent to my contacts if I do this?

  

  This process merely adds contacts to your business relationship. No emails will be sent.

• Question

  Why doesn't the phone number show upward 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 address to go a message when this question is answered.

Submit

Advertisement

• CSV files currently cannot be imported using mobile devices.

• CSV is likely to be one of the options when exporting your contacts from another email service. These files will be preformatted with your contacts' information and prepare to import into your Google account.

Thank you for submitting a tip for review!

Advertisement

• If you created your own CSV file, it is a good idea to double check that the information imported to the correct fields. For instance, make sure names and emails announced in the correct space and are associated with the correct contacts.

Advert

About This Article

Commodity Summary X

1. Add together addresses to your CSV file.
2. Sign in to https://contacts.google.com.
3. Click Import.
four. Click Chose File.
5. Select the .CSV file and click Open.
six. Click Import.

Did this summary assistance you?

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

Is this article upwards to date?

livingstonloness.blogspot.com

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

Share this post