How to transfer contacts from excel to google?

Question

Google

Good afternoon!
There are contacts in excel about 1000 pieces. They need to be transferred to google.
I exported some contacts from google in .csv format.
Next, I want to rewrite their excel contacts into a google file and import them back.
My contacts look like this (in the first column, full name, second phone number):
Last name First name Middle name 81234567890
Last name First name 8-123-456-78-90 Last name First
name [phone]
Google contacts look like (in one cell) :
First name Last name, First name,, Last name,,,,,,,,,,,,,,,,,,,,,,,* My Contacts,,,Mobile,[phone],,
Question: how, using formulas, cast my contacts to google format?
Question: Is there an easier way?
===== SOLUTION =====
After googling a bit, I came up with a solution myself.
1. We bring phones to a single look. Select the column with phones and call "find and replace". Next, replace successively all hyphens, spaces, brackets and back brackets with "nothing".
The main thing here is that the last 10 characters for all numbers will be the same format.
2. We get the First Name, Last Name and Phone number separately in the three corresponding columns.
I placed these columns to the right of the corresponding A and B (see screenshot below).
NAME:
=FLATSPACES(MID(SUBSTITUTE(A2," ",REP(" ",LNSTR(A2))),LNSTR(A2)*(2-1)+1,LNSTR(A2)))
SURNAME:
=PSTR( A2;1;FIND(" ";A2)-1)
PHONE (right 10 characters):
=RIGHT(B2;10)
3.
This column is also to the right.
=C2&" "&D2&","&""&C2&",,"&""&D2&",,,,,,,,,,,,,,,,,,,,,,,,* My Contacts,,, Mobile,+7"&""&E2&",,"

4. Stretch all the formulas to the end of the column.
5. Copy the values ​​to the downloaded google file with .csv extension
6. Import the received contacts back to google.
We rejoice :)

Answer 1

hello
, I don’t understand excel at all, but I did everything as you wrote, but 5 6 points are not clear to me. I just converted this excel file to csv format and imported it from my google account. The problem is this: the contact phone number is transferred to the notes =( help. contact me for convenience in contact https://vk.com/caduceustatoo

Answer 2

Check out this option https://pozitivwork.blogspot.com/2020/01/How-to-tr...

Answer 3

I also faced this problem today, and by trial I found out that in the .csv file in the first line it is enough to leave the necessary headers, without a bunch of extra commas.
That is, in the case of the author, you need to leave these headings in the line:
First Name,Middle Name,Last Name,Mobile Phone
And the next lines already prescribe First Name, Middle Name, Last Name,
Phone

I don’t know how it was 3 years ago, but now Google knows how to use the headings substitute values.