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

The Best Spinner + Excel Question

Discussion in 'Black Hat SEO Tools' started by SeanAustin, Jun 20, 2014.

  1. SeanAustin

    SeanAustin Power Member

    Joined:
    Mar 4, 2013
    Messages:
    740
    Likes Received:
    707
    Location:
    Rocky Mountains
    Have an article spun in TBS which contains several different paragraphs and now trying to generate multiple files that I will then open with Excel.

    Problem is, I want each full spin (including every paragraph in that spin) to go into a single cell in Excel, so that when I open the file with Excel, each row contains the entire spun article, including all the paragraphs.

    I seem to be stuck, where when I open the text file in Excel, each new paragraph in the spun article goes on its own separate row. I simply want each spun article to be contained in 1 row, so that if I had 100 rows, each row would contain an entire spun article.

    Anyone know how to accomplish this? Been stuck on it for the last hour now :confused:
     
  2. divok

    divok Senior Member

    Joined:
    Jul 21, 2010
    Messages:
    1,015
    Likes Received:
    634
    Location:
    http://twitter.com/divok
    this happens because excel takes new line as a different row . Excel is not made for this purpose .

    I would merge all the text files into a large text file (using cmd it is 1 sec job) or keep all text files in a folder .

    If you still want to use excel an store article in one cell , use notepad++ to remove \n\n in extended mode with some characters say ### . Then excel should save in single cell . Then while importing it remove ### with \n\n . I would say it is cumbersome and highly fragile .
     
  3. SeanAustin

    SeanAustin Power Member

    Joined:
    Mar 4, 2013
    Messages:
    740
    Likes Received:
    707
    Location:
    Rocky Mountains
    Definitely cumbersome. Couldn't get either of those methods to work :/

    Thanks for trying though, I guess I'm just going to have to do this in a very roundabout way unfortunately.
     
  4. jeremy1974

    jeremy1974 Newbie

    Joined:
    Oct 26, 2016
    Messages:
    6
    Likes Received:
    0
    Gender:
    Male
    Hi Sean, Ive found this old thread of yours and i really could do with some help, Im in exactly the same place you were at trying to get TBS to work with excel. I would be really grateful if you can you please contact me. thanks Jeremy
     
  5. jeremy1974

    jeremy1974 Newbie

    Joined:
    Oct 26, 2016
    Messages:
    6
    Likes Received:
    0
    Gender:
    Male
    Can anyone help with this project????????????????