Download the articles to Excel

[ChunjiJ]

I have created several articles in a Knowledge Base. I want to download them to Excel, modify them locally, and then import them back into ServiceNow. However, I can't find any 'Export to Excel' button in the Article list. How can I download the articles to Excel? Thank you.

[Mark Manders]

Right click on the header and select export > excel. Just be aware that the article body is made of HTML. Depending on the number of articles and their length, it could be a huge file. Changing anything in the body should also be done carefully, because of the HTML tags you will export as well.

I would consider using the import functionality though. Because choosing the 'update' option would export it, including the sysIDs and makes it easy to import again. Otherwise you will need to create an import set and transform map as well.

[ChunjiJ]

Thank you. However, when I navigate to Knowledge > Articles > All, apply filters to select target articles, and right click on the header and select export > excel. , I can only download the metadata displayed in the list view – not the detailed content of the articles themselves.

[Mark Manders · Accepted solution]

That's correct, because the fields aren't on the list, so you don't get them. You first need to add all fields that you need to the list and then do an export. Or use the 'import' function I mentioned so you can choose 'all fields'.

[ChunjiJ]

Thanks a lot!😀