Thank you for your helpful video. I have been going mad trying to do this. I exported the contacts from my google contacts to a csv file and did not go to google drive part but opened it in excel. I edited the contacts spending hours of hard work and after finishing it all up again imported the csv file but only to find that lots of phone numbers changed into some odd looking number and letter combinations like 1+E 09 etc. My hours of hard work got wasted. I have to try your method and hope it works.
Can one change the order of the fields when editing in sheets? Also what is the difference between Name Given name and family name? If I edit the given name and / or famly name will it reflect in the Name Given field? OR shall I directly make the changes in teh Name given field?
Is there a way to do this and not loose all the tags of your contacts? I have all my contacts sorted by tags but when I upload the csv the tags are gone. Thanks
I know this Video is over 1 year old but I need to clean up my contacts. I did what you explained but when I open the CSV. file in Google Docs. there are so many columns that are mostly blank. With that said can I delete these columns and then reimport into Google Contacts later even though there are missing columns? The reason all theses extra columns with no data bothers me is that there is data way of the page and I have to scroll to the right to see if it is accurate or not. By removing a majority of the columns this will allow me to see most of the info I need on the screen without having to scroll over and over to the right. My workflow is If the contact is a Vendor and not a client I want to flag "V" in a new column I added in Google Sheets so that I can sort that column with "V" and high light all the "V" and type "Vendor" in that cell. With over 4k contacts I will have to come up with a system so I can save time or it will take me months and months to clean up. Editing each contact cell in Google Sheets line by line vs. a "V" or a "X" and sorting will take why too long.
Google needs to have a " basic" contact info option. Company name, contact name (s), phone #, email, Physical address, group . That's it. How do we let Google know to do this????
Some random contacts popped up in my phone and they say im linked through google but when i go to my google contacts i dont have any...... and these contacts are from my aunt's phone but i dont 90% know these ppl. why does this happen (this isnt the first time?) and how do i stop it?
thanks for watching aiyanna peoples!! It sounds like you might have your phone in sync with your Aunts Phone. I would change your Google Password first then delete the contacts that are not yours. Maybe you logged into your account from her phone or they know your password. Never enter the account info on someone elses device and if you do use another persons computer use a browsers incognetio window or private browsing. I hope this helps..
😁👏🏻👏🏻 Congratulations on the content. Helped me a lot. You won another subscriber on your channel. What software did you use to zoom highlight during this tutorial?
Thanks to +Jyoti Méditation France docs.google.com/spreadsheets/d/1qQQgSl_ukeBss_S6Ht1oVd2WA-Aq_ujvW6TpGIgOI1k/edit#gid=2 I will add to video description soon as in the help centre article. Hope this helps and thanks for watching and contributing
Never ceases to amaze that Google, for all it's tech power, can't SYNC sheets and contacts? So with this you're admitting there's no way to SYNC contacts and sheets? So change either and the other updates. Can't do it?
Here are the value to put on your spreasheet to import correctly on google contacts : docs.google.com/spreadsheets/d/1qQQgSl_ukeBss_S6Ht1oVd2WA-Aq_ujvW6TpGIgOI1k/edit#gid=2 :)
Why did you not say in the second sentence of your presentation that this can only be done in Google Chrome!!! Instead, you went blank for more than a minute, then said, "this can only..." Duh.
Thank you. Easy to follow. Personally, I don't care for the background music that comes in and out. Distracting. But keep up your good work.
Thank you sir, i find so many ways in mobile to convert but not succeed because of huge contacts list. it's a very easy way, i am happy.
Thanks for that. Would you lose all your photo avatars of contacts this way? Does google have a way to add those easily from photos or Facebook?
Actually Perhaps Merging on reimport would mitigate that. Thx
Thank you for your helpful video. I have been going mad trying to do this. I exported the contacts from my google contacts to a csv file and did not go to google drive part but opened it in excel. I edited the contacts spending hours of hard work and after finishing it all up again imported the csv file but only to find that lots of phone numbers changed into some odd looking number and letter combinations like 1+E 09 etc. My hours of hard work got wasted. I have to try your method and hope it works.
Thanks Lee - clear and concise.
Thanks for watching and feedback!
Found this very helpful today, had to add a lot of contacts to invite them to a Whatsapp group
Thanks a lot, such a helpful method!
Can one change the order of the fields when editing in sheets? Also what is the difference between Name Given name and family name? If I edit the given name and / or famly name will it reflect in the Name Given field? OR shall I directly make the changes in teh Name given field?
Very helpful, exactly what I was looking for!
Is there a way to do this and not loose all the tags of your contacts? I have all my contacts sorted by tags but when I upload the csv the tags are gone. Thanks
I know this Video is over 1 year old but I need to clean up my contacts. I did what you explained but when I open the CSV. file in Google Docs. there are so many columns that are mostly blank. With that said can I delete these columns and then reimport into Google Contacts later even though there are missing columns? The reason all theses extra columns with no data bothers me is that there is data way of the page and I have to scroll to the right to see if it is accurate or not. By removing a majority of the columns this will allow me to see most of the info I need on the screen without having to scroll over and over to the right.
My workflow is If the contact is a Vendor and not a client I want to flag "V" in a new column I added in Google Sheets so that I can sort that column with "V" and high light all the "V" and type "Vendor" in that cell. With over 4k contacts I will have to come up with a system so I can save time or it will take me months and months to clean up. Editing each contact cell in Google Sheets line by line vs. a "V" or a "X" and sorting will take why too long.
Hey James thanks for watching. Yup u should be able to!
Google needs to have a " basic" contact info option. Company name, contact name (s), phone #, email,
Physical address, group .
That's it.
How do we let Google know to do this????
amazing video, thank you very much for saving a lot of my time
Thankss bro.
very clear, love it. but why did you put Sasktech in the notes? what's the purpose? Thank you
It's intended to be a tag or property of a contact or set of contacts
your video was good help bro.. thanks
Some random contacts popped up in my phone and they say im linked through google but when i go to my google contacts i dont have any...... and these contacts are from my aunt's phone but i dont 90% know these ppl. why does this happen (this isnt the first time?) and how do i stop it?
thanks for watching aiyanna peoples!! It sounds like you might have your phone in sync with your Aunts Phone. I would change your Google Password first then delete the contacts that are not yours. Maybe you logged into your account from her phone or they know your password. Never enter the account info on someone elses device and if you do use another persons computer use a browsers incognetio window or private browsing. I hope this helps..
I would like to clean up my contacts in this way but would prefer not to lose my pictures. What are your thoughts?
This is an interesting question - I have not considered images... I will try to leave what I find here for you back here when I know more..
😁👏🏻👏🏻 Congratulations on the content. Helped me a lot. You won another subscriber on your channel. What software did you use to zoom highlight during this tutorial?
Do you know a a way to have the Google Contacts updated automatically when the Google Sheet is updated?
There might be an App Script or Add-in for this... Would be a good idea. If I find I will let you know/
Very helpful
thank you, very helpful
Mine does not offer to open with Google Sheets, only Google Docs.
So sad we still need to do this just to multi-edit similar items in our contacts.
Truly Google's Contacts sucks..
Thanks, Lee.
Perfect!. Thanks!
Excellent..
Thanks!!!!!!
Thank you!!!
can u plz tell me what is the names of the column to save the contacts plz.plz.Am not getting in this video...
Thanks to +Jyoti Méditation France docs.google.com/spreadsheets/d/1qQQgSl_ukeBss_S6Ht1oVd2WA-Aq_ujvW6TpGIgOI1k/edit#gid=2 I will add to video description soon as in the help centre article. Hope this helps and thanks for watching and contributing
I did this and it duplicated all my contacts. :(
You have to delete the ones in the system that you exported before reimporting the updated versions from Sheets files, otherwise yes...duplicates
very old but all your pictures got lost this way
Best way to download in XL and manually synch with Outlook!
Never ceases to amaze that Google, for all it's tech power, can't SYNC sheets and contacts? So with this you're admitting there's no way to SYNC contacts and sheets? So change either and the other updates. Can't do it?
Here are the value to put on your spreasheet to import correctly on google contacts : docs.google.com/spreadsheets/d/1qQQgSl_ukeBss_S6Ht1oVd2WA-Aq_ujvW6TpGIgOI1k/edit#gid=2 :)
Thanks for watching and contributing to this +Jyoti Méditation France
very helpful, please no more of this music
But you are deleting and Importing. This is not exactly Editing.
Cool guide, but HORRIBLE music choice xD
Why did you not say in the second sentence of your presentation that this can only be done in Google Chrome!!! Instead, you went blank for more than a minute, then said, "this can only..." Duh.