.csv spreadsheet To Normal Excel Spreadsheet Format: How Please?


B

Bob

Hello,

Using Excel 2007.

I have a .csv formatted spreadsheet I downloaded.

Is there any "straightforward" way to convert this to the normal Excel
configuration format ?

Thanks,
Bob
 
Ad

Advertisements

D

Dave Peterson

Open the file in excel.
Save the file as a .xlsx (or .xlsm if you add macros).
 
B

Bob

Open the file in excel.
Save the file as a .xlsx (or .xlsm if you add macros).
Hi Dave,

As always, thanks for help.

Heres what part of what the original .csv file looks like:

279;0000-2400;;BLR;Belaruskoye Radio 1;BY;EEu;;1;;
567;0600-0700;;LAO;Lao National Radio;HM;SEA;;1;;
567;0700-0800;;LAO;Lao National Radio;KHM;SEA;;1;;


And this is what I have after Saving it in the regular Excel 2007 format:

279;0000-2400;;BLR;Belaruskoye Radio 1;BY;EEu;;1;;
567;0600-0700;;LAO;Lao National Radio;HM;SEA;;1;;
567;0700-0800;;LAO;Lao National Radio;KHM;SEA;;1;;

Looks like exactly the same.

Also tried other individual Save As as the .xlsx, although I believe
that this is the format that it saves in when you tell it to do the
regular Excel 2007 Format. It too looks like the second block, with no
apparent change from the .csv

Would like to try to get the data between the semi-colons separated
into their own columns.

Any thoughts as to why, or what else I might try ?

Best regards, and thanks again,
Bob
 
B

Bob

Hi,

Figured it out.
Will blame it on old age.

Thanks for help,
Bob
-----------------------
 
Ad

Advertisements

D

Dave Peterson

Just to be complete...

One approach would be to open that file -- and all the text went into column A,
right?

Then select column A
Data|Text to columns
Delimited by semi-colon
and finish up the wizard (specifying any field you need to)

And then save that file as an excel file.
 

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

Top