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

  • Thread starter Thread starter Bob
  • Start date Start date
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
 
Open the file in excel.
Save the file as a .xlsx (or .xlsm if you add macros).
Click to expand...
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
 
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.
 
Back
Top