tool to convert from wordpad to excel

Posted on 2011-11-01
Last Modified: 2012-05-12
dear all
i need free tool to convert word pad files to excel files is that
possible please advise ?
best regards
Question by:nettech1998
    LVL 29

    Expert Comment

    simply change the extention of the file from .txt to .xls
    make sure you make a copy of the file so you keep the original .txt
    LVL 8

    Accepted Solution

    Depending on the version of Excel you are using - you can just copy and paste the wordpad information into an excel sheet (from Excel 2007 onwards). Earlier versions of Excel will not be nice to the formatting.

    Other than just copying and pasting it - you can also use the import function in Excel.
    You find that under Data and depending on the version of Excel you use, you will most likely find it under: Import External Data, Import Data. In Excel 2010 you find it on the Data ribbon, to the left, External Data and then use the wizard import.

    You then locate the file you want to convert, set the delimeters and formats for the columns and then you click on import.

    LVL 29

    Expert Comment

    A small alteration to my proposal, word pad by default will save as .rtf you can choose to save as .txt and the use the .xls as mentioned. Maybe you would loose the format not sure you need to try. Anyway what is the purpose of doing so ? and is it data or text or ?

    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

    Suggested Solutions

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    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

    20 Experts available now in Live!

    Get 1:1 Help Now