No matter which conversion is applied later first you will have to map the Excel cells to the Table fields.

Assuming that you have an Excel sheet which contains one column which contains the Test Steps in HTML table format. Here is the sample Excel file downloadable testCasesWithSteps.xls.

This screenshot shows the column which contains the HTML table we want to import into the "Test Steps" field. The "F" column contains the HTML table with the data:

The Table fields also appear on the mapping page of the import wizard. These appear on as separate fields like: "Test Steps.Action" and "Test Step.Critical" and "Test Step.Expected Result in the field list. By mapping them to a column you can load the column's data into the Table fields!

Because the cells in this "F" column contain all data for Test Steps we have to map all columns of Test Steps table to this single Excel column. This can be achieved by selecting multiple elements from the field list.

First set the Multiple field mappings checkbox to enable multiple choice options in mapping.

Once multi-choice is enabled select the required table columns for field mapping. Here is how this looks like in our example: