In Excel, select the data (as I’ve done here ( (A)) that you want to put into the HTML table, choose Copy from the Edit menu (or press command-C), and switch to BBEdit 6.0.