+ Post New Thread
Results 1 to 3 of 3
How do you do....it? Thread, Converting a whole bunch of data from website to CSV (without manual input) in Technical; Hi all Got some MET data for a lesson later but its currently stuck on the met website http://bit.ly/imoLEw . ...
  1. #1
    titch's Avatar
    Join Date
    Feb 2007
    Posts
    170
    Thank Post
    102
    Thanked 8 Times in 7 Posts
    Rep Power
    17

    Converting a whole bunch of data from website to CSV (without manual input)

    Hi all

    Got some MET data for a lesson later but its currently stuck on the met website http://bit.ly/imoLEw. Anyone know an easy way I can get this into excel so that all the data is in individual cells? I assumed there must be some sort of CSV conversion tool available? Anyone help on this one would be cracking.

    Cheers All

  2. #2

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,381
    Thank Post
    525
    Thanked 2,615 Times in 2,021 Posts
    Blog Entries
    24
    Rep Power
    891
    Use the 'Text to Columns' feature in Excel, works a treat.

  3. Thanks to localzuk from:

    titch (27th May 2011)

  4. #3
    titch's Avatar
    Join Date
    Feb 2007
    Posts
    170
    Thank Post
    102
    Thanked 8 Times in 7 Posts
    Rep Power
    17
    Legend...That has saved me ( or a few volunteer children) lots of time. I never new that feature existed. Now I have learned something new does it mean I can go home?



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 2
    Last Post: 16th February 2011, 10:24 AM
  2. Publishing/Presenting .CSV data
    By steele_uk in forum How do you do....it?
    Replies: 2
    Last Post: 30th November 2009, 11:44 AM
  3. HP Laserjet 2300 Service Manual/Maintenance Kit Manual
    By markwilliamson2001 in forum Hardware
    Replies: 2
    Last Post: 17th October 2007, 03:24 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •