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

Creating Text Files from lines in an Excel File

Discussion in 'Black Hat SEO' started by TopHat777, May 2, 2010.

  1. TopHat777

    TopHat777 Junior Member

    Joined:
    Jun 17, 2009
    Messages:
    192
    Likes Received:
    177
    Occupation:
    Progress
    Location:
    The Future
    Anyone know how to create a text file from a single line or a set amount of lines in an excel file.. i have a huge accounts list and I would like to be able to split it up into text files.. Is it possible to export each line in an excel file into it's own text file, or perhaps a specified amount of lines?
     
    • Thanks Thanks x 1
  2. coreyfmiller

    coreyfmiller Junior Member

    Joined:
    Apr 21, 2010
    Messages:
    154
    Likes Received:
    78
    Occupation:
    Software Analyst at Xerox
    Location:
    Canada
    Cant you just copy and paste it?
     
  3. voyevoda

    voyevoda Regular Member Premium Member

    Joined:
    Mar 21, 2010
    Messages:
    217
    Likes Received:
    97
    Location:
    Eastern Front
    I think that's what he's trying to avoid. :rolleyes:
     
  4. DebtFreeMe

    DebtFreeMe Regular Member

    Joined:
    Mar 14, 2010
    Messages:
    418
    Likes Received:
    363
    Occupation:
    Military
    Location:
    Earth
    If you use macros very much in excel, here is an article that shows and explains a macro that should do what your looking for. You will probably have to modify to fit your exact needs, but this should get you going in the right direction.

    http://www.meadinkent.co.uk/XLexport-text1.htm

    Hope this gets you doing in the right direction.
     
  5. TopHat777

    TopHat777 Junior Member

    Joined:
    Jun 17, 2009
    Messages:
    192
    Likes Received:
    177
    Occupation:
    Progress
    Location:
    The Future
    For anyone that needs to know how to do this i found the best way to do it.. just use a converter to convert the file into text.. then use a text splitter program to split the file into chunks.. easy as cake no macros.. no dumb shit.. no "copy and pasting":rolleyes: lol.. copy and paste 20,000 lines over to text files individually.. bwahahaha.. u funny little man..