I have an excel file with more than 1000 items. Few columns contains text with html tags.
So I wanted to ask, what would be the different approaches that can be used so that when we are importing this excel data to SharePoint list, it should not include those html tags in the text.
Also the challenge is that the data in multiline rich text colunm should appear as it is provided in the excel file.
Like if one line of text is bold and next line is italic, then when we import it to list then it should add in similar way that means one line bold and then italic to rich text column.