How to Export & Import GMAIL Contacts into Outlook 2021 ?

T

Tim94549

Member
Outlook version
Outlook 2021 64 bit
Email Account
IMAP
For the life of me I can't find proper instructions that WORK to Export GMAIL contacts to a .CSV then Import into Outlook 2021 ...

Are there any instructions available that WORK ? I am able to export fine (I think - I get a .CSV file).. However when I do a FILE / IMPORT and point to the created file , choosing "Another program or File", point to the .CSV created & targeting "Contacts (My Computer)", I get an error popup -

"Outlook unable to retrieve Data .." . blah blah blah ...

TIA
 
Open the CSV in notepad - does it look good? Some exports will have weird characters before the first letter in the file - delete them and save. Is the file type UTF-8? Look on the right side of the status bar - if needs to be just urf-8, not BOM.

When importing - on the last page before clicking Finish, check the field mapping. Are the fields matched correctly? Click the button to reset the matching.
 
The CSV file looks "fine" .. I don't know what you mean by file type UTF-8 vs URF-8 ... I don't see that anywhere in the file. When I import, I never receive a place to check FIELD MAPPING. It just error's out immediately after selecting my CSV file. TIA
 
Open the file in notepad - what is in the lower right - (this screenshot is not from a CSV).
1704392569718.png


Select Map custom fields in this dialog -
1704392832112.png


and check the fields on the right to see if they are matched. In this case, you can see the title field has the weird chatacters in it, so it did not map (on the right).
1704392815097.png
 
UTF-8 is in the bottom right of Notepad.

I have no option to "Map Custom Fields"
 
You must log in or register to reply here.
< My iCloud Outlook doesn’t work after reinstalling Microsoft365 on Windows 10 PC – now I get error message on contacts and calendar | Outlook attachments from OneDrive as links >
Similar threads
Thread starter Title Forum Replies Date
K Disabling import/export button to restrict PST creation Using Outlook 3
M Export-Import .pst file problems Using Outlook 2
Q Outlook 2016\365 export specific rules to import in another system Exchange Server Administration 1
J Opening/Archiving/Import/Export PST files Using Outlook 4
Sarge USMC Cannot import/export Outlook 13 Using Outlook 6
L Outlook 2007 Codes Export and Import Using Outlook 9
L Outlook 2007 Toolbar Export and Import Using Outlook 7
R Flagged for Follow Up Search folder MIA after PST export/import Using Outlook 1
T Distribution List - Export/Import Using Outlook 4
K outlook 2007 Export/Import Distribution lists Using Outlook 1
L Import/Export BCM (Business Contact Manager) 1
B BCM shuts down everytime I try to import/export or check for error BCM (Business Contact Manager) 10
S Business Data Import and Export Load Error Cannot Map BCM (Business Contact Manager) 1
Owl Export Outlook PDF Attachment as JPG? Outlook VBA and Custom Forms 4
K Export Folder to PST Outlook VBA and Custom Forms 2
R Outlook 2010 How do you export 2 email Accounts' 2010 Inbox Files to new computer (2019)? Using Outlook 0
O Export Outlook calendar appointments by filters and date range Outlook VBA and Custom Forms 1
M How to export Voting Results with user names and their responses Outlook VBA and Custom Forms 13
J Export Zimbra to Outlook PST Using Outlook.com accounts in Outlook 1
S How to export urls from email to excel and check the status of the url ? Using Outlook 5
C Export NSF Lotus Notes files in Outlook PST format? Using Outlook 1
C How to export Outlook data to csv? Using Outlook 0
T How to Export mailbox from Outlook 2019 to MBOX format? Using Outlook 1
M Auto-export mail to Excel Outlook VBA and Custom Forms 2
P How to export voting results using VBA? Outlook VBA and Custom Forms 2
R How To Repair OST File & Export OST File to Outlook PST ? Using Outlook 3
JohnViuf Export task list view settings to other pc Outlook VBA and Custom Forms 16
J Copy or Export Outlook Mail to Excel Outlook VBA and Custom Forms 6
N Export details to a excel spreadsheet using macros Using Outlook 0
avant-guvnor Export Calendar, Birthdays and Holidays Outlook VBA and Custom Forms 0
Diane Poremsky Export (Save) Outlook Contact photos Using Outlook 0
K Macro to search emails between two time slots on public folders with excel export Outlook VBA and Custom Forms 12
A How to export one email data to excel Using Outlook 1
B Macro To Create Rule To Export From Certain Folder Email Information in one workbook multiple sheets Outlook VBA and Custom Forms 0
W macro to export outlook emails to excel Outlook VBA and Custom Forms 6
E Exchanger service export detection Exchange Server Administration 1
R Correct a wrong csv export file from WLM 2012 Using Outlook 0
H How to export *all* fields from Outlook Using Outlook 2
K Export Organizational Forms Library Exchange Server Administration 1
N Export Outlook custom forms fields to excel Outlook VBA and Custom Forms 1
E RSS export as OPML problem Using Outlook 4
A export free / busy from exchange Exchange Server Administration 0
C Export to excel missing items, but a larger total? BCM (Business Contact Manager) 6
M Outlook 2013/365 won't export 99% of my contacts to csv Using Outlook 2
T Outlook 2007 Export tasks to Excel Using Outlook 2
H Select one of Contact-Mailadesses to Export > Excel or Winword Outlook VBA and Custom Forms 2
S Requried a VBA Code to export Calander details to excel... Outlook VBA and Custom Forms 4
Jennifer Murphy Can I export individual emails? Using Outlook 1
R Export Address Book VBA Using Outlook 0
W How to export additional fields in contacts Using Outlook 1

Similar threads

Back
Top