How to split html table into cells?

Question

HTML

Hello.
Sparsed products in Excel. One column of the table contains an html table.
It is necessary to divide this code into separate cells of the table. How can I do this in Excel or in simple Sublime using regex to get
Country (1 cell) - Germany (2 cell), etc.

<div class="tab-pane fade in active" id="tab-specification"><h3 class="text-center">Характеристики Erfurt Rauhfaser 40</h3><div class="table-responsive"><table class="table"><tbody><tr><th class="text-center" colspan="2"><strong>Основные</strong></th></tr></tbody><tbody><tr><td>Тип продукта</td><td>Обои под покраску</td></tr><tr><td>Страна</td><td>Германия</td></tr><tr><td>Коллекция</td><td>Rauhfaser</td></tr><tr><td>Длина х Ширина</td><td>33.5 х 0.53 м</td></tr><tr><td>Цвет</td><td>Белый под покраску</td></tr><tr><td>Площадь</td><td>17.75 м2</td></tr><tr><td>Рапорт</td><td>0 см</td></tr><tr><td>Основа</td><td>Бумага</td></tr><tr><td>Покрытие</td><td>нет</td></tr><tr><td>Состав</td><td>Целлюлоза, древесные волокна</td></tr><tr><td>Плотность</td><td>120</td></tr><tr><td>Структура</td><td>Маленькая</td></tr><tr><td>Кол. в упаковке</td><td>6 рулонов</td></tr><tr><td>Отгрузка</td><td>от 1 рулона</td></tr></tbody></table></div></div>

Maybe an option to convert so that each product feature is a separate column?

Answer 1

If you have similar markup in all lines, then this option, in
principle , should help you . With the help of this regular expression, we remove the "extra"
replace with "empty"
5. With this we are already forming new cells,
replace with
Save the file
Open in excel