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

How do I extract text from a spreadsheet to text?

Discussion in 'Black Hat SEO Tools' started by Ranko Jones, May 25, 2011.

  1. Ranko Jones

    Ranko Jones BANNED BANNED

    Joined:
    Mar 3, 2011
    Messages:
    1,677
    Likes Received:
    146
    I have keyword lists and a sb list or two which are in xml format but being a spreadsheet noob I don't know how to get them from that into a normal .txt file to use in scrapebox.

    I tried copy and paste but it pulls the table over as well.

    I'm using open office for the record.

    I also tried some advised remove formatting thing but that didn't work either...
     
  2. chucka95

    chucka95 Newbie

    Joined:
    Aug 19, 2009
    Messages:
    39
    Likes Received:
    10
    The easiest way to do it is to highlight the column you want to copy over, control C (or copy), open notepad and control-V to paste it into Notepad.

    Notepad is a plain text editor and the tables/cells don't carry over.

    I just tested it with Open Office and Notepad and it worked for me.
     
  3. RalphyBoy

    RalphyBoy Regular Member

    Joined:
    Jul 19, 2008
    Messages:
    378
    Likes Received:
    52
    Use "Paste Special" from the top menu.

    Has to be the top menu, not a right click as the option won't appear.
     
    Last edited: May 25, 2011
  4. Ranko Jones

    Ranko Jones BANNED BANNED

    Joined:
    Mar 3, 2011
    Messages:
    1,677
    Likes Received:
    146
    Oh, yea; doh!

    See I think I tried that but must have done it in wordpad cos the boxes kept coming.

    I have another query....

    How would I add words on a large scale to a document.

    For instance I have the list of keywords and I want to add intitle: before each of them and " " around each. If it's a long keyword list how could I do it?

    Is there an automated way similar to the replace function? I'm thinking it'd be harder to do since with replace it's easy cos you're just telling it to replace with what was already there so it already know where to look but in this case I'm not sure how you'd tell it where to add those things en masse.
     
  5. Janusz

    Janusz Registered Member

    Joined:
    Jun 3, 2009
    Messages:
    81
    Likes Received:
    86
    Location:
    Exile
    Menu - tools - scrapebox text editor
     
  6. jannat8

    jannat8 Registered Member

    Joined:
    May 18, 2011
    Messages:
    86
    Likes Received:
    2
    I'm thinking it'd be harder to do since with replace it's easy cos you're just telling it to replace with what was already there so it already know where to look but in this case I'm not sure how you'd tell it where to add those things en masse.
     
  7. pigp3n

    pigp3n Newbie

    Joined:
    May 23, 2011
    Messages:
    41
    Likes Received:
    6
    save the whole file as a CSV file. Then open the CSV file in wordpad and do a replace all and replace the commmas with blankspaces.