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

How do I import multiple .txt files to excel?

Discussion in 'General Scripting Chat' started by mindmaster, Aug 28, 2014.

  1. mindmaster

    mindmaster Jr. VIP Jr. VIP Premium Member

    Joined:
    Sep 16, 2010
    Messages:
    2,501
    Likes Received:
    1,136
    Location:
    at my new office
    Trying to import multiple articles to wordpress in one go, using csv importer plugin.
    The painful part is that I can't find a solution to import the articles in one go to the excel.
    Every article I have has the title in the name and also in the first line inside the file. From second line is the article.

    Any automatic solution to import the first line of the txt file to 1 cell and the rest of the lines in the txt file to another cell?

    Appreciated.
     
  2. divok

    divok Senior Member

    Joined:
    Jul 21, 2010
    Messages:
    1,015
    Likes Received:
    634
    Location:
    http://twitter.com/divok
    Try zipposter . Add articles in to zip archive & upload it.
     
    • Thanks Thanks x 1
  3. ardley216

    ardley216 Elite Member

    Joined:
    Mar 28, 2008
    Messages:
    2,391
    Likes Received:
    2,356
    Occupation:
    Finding easy keywords
    Location:
    1,500,000,000 Keywords Re
    Home Page:
    Just to clarify:

    You have lets say 5 text files, and then you want each text file to represent one column each in a CSV?
     
  4. ardley216

    ardley216 Elite Member

    Joined:
    Mar 28, 2008
    Messages:
    2,391
    Likes Received:
    2,356
    Occupation:
    Finding easy keywords
    Location:
    1,500,000,000 Keywords Re
    Home Page:
    ^^ Wait, I think I get what you mean.. you only want the first line of the text file to be in the first cell, then the rest of the text file to be in the next cell.

    I used SEO Content Machine to upload bulk articles, you can get a 5 day free trial that you can renew with a new free acount, but keeps all your data :)

    hope that helps.
     
    • Thanks Thanks x 1
  5. mindmaster

    mindmaster Jr. VIP Jr. VIP Premium Member

    Joined:
    Sep 16, 2010
    Messages:
    2,501
    Likes Received:
    1,136
    Location:
    at my new office
    Thanks to both of you.
    You saved me tons of time.
     
  6. gary2

    gary2 Jr. VIP Jr. VIP Premium Member

    Joined:
    Jan 20, 2013
    Messages:
    971
    Likes Received:
    82
    Occupation:
    Inbound Marketer. Blogger. Author.
    Location:
    Near River
    you can also try codex...its in wordpress itself