Importing contacts from CSV, comma delimited

Status
Not open for further replies.

ofw62

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
For a special reason (long story) I have created a separate empty .pst file. This pst-file is not used for mailing purposes.

I have an Excel file containing names and phonenumbers, in this format:

Name

Phone

LastName, Firstname

+12 (3) 4567890


Exporting to .csv creates rows reading like this

LastName, FirstName;+12 (3) 4567890

i.e. semicolon separator.

Importing into Outlook won't work as comma separators should be used.

Obviously, when changing the semicolon into a comma it messes things up.

Actually two fields were displayed

1st) LastName, FirstName, Phone

2nd) FIELD

My workaround is

1. In Excel - to remove the comma's in the names

2. Export to CSV

3. Use an editor

4. replace semicolons into comma's

5. then import into Outlook - assigning fields etc., all went fine.

The .pst looks how I actually wanted it, so, bottomline it is okay.

But I wonder, although it worked out fine, it seems to me that this 'workaround' isn't really the correct method.

(Outlook/Excel 2013)

Thanks

=
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Better would be separate first and last name fields, but saving as a CSV from Excel should wrap the names in quotes

"last, first", "phone" (assuming first, last are in one cell).

However - this sounds like the fields are goofy:

Actually two fields were displayed
1st) LastName, FirstName, Phone
2nd) FIELD

You should be able to open the CSV in Excel and if the name and phone are in one cell, use Text to Columns (Data tab) to split them into 2 or 3 columns. Fix the column names and save as CSV then import into Outlook.
 

ofw62

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Hello to you,

Many thanks.

I now have created a new Excelsheet with format

LastName

FirstName

Phone

Lastname

Firstname

+12 (3) 4567890


I think there is a bit of confusion on the number format, i.e. whether it should be

+1234567890

and

+001234567890 (intl)

Yes, I have seen/read

http://www.slipstick.com/outlook/config/dialing-outlook-phone-numbers/

Anyway, will try both out

+12 (3) 4567890

and

+1234567890

Thanks again.

=
 

ofw62

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Better would be separate first and last name fields, but saving as a CSV from Excel should wrap the names in quotes

"last, first", "phone" (assuming first, last are in one cell).

Later:

tried that.

After export to csv I get

1st field: Name: Lastname, Firstname

2nd field: Phone: +1234567890

semicolon separated.

no quotes.

no luck.

=
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
If you open in Notepad, the contents of one cell are not wrapped in double quotes? If so, it would be better to use 3 cells, for first, last and phone.
 

ofw62

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
No quotes, I am looking at it using a fileviewer.

below with data in both 2 and 3 cells, the semicolon being the field separator.

Excel-CSV-output-separators-05112013 141149.png

=

Naam=Name

Voornaam=Firstname

Telefoon=Phone

=
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Aw... that is helpful. The problem is related to the language settings and characters those languages use. I should have picked up on it when i saw the number format. Sorry.

I don't know if Excel has a list separator setting (there isn't one in save as), but there is one in Control panel, Region (or Regional and Language), Additional Settings. Is it set on semicolon or comma? Theoretically, Outlook should use whatever is set here.
 

ofw62

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Thanks for the tip. I wouldn't expect the separator settings there. With me, it is set to semicolon. I am afraid, when I were to change that to comma, the output would then be

Excel Name-field: Name, FirstName,

Excel Phone: +1234567890

Importing into Outlook, I have two choices:

colon-list

> pst file

The comma after Name above obviously will 'split' the stuff in 3

1. Name

2. FirstName

3. Phone

and I cannot link 1+2 to just Name in Outlook.

http://imageshack.com/a/img513/9158/9q33.png

Tfore I am afraid the only 'solution' (=workaround) is to have a different separator (e.g. a space, or a '-')

=
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
N Importing Google contacts from CSV file removes recipient names in autocomplete list Using Outlook 0
wallisellener BCM 2013 importing contacts from CSV file BCM (Business Contact Manager) 8
K Importing CSV contacts- doesnt allow me to map or move forward V 2007 Using Outlook 1
S Importing emails to contacts Using Outlook 3
K New to BCM - trouble importing contacts & accounts BCM (Business Contact Manager) 3
V Problem not having Contacts folder after importing emails from Yahoo. Using Outlook 0
R Exporting and importing contacts in Outlook 2007 Using Outlook 1
M There was a problem importing your contacts. (Online with Hotmail) Using Outlook 1
R Importing Contacts of Outlook 2010 Using Outlook 3
R importing windows live contacts into outlook 2010 Using Outlook 2
C Message Interface Error When Importing Pst Contacts Using Outlook 13
Y Outlook 2010 App Crash while importing contacts Using Outlook 3
J Thunderbird to Outlook -- importing address book/contacts Using Outlook 2
P Importing Contacts from Outlook Express to Outlook 2010 (not working) Using Outlook 5
N Importing Contacts file to Outlook 2003 running on Windows 7 Using Outlook 5
B Importing archived contacts from previous Outlook (2003) into outlook 2010 Using Outlook 3
J importing contacts, data, emails and attached files from ACT 2009 BCM (Business Contact Manager) 1
C Importing emails/contacts to Outlook 2007 from Windows Mail Outlook VBA and Custom Forms 3
P Importing contacts from Excell file BCM (Business Contact Manager) 1
M having trouble importing excel data into outlook contacts BCM (Business Contact Manager) 1
R importing contacts BCM (Business Contact Manager) 1
B Importing Contacts Does Not Use Defined Custom Form in Outlook 2007 Outlook VBA and Custom Forms 1
W Primary Contacts and importing BCM (Business Contact Manager) 1
J importing contacts from excel BCM (Business Contact Manager) 3
M Importing Contacts from Act 6.0 to Outlook 2007 BCM (Business Contact Manager) 3
J Importing Business Contacts linked to Accounts BCM (Business Contact Manager) 1
J Outlook 2010 Changing events in Outlook calendar via opening file, importing CSV Using Outlook 0
O Importing Mbox - anyone out there having experience with this tool... Using Outlook 3
D Importing Outlook Categories from another domain (Exchange 2016/Outlook 2016) Using Outlook 4
B Importing business card into Outlook for SIgnature Using Outlook 1
S Importing Ribbons Not Saved Using Outlook 7
V importing appointments to non-default calendar? Using Outlook 1
Diane Poremsky Importing Lists from Excel to Outlook New Slipstick.com Articles 0
B Importing Text from Excel to Outlook 2013 Calender Using Outlook 0
Christopher M Importing from Eudora Update Using Outlook 5
Christopher M Importing from Eudora Using Outlook 7
Z Importing PST files from Outlook 07 to Outlook mac Preview Using Outlook 1
Z how to make OL (2007) to use custom contact form when importing / opening .VCF? Using Outlook 1
P Importing Thunderbird email to outlook Using Outlook 2
K Importing appointment body from excel in outlook 2010 Using Outlook 1
A Importing too many emails from Gmail Using Outlook 2
J Importing to the correct calendar from Excel 2010 to Outlook 2010 Outlook VBA and Custom Forms 2
S Possible to link to ics file without importing? Using Outlook 4
L Importing Opportunities in to BCM 2013 BCM (Business Contact Manager) 0
LarryH Importing csv file to custom form/fields? Using Outlook 3
T Importing Excel 2010 data into Outlook Calendar 2010 Using Outlook 12
W Importing .pst from Outlook 2010 (Win7) to Outlook 2013 (Win8.1) Using Outlook 2
V Importing Rules in Outlook 2013 Using Outlook 2
D Importing custom fields into custom form in BCM BCM (Business Contact Manager) 1
B importing Outlook from a backup on an external hard drive Using Outlook 5

Similar threads

Top