excel to csv

  • Thread starter Thread starter Srinivas Acharya
  • Start date 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.
 
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
 
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.
 
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.
 
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 (e-mail address removed)
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.
 
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 (e-mail address removed)
 
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.
 
Back
Top