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:
    178
    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:
    422
    Likes Received:
    364
    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:
    178
    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..