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.
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
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 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
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
K Font Sizing in Custom Form Regions for Contacts Outlook VBA and Custom Forms 1
O Outlook - hidden contacts? Using Outlook 2
H Synchronize contacts and calendars across multiple devices Using Outlook 0
S Outlook 2016 Change how Outlook shows me contacts in emails Using Outlook 0
L Favorites for People/Contacts? Using Outlook 1
K can't get custom form to update multiple contacts using VBA Outlook VBA and Custom Forms 3
Horsepower Contacts added from iPhone don't show up in Outlook Using Outlook 2
B oContacts.Items.Restrict Misses Some Contacts Outlook VBA and Custom Forms 3
F Moving Contacts to New Profile Using Outlook 0
V Contacts in O365 have changed?? Using Outlook 20
T Outlook 2010 BCM Migration to Standard Contacts BCM (Business Contact Manager) 0
D Outlook Contacts Notes Field Photos to Smartphone Using Outlook 0
G Add to Outlook Contacts - Point to non-default contacts folder Using Outlook 0
D Is a sub folder under contacts necessary to be able to name an Address Book? Using Outlook 1
L Outlook 2016 Contacts missing in Outlook 365 Using Outlook 1
L icloud contacts sync Using Outlook 4
Fozzie Bear Outlook 2016 Creating a shared local Contacts folder Using Outlook 2
M VbScript for Command Button on Contacts Custom Form Using Outlook 1
J Outlook 2013 Change color of text in data fields of contacts in Outlook 2013? Using Outlook 10
M Changing the preferred order for "Put this entry in" list for adding new contacts to the Address Book Using Outlook 1

Similar threads

Top