I received a file that is saved as a .CSV format. How would I change this
into the .XLS (normal Excel) format without having all the data jumbled up?

"acyakos" wrote in message
...
I received a file that is saved as a .CSV format. How would I change this
into the .XLS (normal Excel) format without having all the data jumbled
up?

How is the data jumbled up? Excel can open csv files.

/Fredrik

Frank-

When I try to open the file, a text import wizard pops up, however, there
are a bunch of commas and everything is in one column. I don't want any of
the commas in there and I want it to be in separate columns. Hopefully this
is clear...

Thanks for your help!

"Fredrik Wahlgren" wrote:


"acyakos" wrote in message
...
I received a file that is saved as a .CSV format. How would I change this
into the .XLS (normal Excel) format without having all the data jumbled
up?

How is the data jumbled up? Excel can open csv files.

/Fredrik

"acyakos" wrote in message
...
Frank-

When I try to open the file, a text import wizard pops up, however, there
are a bunch of commas and everything is in one column. I don't want any
of
the commas in there and I want it to be in separate columns. Hopefully
this
is clear...

Thanks for your help!


Change the extension from .csv to .txt and open the file from Excel.
Hopefully, the guide will let you separate the values correctly.

/Fredrik

Open in Excel as csv file, Select Column A, Choose Data Text to Columns --
select , as delimiters


"acyakos" wrote in message
...
: Frank-
:
: When I try to open the file, a text import wizard pops up, however, there
: are a bunch of commas and everything is in one column. I don't want any of
: the commas in there and I want it to be in separate columns. Hopefully this
: is clear...
:
: Thanks for your help!
:
: "Fredrik Wahlgren" wrote:
:
:
: "acyakos" wrote in message
: ...
: I received a file that is saved as a .CSV format. How would I change this
: into the .XLS (normal Excel) format without having all the data jumbled
: up?
:
: How is the data jumbled up? Excel can open csv files.
:
: /Fredrik
:
:
:

acyakos wrote:
I received a file that is saved as a .CSV format. How would I change this
into the .XLS (normal Excel) format without having all the data jumbled up?



Step 1: Read the CSV file into Excel

Step 2: SaveAs an XLS file.

Bill