Although ServiceNow has the capability of importing data in the CSV format using a custom delimiter, very few people know about it or understand how to get this to work. There is actually a great little wiki documentation segment on this, but you kind of have to know what you’re looking for in order to find it.

I’ve created a simple little YouTube video that demonstrates how you set up ServiceNow so that you can import a non-comma based CSV file.

This video demonstrates the creation of a CSV file that uses a semi-colon as the actual CSV delimiter. In the video we create a data source and set it up to consume that file. We then personalize the form layout for the data source record and at the CSV delimiter field that we can leverage to specify our special delimiter.