Learn how to import or export data from a Text file to convert a Text (.txt or .csv) file into an Excel (.xlsx) spreadsheet easily using this procedure.

Microsoft Excel has an import wizard, but if you structure the text correctly, you can bypass the wizard altogether.

To convert data from Microsoft Money 95 for use in Excel, you must first export the data as a QIF file and then use a third-party utility to convert it to CSV format.

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.

Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to work in a dialog ...

Twitter used to provide CSV exports of your data, now it's all in machine-readable JSON. How can you use it in Excel?

Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work.