How to Convert Excel to Text & Set Column Width. Each Microsoft Excel worksheet is broken up into cells. Each cell is part of a column.

If the DAT file you're trying to open is text, you can convert the file into text in the Microsoft Excel program by first saving it as a CSV file.

Why is my number stored as text in Excel? Excel doesn’t convert numbers written in text into digits if you import data from another source because of the default setting.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.