All TalkersTech Sections

How To Convert Notepad To Excel 2016 With Columns

Last Updated : Mar 24, 2022

How To Convert Notepad To Excel 2016 With Columns

In this article we will show you how to convert notepad to excel 2016 with columns, Microsoft Excel and Notepad are two integral parts of Windows along with other applications. It has often been seen that one writes important information and points during a class in the notepad.

But it needs to be available or presented in a different format. So that leads to a whole new level of steps and knowledge.

In this article we will have a look at how to convert notepad to excel with columns. It decreases a lot of hard work and makes the process more technical and efficient.

Step By Step Guide On How To Convert Notepad To Excel 2016 With Columns :-

  1. Switch on your device.
  2. Open Microsoft Excel in it.
  3. If you don't have it installed, you will have to install it.
  4. Open the Microsoft store on your device.
  5. Search for Microsoft Excel in the search bar.
  6. Install the application on your device.
  7. Open the Excel application once it's installed.

    How To Convert Notepad To Excel 2016 With Columns

  8. Go to the top left corner of the excel sheet.
  9. Click on the file menu. It will show you a drop down menu with different options
  10. Click on open.

    How To Convert Notepad To Excel 2016 With Columns

  11. Go to the document library where you have saved the sample text file.
  12. Select the sample text file of the notepad document you have saved on your device.
  13. Click on open.
  14. It opens the import text wizard.
  15. Select the data type in the wizard.
  16. Click on Next.
  17. Select delimited if your notepad has data separated by column and rows.

    How To Convert Notepad To Excel 2016 With Columns

  18. Else select fixed width if your file has data separated in columns using spaces.
  19. Then click next.
  20. If you had selected delimited in the previous step then check the box with space written beside.
  21. If you have chosen a fixed width then choose tab.
  22. You will next be asked to select the column data format.
  23. Select the column data format.

    How To Convert Notepad To Excel 2016 With Columns

  24. Choose the option that best describes your notepad data.
  25. Click on finish.
  26. The save as the window opens up.
  27. Select excel workbook as the save as type.
  28. Type a name for your file.
  29. Click on save.

Conclusion :-

If you follow all the steps clearly then you will realize that it is a simple process although a little big.

When you follow the mentioned steps, you have a direct way of doing the same conversion process without wasting any time.

It maximizes your efficiency. To be honest in the fast-moving world, being inefficient is not a solution.

You need to use all the tricks present in the tech world to be technically efficient.

Thus, we guide you and provide you with shortcuts that make your work short and easy.

We have all the latest tech savvy tricks and shortcuts that you will need to make your device effective when you are doing work on it. I hope this article on how to convert notepad to excel 2016 with columns helps you.

LATEST ARTICLES