How to import emails from txt file to excel?

Posted on 2011-05-03
Last Modified: 2012-05-11
I have a list of emails that are dumped from contacts to a text file.
There are many emails listed and thee must be an easier way to place these items into an excel file.

"First Name Last Name" <email address>, "First Name Last Name" <email address>,...etc  
some items are just listed as <email address>, <email address>,

How do i take that information running together in a txt file and import it into a excel file so each item is in its own cell?

Question by:Admin_Stooge
    LVL 8

    Expert Comment

    What are you exporting them from?
    LVL 51

    Expert Comment

    is this one time job or you need an automation?
    LVL 51

    Accepted Solution

    I am using UltraEdit (you can install 45 days trial version)

    added this to a new document

    "First Name Last Name" <email address1>, "First Name Last Name" <email address2>, <email address3>, <email address4>

    Ctrl + R : replace : ", " with "^p"

    it produced this

    "First Name Last Name" <email address1>
    "First Name Last Name" <email address2>
    <email address3>
    <email address4>

    then I can copy paste it into excel and use text to columns

    does your input contains "<" & ">" characters as well?


    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now