converting web .txt or .dat file into an xls file

I am crunching data and need to convert the data from the website

http://lasp.colorado.edu/sorce/tsi_data/daily/sorce_tsi_L3_c24h_latest.txt 

to a xls file. How would I do that?

 Also I am looking at data from this website and need to convert the files to xls format as well.  http://lasp.colorado.edu/sorce/tsi_data/daily/sorce_tsi_L3_c24h_latest.txt
libertyforall2Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NorieAnalyst Assistant Commented:
Aren't they the same page with the same data?

Anyway, does the data begin after the ***DATA RECORDS*** line?

If it does you could just open the file in just as it is, then delete everything above the data and use Data>Text to columns... to separate the data out into columns.

You can then parse the date based on the specification, which is the here on the page.

;***DATA DEFINITIONS***
 ' specification
; ***END DATA DEFINITIONS***

Have you got anywhere with this?

eg downloaded the data to a file?
0
mwochnickCommented:
do you need to do this one time or on a continuing basis? if one time - follow the instructions above - making sure that in the text to columns you select delimited and space as the delimiter when doing the text to columns step.

If you need to do it in an on going basis, I'd suggest either writing a simple perl scripts to read the files from the website and output the file into a csv file which can be easily opened by Excel
0
NorieAnalyst Assistant Commented:
mwochnick

It be done in Excel if it is on an ongoing basis.

I was going to post code for it but wanted to make sure what was needed first.

I suppose it would be preferable to use something like perl though.
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

mwochnickCommented:
You could write a vb macro for Excel as well :)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
libertyforall2Author Commented:
I have resolved the issue by using my mac instead of pc. I simply downloaded the file as a txt file and uploaded it to a linux account then used cat to join the files. I'm still looking to average the files per month. See my other questions.
0
NorieAnalyst Assistant Commented:
mwochnick

A vb macro? I was actually thinking of doing it with VBA, no macros.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.