So, open the Excel file, highlight the relevant data, right-click, and select Copy. Click Ctrl+N to open a new blank workbook, and choose Paste Special to remove the formatting.