How To Convert A Text File To An Excel File

Image by

Have you ever encountered a situation whereby you want to convert some text files either from a website or a note pad into an Excel file? I remember the first time I encountered that and I felt it is quite impossible. Well, it isn’t. In this tutorial, we are going to show you how to accomplish that with the different versions of office available.

It is worthy of note that saving your text file as an Excel spreadsheet allows you to work with your data more easily. You will encounter less error working with Excel than with a text file. Let us look at how you can carry out this conversion.

A text file can be converted into a spreadsheet file using the following versions of Excel:

  • 2003
  • 2007
  • 2010


How To Convert From Text To Excel

Using Microsoft Excel 2003

Follow these steps to effectively convert your text file into an Excel file using this version of Excel.

  • The first step is to open your Microsoft Excel.
  • Click on data, then import external data and then import data.
  • Open the file you created in Notepad. A wizard will display.
  • From the wizard, select Delimited and click Next button.
  • Uncheck the tab that appears and select space instead. Click next after that.
  • Click Finish and Ok.
  • On your Excel toolbar, select file, then Save As.
  • Type the new name for your file in the dialog box that pops up.
  • It will ask you to save as what. Choose Excel Workbook (xlsx), Excel 97-2003 Workbook (.xls), or CSV (Comma Delimited) (.csv) and click Save.
Image by


Using Microsoft Excel 2007

Here are the steps.

  • Open your Microsoft Excel 2007.
  • Select that data tab.
  • Click from text.
  • Proceed to browse for the text file and select it when you see it.
  • Click on the import button. The Text Import Wizard will begin after that.
  • From the wizard, select Delimited and click Next button.
  • Uncheck the tab that appears and select comma. Click next after that.
  • Click the finish button once you are done.
  • Choose to save the information in either an existing worksheet or a new worksheet.
  • On your Excel toolbar, select file, Save As and type the name in the dialog box that pops up.
  • Save as type should be Excel Workbook (xlsx).


Using Microsoft Excel 2010

Here are the steps for this version of Excel.

  • Open your Microsoft Excel.
  • Find the data tab and click on it.
  • Check out the External Data group and click From Text.
  • Double-click the text file that you want to import in the Import Text File dialogue box.
  • After that, click on import. The text import wizard will launch after that.
  • Select Delimited and click Next.
  • Uncheck the tab that appears and select comma instead. Click next after that.
  • Click the Finish button and select to save the information in either an existing worksheet or a new worksheet.
  • Once you are done with that, go to your Excel toolbar, select File > Save As and type the name of the file in the dialog box that pops up.
  • Under Save As Type, choose Excel Workbook (xlsx).

These steps will allow you to effectively convert text files to Excel files. Once this conversion is done, you can be able to work with your data easily.

Want to get in touch with us? Hit us up on our social media channels!

Tips On How To Backup And Save Your Text Messages

Tips On How To Backup And Save Your Text Messages
Image Credit by =

With smartphones in the hands of people all over the world now, everyone uses them to communicate, especially via text messages. These tips on how to backup and save your text messages can be really helpful if send out a lot of SMS. Best of all, you can do so whether you use IOS or an Android device.

Sending out SMS messages  is a great way to instantly stay in touch with friends and family members no matter where they are. But if you send out a lot of text messages – and most people do – chances are that they will start to add up and take up space quickly.

This is even more so since some people send out pretty long text messages. They also have extensive conversations with those they talk to via texts. Apart from taking up space on your phone, it is also prudent to be able to save your conversations just in case. You can lose your phone or something along those lines where you no longer have access to your history of conversations.

Luckily, there are several ways for you to be able to backup and save your text messages. Some tips require a bit more work or tech savvy than others. However, if you just want something really simple, then there are some ways below to do so as well.


Thinking about getting rid of your phone? Here are 8 Things You Should Do Before Selling Your Phone


Using Gmail Account –

For those that have an Android device, backing up their text messages using their Gmail account it’s really simple. Moreover, being able to use this method allows users to use their Gmail account as an SMS storage vault.

The first thing you need to do is configure your Gmail account so that it can have IMAP access. That’s because the SMS backup process requires IMAP access to the Gmail account in order to work.

The second step is configuring the SMS backup using the App from the Google Play Store. Download the app and once it is installed you follow the screen info and features for toggling the process. You can do automatic backups if you prefer as well as other useful functions. The instructions are pretty basic and easy to follow.


Save Texts On iOS –

For those that have Apple iPhones or are using iOS, they can backup their SMS messages using iTunes. The process is simple to do since most Apple users are already quite familiar with the iTune app.

First, connect your phone or device to your computer and in iTunes, click the icon which corresponds to your device.

Once you see the section labeled ‘Backups’ on the Summarytab, click on the ‘Manually Back Up and Restore‘ option. Select the ‘Back Up Now‘ option and you are done.

Once your text messages are saved, you can then simply use iExplorer to access all of your backed up SMS.


Use Other Apps –

For some people who don’t really want to use either of the options above, they can simply choose to use different applications. There are several apps available both for Android and iOS devices which help you save your SMS messages. Some of those apps are My Backup Pro, MySMS and Morobobo. Keep in mind those are all for Android devices. Apple has SMS Export and iMobie AnyTrans apps for their users, among others.


Hey do you ever wonder Is Your Cell Phone Listening To Your Conversations?


No matter what device, app or tactic you use to save your SMS messages, backing them up is something everyone should do. Some people wait until the lose their devices to begin to inquire oh how to do so. By then, it is already too late for the older messages you had on your device since they will be lost. Take a proactive approach, think ahead and backup your SMS text messages today.