Tools in Excel 2016
Often you need to import data to the Excel spreadsheet from a text file. Microsoft Excel offers a Text Import Wizard to import data from different text file formats:
When you import data from a text file to the Excel spreadsheet, Microsoft Excel launches a Text Import Wizard to help you to import data correctly. Here you can import all or some data from text files of different formats:
How to preview an Excel table from an XLSX file that is unopenable, immediately after receiving it from one of your colleagues, or downloading it from the Internet? Before trying to open attached XLSX files or following links, try to make sure that it is not a virus.