I want to make table from csv file

[kenken1]

I would like to create a table to use the service catalog

I have exported the table items to a spreadsheet, but the amount of items is so large that it is very difficult to register them using the GUI!

Is there an easy way to create tables by importing CSV or Excel files, etc.?

I have searched and found a description of ImportSet, but I understand that this does not create the table itself, but the records within the table.

[Michael Jones -]

There isn't a well established way to automatically create a custom table in ServiceNow based on an import from an external system. Each field on the table needs to be defined with certain parameters that would not be present in such a file. 

In theory you could create the base table with no fields and then generate an Import Template for the sys_dictionary table, fill in the template, and use the easy-import feature to populate the fields. 

In my experience however, for a "one off" requirement where you need to create a table, it is far better (and safer) to put in the time and manually create the table and fields, ensuring that you have the correct attributes for each one as you do so.

I've seen short-cuts such as this (like trying to use an import, or creating a script to automatically create a table) used in situations where someone required a large number of tables to be created and the results were less than stellar. You'd just as likely spend as much time fixing whatever your import created than you would just powering through the manual way to begin with. 

I hope this helps!

If this was helpful, or correct, please be kind and mark the answer appropriately.

Michael Jones - Proud member of the GlideFast Consulting Team!

[kenken1]

Thanks for sharing your case study in detail.
Since I am new to ServiceNow, it was very helpful for me to share your experience!