Exporting in contacts in .CSV format

P

Patrick Younan

I'm working with Entourage 04. I'm trying to export my contacts to
Plaxo.com, which requires a .csv format (comma-separted value). How do I
export my contacts in that format. The export assistant doesn't give me
that option and I've tried downloading to excel, which is hard and not that
good. Thanks.
 
D

Dave Cortright

I'm working with Entourage 04. I'm trying to export my contacts to
Plaxo.com, which requires a .csv format (comma-separted value). How do I
export my contacts in that format. The export assistant doesn't give me
that option and I've tried downloading to excel, which is hard and not that
good. Thanks.
Click to expand...
Export to a tab-delimited file, open in Word, then find and replace tab with
comma
 
P

Paul Berkowitz

Export to a tab-delimited file, open in Word, then find and replace tab with
comma
Click to expand...

If it's a Windows-oriented program, the comma-delimited format will also
have "double-quotes" around every delimited item, and special escaping for
quotes within the items. Excel knows all about that formatting.

I expect that you'll probably get better results opening the tab-delimited
file in Excel, then immediately save as Comma Separated Values. Experiment
as to whether it may want the CSV (Windows) version, also available in
Excel's Save As dialog, instead. (It may not.) Don't do any Find/Replace.
Just Save As CSV.

If there are still problems - for example it _is_ Windows-oriented and even
when you save as CSV (Windows) all the "special" characters are wrong,
punctuation is odd, serious problems arise with carriage returns in the
Notes field (replaced by spaces), etc., you might want to look at my
Export-Import Entourage X scripts from

MacScripter.net <http://macscripter.net/scriptbuilders/>

There are scripts that export as tab-delimited (but include categories) and
companion "Outlook Converter" scripts that convert them to Windows CSV files
with all the special characters, carriage returns in Notes, etc. all taken
care of correctly.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.
 
Top