I thought by creating an HTML table format will paste to each cell but instead, it only pastes to one cell. for example

let copyTable = e => {
   e.clipboardData.setData('text/html', '<tr><td>Seperate</td><td>each</td><td>word</td></tr >')
   e.preventDefault()
}

Output

When I use the <br> instead I was able to have each word go to a separate cell

let copyTable = e => {
    e.clipboardData.setData('text/html', 'Seperate<br>each<br>word')
    e.preventDefault()
}

Output

The only issue I am having now is how to paste data where it goes from A to C and so on instead of going from 1 to 3. I know I could paste special on google sheets and click transposed but I would like to eventually paste tables that can range from A1 to H10.