Add Import Set Excel Template to add bulk import to the table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-10-2025 12:25 AM
I have a catalog already present, but now I want to add a excel Template of a table which I have build to import bulk data through excel file, how can i add a template to the catalog through which the user downloads the excel file and add the information and add to the catalog and then it automatically import the information to that table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-10-2025 12:52 AM
there are 2 things to it
1) add file to catalog form
2) use my blog to load the data via transform map
Data load and transform via Catalog Item
Approach for 1st point
you can use Rich Text variable and add button/link to it
1) File added to catalog item
2) Create Rich Text label variable and add source code below
HTML Source Code
<style>
a:link, a:visited {
background-color: #f44336;
color: white;
padding: 14px 25px;
text-align: center;
text-decoration: none;
display: inline-block;
}
a:hover, a:active {
background-color: red;
}
</style>
<p>Please download the file here: <a title="Link" href="/sys_attachment.do?sys_id=29c39e75073f64102011ff208c1ed04f" target="_blank" rel="noopener noreferrer nofollow">Link</a></p>
Output:
Native
Portal
I believe I have answered your question with all the details and you can take it further from here
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader