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
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
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
V Backup Calendar, Contacts, Tasks in an POP3 data file Using Outlook 3
J Outlook 365 Outlook 2016/365 Contacts Lose Info when Favorited to the To-Do Bar Using Outlook 2
D Advanced e-Mail search on from/to contact group only searches for first 20 contacts in group Using Outlook 0
P Outlook calendar and contacts sync problem-outlook disconnects Using Outlook.com accounts in Outlook 2
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

Similar threads

Top