Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


tool to convert from wordpad to excel

Posted on 2011-11-01
Medium Priority
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
  • 2
LVL 31

Expert Comment

ID: 37061006
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

Accepted Solution

Wiesje earned 2000 total points
ID: 37061014
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 31

Expert Comment

ID: 37061016
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

578 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