+ Reply to Thread
Results 1 to 5 of 5

Copy/Paste - From a website to Excel

  1. #1
    Registered User
    Join Date
    08-08-2010
    Location
    Athens
    MS-Off Ver
    Excel 2007
    Posts
    3

    Copy/Paste - From a website to Excel

    Hello everyone and nice to meet you,

    I'm a noob and I find the excel world really fascinating. I wonder if there's an easy way to solve my problem:

    I'm copying a number of lines from a website and I'm pasting them in excel. Instead of pasting them as lines, I get one really long line of everything I copied. To be more specific, I'm copying basketball stats from this site (the player stats below). When I paste them, I get them all in one line.

    Is there a way to paste them without losing the initial form (rows & columns) they have in the website?

    Thank you in advance

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Copy/Paste - From a website to Excel

    hmmmm when i copy/paste them it comes out like this
    Attached Files Attached Files
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Copy/Paste - From a website to Excel

    Hi,
    There is a feature in Excel called Data -> From Web. See the attached that took about 10 seconds to perform.
    1. Run Excel
    2. Click on Data Tab and From Web
    3. You'll need the URL from the page you want and paste it in the excel url box.
    4. Click on the little yellow arror just above the stats
    5. Click on Import and WALLAAAAA.....
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-08-2010
    Location
    Athens
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Copy/Paste - From a website to Excel

    Wow! I use excel 2007 and all I get is one line. This could help me a lot, why do we get different pastes? :-/

  5. #5
    Registered User
    Join Date
    08-08-2010
    Location
    Athens
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Copy/Paste - From a website to Excel

    Marvin thanks! It worked!

    Gotta love this forum.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1