The pasted text will retain the formatting from the website. To paste plain text instead, first paste it into Notepad or a similar text editor, then copy and paste it again into Excel.

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.

How to Copy Delimited Text to Excel. If you have data in delimited text files from other programs that you need to get into an Excel workbook, you can use the import wizard to import delimited ...