.CSV File into .XLS file

[acyakos]

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?

[Fredrik Wahlgren]

"acyakos" <acyakos@discussions.microsoft.com> wrote in message
news:DB45C4DC-677A-49E4-8E01-4B51C437AFF8@microsoft.com...
> 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

[Bill Martin -- (Remove NOSPAM from address)]

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

[acyakos]

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" <acyakos@discussions.microsoft.com> wrote in message
> news:DB45C4DC-677A-49E4-8E01-4B51C437AFF8@microsoft.com...
> > 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
>
>
>

[Fredrik Wahlgren]

"acyakos" <acyakos@discussions.microsoft.com> wrote in message
news:2129F78B-68CE-4EB3-B00B-18CD9C972843@microsoft.com...
> 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

[Lady Layla]

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


"acyakos" <acyakos@discussions.microsoft.com> wrote in message
news:2129F78B-68CE-4EB3-B00B-18CD9C972843@microsoft.com...
: 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" <acyakos@discussions.microsoft.com> wrote in message
: > news:DB45C4DC-677A-49E4-8E01-4B51C437AFF8@microsoft.com...
: > > 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
: >
: >
: >