Converting xls format to csv format

[Srinivas Acharya]

Hi,
I am trying to convert excel file (xls format), which
contains name and respective e-mailn ids, to csv format.
My goal is to convert this excel file to csv format so
that I can import all the e-mail ids in outlook using this
csv file. But when I try to save this excel file in csv
format it says "this feature is not supported in csv
format". But I get a csv file with which I can't import
those e-mail ids into address book. I don't know what is
the problem. I used to do this earlier. But now it is not
happening. Any help will be appreciated.

Thanks in advance,
Srinivas Acharya

 

[Andy B]

Hi

Check your spreadsheet to see if it contains merged cells.

Andy.

 

[Paul]

Hi,
I am trying to convert excel file (xls format), which
contains name and respective e-mailn ids, to csv format.
My goal is to convert this excel file to csv format so
that I can import all the e-mail ids in outlook using this
csv file. But when I try to save this excel file in csv
format it says "this feature is not supported in csv
format". But I get a csv file with which I can't import
those e-mail ids into address book. I don't know what is
the problem. I used to do this earlier. But now it is not
happening. Any help will be appreciated.

Thanks in advance,
Srinivas Acharya

Why do you need to convert to csv? Outlook will import direct from xls.

 

[Srinivas Acharya]

Thanks for replying.
How to check that and how to remove that from excel.
Thanks in advance.
Regards,
Srinivas Acharya

 

[Guest]

Hi,
Thanks for replying.
Is it ?. I am not sure about it. Let me try and get back
to you.

 

[Dave Peterson]

hit ctrl-A to select all the cells on the sheet
format|cells|Alignment tab

Look at the "merge cells" box under Text control.

If it's got a solid black checkmark, the whole selection is merged (very
unlikely when you have the all the cells selected!).

But if it's got a grey checkmark, then there are some merged cells in the
selection.

If all you want to do is get rid of those, just uncheck that "merge cells" box.

Here's one way via a macro that looks at all the cells in the usedrange:

Option Explicit
Sub testme02()

Dim myCell As Range
Dim resp As Long

For Each myCell In ActiveSheet.UsedRange
If myCell.MergeCells = True Then
If myCell.Address = myCell.MergeArea.Cells(1, 1).Address Then
resp = MsgBox(Prompt:="found at: " _
& myCell.Address(0, 0) & " Of " _
& myCell.MergeArea.Address(0, 0), _
Title:="Continue Looking?", _
Buttons:=vbYesNo)
If resp = vbNo Then
Exit Sub
End If
End If
End If
Next myCell

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Srinivas Acharya]

Hi,
I tried with MS Outlook. I am able to import uisng excel
file. I am not able to import in outlook express. It needs
csv format.

Please help
Thanks in davance
Srinivas