Can i create a contact list on my PC and somehow export it to my Huawei P9 phone

[Android Central Question]

I need to put 250 contact numbers from an Excel list onto my phone is it possible?
I would also like to divide those 250 numbers into 6 folders.
I need urgent help with that

 

[B. Diddy]

Welcome to Android Central! First, convert the Excel file to a .csv file: https://support.office.com/en-us/ar...sv-files-5250ac4c-663c-47ce-937b-339e391393ba -- look at the "Export data to a text file by saving it" section.

Then, import that .csv file into your Google Contacts. Go to contacts.google.com on the web, click More in the left column, then Import, then CSV, and choose the .csv file you just created.

Once you've imported the contacts into Google Contacts, they'll sync automatically with your phone. You can then create your 6 contact groups (called Labels in Google Contacts) and organize your contacts as you want. https://support.google.com/contacts/answer/30970?hl=en

 

[Rukbat]

Or use a little VBA to do the "mix and match" - the moving the data in column A in the .xlsx file to the 4th element in the .csv file, or whatever has to be moved where. It would do that while saving the file as a .csv file. (It depends on how well you know VBA, but the whole thing can be done in a single VBA function.)