1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Combine/compare spreadsheets?

Discussion in 'Black Hat SEO Tools' started by Ampix0, Jan 30, 2014.

  1. Ampix0

    Ampix0 Power Member

    Joined:
    Jan 10, 2012
    Messages:
    525
    Likes Received:
    60
    Home Page:
    If I have two speadsheets. One with multiple columns and some rows have missing data. So if I have spreadsheet one with 10 fields and two of them are "Email" and "Website" and lets say, quite a few are missing email data.

    Now I have spreadsheet 2 which only has 2 columns; "Email" and "Website".

    So can I merge these so that everywhere "Website" on spreadsheet 2 matches spreadsheet 1, it fills in the missing email data?


    For example:

    Spreadsheet 1:
    [​IMG]

    Spreadsheet 2:
    [​IMG]

    How could I take those two and merge them correctly.
     
  2. divok

    divok Senior Member

    Joined:
    Jul 21, 2010
    Messages:
    1,015
    Likes Received:
    634
    Location:
    http://twitter.com/divok
    Install xlst libraries for python , or convert the files to csv format . And then process them with the required logic and conditions , then convert back to original form . You could also try any other language , don't know if you can do this within excel or not .
     
  3. Ampix0

    Ampix0 Power Member

    Joined:
    Jan 10, 2012
    Messages:
    525
    Likes Received:
    60
    Home Page:
    So basically you are saying to make some kind of program for this?