• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 624
  • Last Modified:

tool to convert from wordpad to excel

dear all
i need free tool to convert word pad files to excel files is that
possible please advise ?
best regards
  • 2
1 Solution
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
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.

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 ?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now