To remove table formatting in Excel, you can convert the table back to a range. Here's how you can do it:

1. Click anywhere inside the table that you want to remove formatting from.

2. Go to the "Table Design" tab in the Excel ribbon. This tab appears when you're inside a table.

3. In the "Table Styles" group, click on the "Convert to Range" option. Excel will prompt you with a confirmation message.

4. Click "Yes" to confirm that you want to convert the table to a normal range.

5. The table formatting will be removed, and the data will still be intact in the worksheet.

By converting the table to a range, you'll essentially be removing the table formatting while keeping the data as is.