exporting contacts names reversed in CSV file

Not open for further replies.


Senior Member
Outlook version
Outlook 2010 64 bit
Email Account
My OL contact card fields are all set to display the first name first and last name last. Like 'John Smith'.

I export my contact file to my desktop as a windows CSV file. I then imported the file into Google Contacts. The contacts then appeared in reverse; 'Smith, John'. I deleted those I had just imported.

I found an Excel formula that converts 'Smith, John' back to 'John Smith' using a second column inserted into the CSV file. I then copied the John Smith and pasted it into a third inserted column as a 'Value'.

I then deleted the first two columns and saved the CSV file again and re-imported into Google contacts. From there I could sync with my mobile phone.

Seems a very long winded and complicated way of reversing two names!!

I did a search here but nothing I tried gave me an answer.

Is there a SIMPLE way to do the above?
Hi Diane.
I have the name as 'John Smith' in Full Name, File As, Display As and the Email field, the email field does not show the email address, just the name.
I have re-entered the details of a contact as above and the CSV file has reversed the name.
I have just opened a new contact card as the two snippets below:
Contact Card John Smith..JPG
CSV File John Smith.JPG
I'll see if i can repro. Seems stupid for Outlook to export in that format, but Outlook can be stupid...
Hi Diane.
I have tried again with the same result. Hope you have more success!
Hi Diane.
I guess you have not been able to find a fix for this problem. I cannot find any way to export the contact in the right format, it always reverts to surname,forname. Is this usual or does it normally export the other way round and mine's having a bad hair day?

Happy Christmas and a Merry New Year to you and all members.
I have just installed Office 2003 onto my wife's laptop. made a contact John Smith in Outlook 2003 and after installing the Outlook translator program, exported as a CSV file to Excel 2003, the CSV file showed as I need it; First Name and Last Name with no comma's.
Office 2010 is the reverse, grrrr.
Think I may have found one reason, Mapping of fields, the top field of the right hand box showed 'Name' I deleted this and copied the First Name and Last Name from the list on the left to the list on the right. Generated another contact and opened it in Excel the A column showed the First Name and the B column showed the Last Name.
There was no column showing 'Smith, John'.

I will play a bit more to see if that was the only problem. but if it was, then I have spent days trying to sort it.
As they say, the question is only easy if you already know the answer!
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
GregS Exporting contacts Using Outlook 1
J OLADD.FAE Error When Exporting Contacts Using Outlook 6
R Exporting contacts from 2010 to 2013 Using Outlook 1
B BCM 2010: Exporting Notes to .CSV with Business Contacts? BCM (Business Contact Manager) 3
Commodore Exporting all contacts to VCF files possible? Using Outlook 4
C How to get SMTP out of email address when exporting contacts? Using Outlook 2
M Error Messages when exporting Outlook 2010 Contacts to a CSV (DOS) or Excel Using Outlook 2
R Exporting and importing contacts in Outlook 2007 Using Outlook 1
L Error when exporting Sent Mail to Excel Outlook VBA and Custom Forms 6
HarvMan Exporting IMAP OST file to PST Using Outlook 5
O Carriage Return - Line Feeds - exporting Calendar events Using Outlook 0
B vBA for exporting excel file from outlook 2016 Outlook VBA and Custom Forms 3
R Exporting recovered Deleted Items outside the Inbox Using Outlook 1
N Exporting IM Address field Using Outlook 2
E Exporting email (.pst) Using Outlook 8
R Exporting Excel data to Outlook 2016 Calendar Outlook VBA and Custom Forms 20
D EXPORTING MS EXCHANGE EMAILS to another platform Exchange Server Administration 10
Connie Boyer Exporting Outlook calendar/find next repeating meeting Using Outlook 3
A Exporting email in outlook 2013 with Office 365 Using Outlook 1
Diane Poremsky Fix the Outlook Folder Type after Exporting an IMAP Account Using Outlook 0
V Exporting RSS Feed to OPML file Using Outlook 8
D Reoccuring appointment issues when exporting Calendar to Excel Using Outlook 3
C Security Question - How to prevent users exporting .iaf files Using Outlook 5
P Exporting group members from Outlook address group Using Outlook 11
C extra characters added to email when exporting Using Outlook 2
H Exporting Outlook Forms to Access or Excel Outlook VBA and Custom Forms 2
F Outlook 2007 BCM Exporting Files BCM (Business Contact Manager) 2
T Automating Exporting to pst file Outlook VBA and Custom Forms 3
G exporting files from BCM BCM (Business Contact Manager) 1
G exporting from BCM BCM (Business Contact Manager) 1
D Exporting reports to Excel gives wrong numbers BCM (Business Contact Manager) 1
H Error in values when exporting report to Excel BCM (Business Contact Manager) 1
G Apply Custom Contacts form to all existing Contacts Outlook VBA and Custom Forms 1
G Add Map It button to Custom Contacts Form in Outlook Outlook VBA and Custom Forms 1
B Sync Outlook Public Folders to Contacts Using Outlook 2
Kika Melo How to mark as Junk any message not from Contacts (in Outlook.com) Using Outlook 3
G Outlook 365 My iCloud Outlook doesn’t work after reinstalling Microsoft365 on Windows 10 PC – now I get error message on contacts and calendar Using Outlook 1
T How to Export & Import GMAIL Contacts into Outlook 2021 ? Using Outlook 4
L Applying new form to existing contacts -- MessageClass Outlook VBA and Custom Forms 3
Bardiferous Weird Contacts Behavior - Can't find any in any address book, but they're in there Using Outlook 3
S client lost 3K contacts when office 365 for mac account deleted from company exchange server Using Outlook 5
O How to sync (one way) contacts between two Outlook (exchange) accounts? Using Outlook 0
P How to clear out all contacts in iCloud, so I can use iCloud-based sync program Using Outlook 1
R How to prevent corrupted Notes format in Calendar and Contacts Using Outlook 0
K Outlook 365 After migrating to Outlook 365, some contacts display in emails with prefixes Using Outlook 0
kburrows Outlook or Phone Combining Contacts? Using Outlook 0
Witzker Add a text line at the end of the note field in all selected Contacts Outlook VBA and Custom Forms 7
G Add contacts birthday to calendar Using Outlook 4
R How to force Outlook to use plain text in notes for Contacts? Using Outlook 1
S Cannot print Contacts Using Outlook 7

Similar threads