.CSV File into .XLS file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert csv to Excel files 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
how do I change a csv extension file to an xls file and use it? 1
Excel And Notepad 3
Excel CSV Files; Creating Of 3
Save as csv file option missing from Excel 2007 3
Conditional formatting causing Excel to crash 3
Save as Command Line 1

Back
Top