Opening/Importing a csv file in Excel v.X

Hi Jan,

Have tried that - the file is dimmed. The file is defiantely ok, PC =
Excel=20
users have no problem opening the file.

V.

 >-----Original Message-----
 >
 >In the File selector box the topmost menu:
 >Show: All Readable Documents
 >
 >Jan
 >
 >
 >On 2003-11-07 3:26, in article=20
044501c3a4d6$9d47a260$a601280a@phx.gbl,
 >"Vicktor" <anonymous.DeleteThis@discussions.microsoft.com> wrote:
 >
  >> Hi,
  >>=20
  >> I cant open a csv file in Excel. I have tried File Open, and Import
  >> TextFfile. The file is always dimmed. I also tried Get Info/Open=20
with,
  >> and the Excel option is dimmed.
  >>=20
  >> I'm using Excel SR1 and OS X 10.2.8
  >>=20
  >> any ideas anyone?
  >>=20
  >> Vicktor
 >
 >.
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Opening/Importing a csv file in Excel v.X 

Vicktor,

Add the suffix ".xls" to the comma delimited file and Excel will recognize
and open same. I had the same problem just this AM.

J.P.
 >> Stay informed about: Opening/Importing a csv file in Excel v.X 

Ok, dimmed or not try to select and open.
I just tested with a image.jpg show dimmed, even with
Show: All Documents
But just selct and it opens and let you choose the delimiters and so on.
So, just (try to) open, dimmed or not

Jan


On 2003-11-07 22:54, in article 044201c3a579$b3aea960$a301280a@phx.gbl,
"anonymous@discussions.microsoft.com" <anonymous RemoveThis @discussions.microsoft.com>
wrote:

 > Hi Jan,
 >
 > Have tried that - the file is dimmed. The file is defiantely ok, PC Excel
 > users have no problem opening the file.
 >
 > V.
 >
  >> -----Original Message-----
  >>
  >> In the File selector box the topmost menu:
  >> Show: All Readable Documents
  >>
  >> Jan
  >>
  >>
  >> On 2003-11-07 3:26, in article
 > 044501c3a4d6$9d47a260$a601280a@phx.gbl,
  >> "Vicktor" <anonymous RemoveThis @discussions.microsoft.com> wrote:
  >>
   >>> Hi,
   >>>
   >>> I cant open a csv file in Excel. I have tried File Open, and Import
   >>> TextFfile. The file is always dimmed. I also tried Get Info/Open
 > with,
   >>> and the Excel option is dimmed.
   >>>
   >>> I'm using Excel SR1 and OS X 10.2.8
   >>>
   >>> any ideas anyone?
   >>>
   >>> Vicktor
  >>
  >> .
  >><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Opening/Importing a csv file in Excel v.X 

"J. P. Sheehan" <jpsheehan.TakeThisOut@pacbell.net> wrote in message news:<BBD1B091.4356%jpsheehan@pacbell.net>...
 > Vicktor,
 >
 > Add the suffix ".xls" to the comma delimited file and Excel will recognize
 > and open same. I had the same problem just this AM.
 >
 > J.P.

I was having the same problem opening .csv files with Office X. If I
change the extension to .xls it pops up the wizard and asks me to
select the delimiter and other things. However, if there is a newline
one of the fields it will cause excel to treat the newline as another
row. This is resolved on windows by opening the file with .csv as the
extension and bypassing the wizard. How can I do this on the mac if it
doesn't allow me to open a .csv file.

Jay<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Opening/Importing a csv file in Excel v.X 

Jay Donnell <jaydonnell DeleteThis @yahoo.com> wrote:

 >
 > I was having the same problem opening .csv files with Office X. If I
 > change the extension to .xls it pops up the wizard and asks me to
 > select the delimiter and other things. However, if there is a newline
 > one of the fields it will cause excel to treat the newline as another
 > row. This is resolved on windows by opening the file with .csv as the
 > extension and bypassing the wizard. How can I do this on the mac if it
 > doesn't allow me to open a .csv file.


The way I usually do it is that I open the file in a text editor (BBEdit
in my case) and simply replace commas with tabs. It's a bit silly not to
be able to do it directly, but at least, like that it works.

Corentin


--
--- Mac:MS MVP (Francophone) ---
(MS) MVP: <a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/" target="_blank">http://mvp.support.microsoft.com/</a>
MVPs.org: <a style='text-decoration: underline;' href="http://www.mvps.org/" target="_blank">http://www.mvps.org/</a>
Retirez NoSpam de mon adresse pour m'écrire/Remove NoSpam to e-mail me<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Opening/Importing a csv file in Excel v.X