exporting contacts names reversed in CSV file

Status
Not open for further replies.

Trapper

Senior Member
Outlook version
Outlook 2010 64 bit
Email Account
POP3
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?
 

Trapper

Senior Member
Outlook version
Outlook 2010 64 bit
Email Account
POP3
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.
 

Trapper

Senior Member
Outlook version
Outlook 2010 64 bit
Email Account
POP3
I have just opened a new contact card as the two snippets below:
Contact Card John Smith..JPG
CSV File John Smith.JPG
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I'll see if i can repro. Seems stupid for Outlook to export in that format, but Outlook can be stupid...
 

Trapper

Senior Member
Outlook version
Outlook 2010 64 bit
Email Account
POP3
Hi Diane.
I have tried again with the same result. Hope you have more success!
 

Trapper

Senior Member
Outlook version
Outlook 2010 64 bit
Email Account
POP3
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.
 

Trapper

Senior Member
Outlook version
Outlook 2010 64 bit
Email Account
POP3
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.
 

Trapper

Senior Member
Outlook version
Outlook 2010 64 bit
Email Account
POP3
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!
 
Status
Not open for further replies.
Thread starter Similar threads 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
P Exporting Calendar, Contacts & Tasks from Outlook 2007 to Outlook 2003 Using Outlook 5
C exporting contacts from msn hotmail to outlook Using Outlook 2
M Exporting the Notes field from Outlook Contacts to Excel Using Outlook 1
D Exporting Contacts Using Outlook 5
R Exporting Contacts Error Using Outlook 4
G Exporting Microsoft Outlook Contacts as CSV file Using Outlook 4
N Re: Exporting Outlook contacts via a CSV file into Hotmail Using Outlook 3
B Exporting Contacts in Outlook 2003 Using Outlook 6
S Trouble exporting my Outlook 2003 Contacts file to another computer running Win XP Pro SP3 Using Outlook 3
E Exporting 2003 outlook contacts Using Outlook 1
B Exporting Contacts to a .pst file in Office 2010 Using Outlook 6
S Exporting Contacts to Excel Using Outlook 2
S exporting Contacts to a CSV file Using Outlook 6
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 New Slipstick.com Articles 0
V Unknown error when exporting to a PST Outlook Wishlist 2
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
S Problems with Exporting Data by *.pst Using Outlook 1
S exporting failed deliveries Using Outlook 2
D Need help bulk exporting mailboxes Exchange Server Administration 3
M exporting personal folders from outlook Using Outlook 6
E Exporting all contact information from Outlook. Using Outlook 4
S Exporting wlm into Outlook 2007 Using Outlook 1
J Exporting Contact Groups in OL 2010 Using Outlook 4
K Exporting to PST Outlook 2010 Exchange Server Administration 1
R Problem exporting Exchange 2010 selsigned certificate Exchange Server Administration 3
R Exporting outlook 2010 tasks to excel Using Outlook 2
P exporting and importing email accounts Outlook 2010 Using Outlook 3
N Re: Exporting Outlook History Using Outlook 4
F Oulook 2007 emails exporting Using Outlook 3
P Exporting into vCard (Outlook 2010) Using Outlook 3
K exporting contact list to and excel worksheet Using Outlook 1
Similar threads


















































Top