Move Data Table to Excel

Discussion in 'Software' started by jhep3304, Mar 9, 2013.

  1. jhep3304

    jhep3304 Private E-2

    Need free Software to move Table Data from articles to Excel Spreadsheets.
    Tried copy/paste but seldom get usable results. Would this be a FTP program?
    Using Windows 7 Pro, Office 2010.
     
  2. pwillener

    pwillener MajorGeek

    Not sure what you mean by "Table Data from articles"; are these online articles with HTML tables?
     
  3. jhep3304

    jhep3304 Private E-2

    Yes to online. From articles that I can copy/paste to Microsoft Word as "unformatted text". If I hilite the data tables and attempt to paste to Excel it sometimes is usable but needs a lot of editing. There used to be a FTP program that would do this.
     
  4. usafveteran

    usafveteran MajorGeek

    Can you post a link to an article containing a table of the type you to move into Excel?
     
  5. jhep3304

    jhep3304 Private E-2

    Not really. This is not an ongoing effort. Just occasional and I haven't used it yet this year.
     
  6. pwillener

    pwillener MajorGeek

    What I would do if I needed to do this
    1. open the page source
    2. copy the html table
    3. paste it into Notepad and save it as a .html doc
    4. open that file with Excel
    5. save it as an Excel doc
     
  7. jhep3304

    jhep3304 Private E-2

    Bingo!. I was able to do that. Thanks
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds