Windows 10: exporting contacts from gmail to csv file then importing the .csv file to outlook

I have a dell 15-3567 win 10 OS and Outlook 2019


I am trying to exporting contacts from gmail to a csv file on my desktopwhich I have done sucessfully, then importing the .csv file into outlook. to use in outlook E-mail

in Outlook 2019 ,when I choose file, open & export,import/export,import from another program file, comma seperated values,choose the csv file and do not import duplicates & click next, and choose into contacts, a message appears...


"A file error has occured in comma separted values translator while initializing translator to build a filed map."

"the file c:\user/wldpr\desktop\contacts.csv" is locked. this could be because the disk is locked, the file is read-only,in use by another program,or you do not have permission to use a network path."


Does anyone have a clu as to what is going wrong here?

One would think this be a simple process.

Help would be greatly appreciate.

:)

 

GUIDE:How to transfer contacts from Microsoft Outlook to Gmail

I'm sitting here in the office, its the end of the year in the school system, and several employees transferring to alternative counties. With this it brings loads of transferring contacts to take with them from their company phone. Well, this one in particular sparked a guide idea. So here it is, How to transfer Outlook contacts to your Gmail account.


Step 1: Sign in to your outlook account.
step 2 In the top left hand corner click File > Import/Export > Export to file > Browse to desired place to save your file > export. Be sure you export the file as .csv (comma separated values)
Step 3 Log into your Gmail account
Step 4 Select 'Contacts' In the subsection you will see a 'Import' button on the right-hand side. Click it.
Step 5 Browse to the location where you saved it > Open it > Click Import.



I would have provided pictures, but I use neither Outlook or Gmail. Hope someone somewhere gets some use from this. *Toast :toast:


=Munki=

 

Importing Gmail Contacts to Outlook (Hotmail) People

I used to be able to export "Contacts" from my Gmail account and import them into Outlook "People" so I could keep my contacts synced between platforms. Unfortunately it hasn't worked for many months. I contacted Microsoft and despite numerous online and emails back and forth with the Indian Help guy, nothing ever worked. It was odd he never wanted to see my CSV files.

Gmail gives Google CSV and Outlook CSV export options. The Outlook CSV file gives a "Something went wrong.. the format isn't correct...." error when I try to import it into "People". The Google CSV imports but most of the data is stuffed into a "Notes" field. Looking at the two files in a spreadsheet, I see nothing to justify why Outlook "People" is doing what it does.

I can import the Gmail CSV into my other on-line email services without major issues. Something Gmail or Microsoft did screwed up something I have been doing for 10 years.

 

can not find csv file

You have to make the .csv file first by exporting the Contacts from Outlook 2007 to a .csv file, them you can import them into Outlook 2016. Instruction here...
https://support.office.com/en-us/art...D0EAABAAA=2007

BTW, Excel can open .csv files, just double-click on one. The .csv format is also available on Excel's 'Save as...' but you'll be warned it won't save the formatting, just the data.