Luckily, Excel offers handy formulas that allow you to convert text into upper case, lower case, title case, and even sentence case with minimal effort.

To import data from a text file into Microsoft Excel, follow this step-by-step guide: First, create a blank spreadsheet in Microsoft Excel and ensure you have the .txt file on your PC.