excel to csv

  • Thread starter Srinivas Acharya
  • Start date
S

Srinivas Acharya

Hi,
I checked for merged cells. There are no merged cells. But
I need not convert excel to csv for importing into MS
Outlook. It is only required for outlook express.
Any help will be appreciated.
 
D

Dave Peterson

Does that message really say: "this feature is not supported" or does it say:
xxxx.csv may contain features that are not compatible with CSV"?

If it's the second, then excel is just warning you that you're probably losing
formatting/formulas, etc.

When I save to .csv files, I save my file as .xls (and use that for updates),
then save again as .csv (just to get the .csv file).

Have you used notepad to look at your .csv file. Do you have an older version
that worked that you could also open to compare with the new version?
 
S

Srinivas Acharya

Hi,
Thanks for replying. I didn't get you. I am not able to
save th excel file in csv format. If try to save blank
excel sheet to csv format also, it gives the
error "xxxx.csv may contain features that are not
compatible with CSV""?
Please help me.
Thanks in advance,
Regards,
Srinivas
 
D

Dave Peterson

Try this against a test worksheet.

Put some test data in A1:e10
Format it nicely--bolds, colors, underlines, borders, etc.

Now save it as .xls (normal).

Now save it as .csv. (Answer Yes to the prompt.)

close the workbook
reopen the .xls--all the formats stayed and showed up again.
Reopen the .csv--none of the formats stayed put.

These are the kind of features that you lose.

Try opening that .csv file in Notepad--it's just plain text. This kind of file
is good for exchanging data between programs that don't read each other's native
formats.
 
S

Srinivas Acharya

Hi,
I think you are not understanding my requirement. My
requirement is that I have Name column and e-mail address
column in excel sheet. I am able to import this one into
contacts folder of MS outlook after specifying the range.
But I can't import these addresses into outlook express
using excel file. I have to create csv file for that. If I
create csv file, it says the feature is not supported. If
I save the excel file in csv format by bypasing the error
message. I can import only names not e-mail addresses.
Please help me.
Thanks in advance.

Regards,
Srinivas.
 
D

Dave Peterson

Did you try saving it as .csv and then importing it to Outlook?

If you did, what happened during the import to Outlook.

I put a name in A1 and an email address in B1. Excel converted that email
address to a hyperlink.

When I did a File|SaveAs, I got that warning message. But the file looked like:

dave,[email protected]

It was a nice ASCII comma separated file.

But the feature I lost is the hyperlink. I can't just click on [email protected]
and have my email program start. This is true if I click on it in Notepad or
close the file and reopen it in excel.

Give it a try and see what happens.
 
S

Srinivas Acharya

Hi,
I got it. i.e
dave,[email protected]
Click to expand...

But It is not solving my purpose. I can import only names
but not e-mail ids into the addressbook of outlook express.
Let me know your views.

Regards,
Srinivas.
-----Original Message-----
Did you try saving it as .csv and then importing it to Outlook?

If you did, what happened during the import to Outlook.

I put a name in A1 and an email address in B1. Excel converted that email
address to a hyperlink.

When I did a File|SaveAs, I got that warning message. But the file looked like:

dave,[email protected]

It was a nice ASCII comma separated file.

But the feature I lost is the hyperlink. I can't just
Click to expand...
click on [email protected]
 
D

Dave Peterson

I use OE6.x and this worked for me.

Create the .csv file.
Open OE
File|Import|Other Address Book
text file (comma separated values)
point at the .csv file that you made

map the fields to OE's fields.
I used lastname and email address for my 2 fields.
(make sure you check each of those boxes to say you want each field imported)

continue through the wizard.

Mine came back with a successful message.

You may want to open the .csv in notepad to verify that it's what you expected.
 
Top