How to Export Unicode to CSV file with Excel 2007?

Guest

Posts: n/a

06-18-2008, 10:10 PM

I'm trying to export a worksheet that has unicode data in it. When I save as
..csv format, some of the characters show up as '?'. If I save it as unicode
(Text format), it's a tab delimted file, but with the characters intact. I'm
trying import the file into Exchange 2007. I also tried to export the
worksheet as XML, but the option under Developer was grayed out, when I tried
it through Save-As, it tells me I don't have any mappings.

I'd like to either export the file as unicode into a .csv, or as xml. Any
hints?

« batch conversion of URL text to hyperlink | repeat row name in pivot table »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
QuickBooks Pro export into Excel 2007	Lyslie	Excel Newsgroup	0	04-09-2008 04:13 PM
Excel 2007 - How to export a sheet to tab delimited text file without doublequotes	qu4dman	Excel Newsgroup	4	07-11-2007 10:42 AM
unicode pst not valid in import/export	EMERY_BILL@HOTMAIL.COM	Outlook Newsgroup	14	09-26-2006 04:18 AM
Export excel file to semicolon delimited text file	capitan	Excel Newsgroup	5	04-07-2005 02:06 AM
Re: Export Excel file to pdf or jpg	Martha	Excel Newsgroup	0	07-30-2003 10:57 PM

All times are GMT. The time now is 08:26 PM.
Microsoft Office Forums is not affiliated with Microsoft Corporation.