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.

To copy the sheets instead of moving them, select the Create a copy check box found in the Move or Copy dialog box. How to transfer or copy data from different workbooks? If you'd like to move or copy ...

To copy a sheet into a new workbook file, do the following: Select the sheet you want to copy (or move). Choose Move Or Copy Sheet from the Edit menu.