I have to import to SharePoint lists data from a LotusNotes base. So, I exported the information in Excel, and there, matching the column names, I could import some simple data in lists.

However, in one list I have some RichText to import (text bold, italic, red, some pictures).

In what format should I store the RichText (in Excel?) in order to import it in SharePoint?

In what format the RichText is stored in SharePoint?

1 Answer 1


You can create a "multiple lines of text" column in SharePoint with the "Use enhanced rich text" option enabled in the column settings. This will allow you to import the rich text in to SharePoint. More information on column types can be found here:

List and library column types and options

Edit: Rich text refers to HTML.

  • I know how to create the column. In that column I need to import from excel. The question is what format should have the data in that Excel column. Should it be XML, HTML, RTF, DOC?
    – serge
    Commented Aug 23, 2022 at 12:11
  • 1
    Rich text, refers to rich HTML. So it would be HTML. Commented Aug 23, 2022 at 12:12
  • HTML... what about the pictures?
    – serge
    Commented Aug 23, 2022 at 12:13
  • Images are only referred to in HTML e.g. img src attributes etc. If you have rich HTML, then it should work the same as it does now. Commented Aug 23, 2022 at 12:14
  • OK, could you add these details in the answer (for future reference). I will try to export current data to HTML to be able to import in SharePoint via Excel. Thanks for the suggestion! :)
    – serge
    Commented Aug 23, 2022 at 12:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.