Data Import from Excel sheet to table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-09-2016 06:07 AM
I am facing error while importing data from excel sheet to table? 1. I created the table with 2 columns first is refernce field to another table and second is string field. 2. I am having one excel sheet with two columns containg data. then I WANT TO import the data from excel sheet to table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-09-2016 06:15 AM
Hi Chander,
You can try to do this with Easy Import or if you have more complex data (requiring specific field mapping and data transformation), use import sets.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2022 12:19 PM
Is it possible to import xls file with multiple sheets to different table at once shot or I need to load every time selecting different sheet number?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-09-2016 06:22 AM
Hi Chander,
The error may be caused by the format of the sheet. What do i mean by format is ... ServiceNow don't support .xlsx format. Excel sheet should be in .xls format. You can easily change that using save as option available in Microsoft Excel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-09-2016 06:25 AM
