How to Copy From the Internet and Paste Into Excel. Microsoft Excel accepts data input from your keyboard, through file import and by pasting the contents of your computer clipboard into a worksheet.

First, you can manually copy and paste all the texts from the txt file into the spreadsheet. Second, you can use Microsoft Excel’s built-in option to make it easier.

Open Excel and click the File tab. Open the file in which you want to assign a cut/copy/paste macro or command button. Click the Developer tab, then click the "Insert" icon.