Bulk Import of Knowledge Articles

[Community Alums]

I would like to bulk import knowledge articles using Excel.
I want the body of the article to reflect the formatting, so I have included the body text with HTML code in the Excel file, but when I import this file, the body of the article is blank.
Which record in which table is converting the HTML code in the Excel file for ServiceNow?
I am wondering because when I import a Word file that has already been formatted, it imports with the formatting intact. (I would also like to know which records are converting the HTML code in the Word file for ServiceNow.)
If OOTB does not have the ability to convert HTML code in Excel for ServiceNow, I would like to know how to implement that.

[Satishkumar B · Accepted solution]

Hi @Community Alums 
check the below link and the attachment:
https://www.servicenow.com/community/knowledge-managers/bulk-import-knowledge-articles-publish-and-translate/ta-p/2306061

https://www.servicenow.com/community/knowledge-management-articles/options-for-importing-external-articles-into-servicenow/ta-p/2673388

……………………………………………………………………………………………………

HAPPY LEARNING

Please Mark it helpful 👍and Accept Solution✔️!! If this helps you!!

[Community Alums · Accepted solution]

Thank you for your reply.
In the second article you gave, Easy Import states “Capture all HTML text under the column Text.” but in fact not all of the HTML is captured. If you look at the Knowledge article after import, only some HTML code is captured and missing in the text. The source code shows that the full text described in the Excel file is not imported.
Do you have a solution for this event?

[Community Alums · Accepted solution]

When we contacted NowSupport about this event, we were told that non-English templates are limited in what they can import and cannot import the full amount of text. Contact NowSuppot for more information.

[Satishkumar B · Accepted solution]

Hi @Community Alums 
check the below link and the attachment:
https://www.servicenow.com/community/knowledge-managers/bulk-import-knowledge-articles-publish-and-translate/ta-p/2306061

https://www.servicenow.com/community/knowledge-management-articles/options-for-importing-external-articles-into-servicenow/ta-p/2673388

……………………………………………………………………………………………………

HAPPY LEARNING

Please Mark it helpful 👍and Accept Solution✔️!! If this helps you!!

[Community Alums · Accepted solution]

Thank you for your reply.
In the second article you gave, Easy Import states “Capture all HTML text under the column Text.” but in fact not all of the HTML is captured. If you look at the Knowledge article after import, only some HTML code is captured and missing in the text. The source code shows that the full text described in the Excel file is not imported.
Do you have a solution for this event?

[Community Alums · Accepted solution]

When we contacted NowSupport about this event, we were told that non-English templates are limited in what they can import and cannot import the full amount of text. Contact NowSuppot for more information.

[Satishkumar B · Accepted solution]

@Community Alums  That was really a helpful response from you