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

[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

 

[Dave Peterson]

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

 

[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

 

[Bob]

Hi,

Figured it out.
Will blame it on old age.

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

 

[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.