To paste plain text instead, first paste it into Notepad or a similar text editor, then copy and paste it again into Excel. How To Automate a Table in ... located in the Data tab's Data Tools ...

Below is the sample data we will be using, if you’d like to copy and ... on the Table tab. And that’s it. It took all of 20 seconds to create and format a table in Excel.