.CSV File into .XLS file

A

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?
 
F

Fredrik Wahlgren

acyakos said:
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
Click to expand...
up?

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

/Fredrik
 
G

Guest

acyakos said:
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?
Click to expand...



Step 1: Read the CSV file into Excel

Step 2: SaveAs an XLS file.

Bill
 
A

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!
 
F

Fredrik Wahlgren

acyakos said:
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!
Click to expand...

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

/Fredrik
 
L

Lady Layla

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


: 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:
:
: >
: > : > > 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
: >
: >
: >
 
Top