When a CSV file is attached or configured to load from a remote location like FTP(S), HTTP(S), SFTP, etc. you may experience that not all records were loaded from the CSV correctly. (Number of lines in CSV and number of records in Import Set Table do not match)
Release or Environment
All ServiceNow Platform releases.
These issues are commonly caused by the formatting of the source CSV file.
CSV files are plain text files, and store the data without any type formatting. Because there are many applications like Microsoft Excel, Libre Office Sheets, Apple Numbers that can handle these files, they appear like they are natural file formats of these applications, and they allow users to display the data in a tabular form.
Here is an example CSV file displayed in Microsoft Excel:
But this file is actually a text file and when opened with Notepad, TextEdit or a similar basic text editor, it will reveal the actual data:
As you can see, native applications hide many of the underlying data structure, and makes troubleshooting difficult.
Because there is no strict standard on generation of CSV data, certain formatting or lack of signs like comma (,), quotes ('), double quotes (") might cause issues while trying to import this data on other systems, including ServiceNow platform.
Please validate your source CSV file before importing into ServiceNow platform.
- Check your source data with a plain text editor against header columns count versus data columns count.
- If it's a large file or contains large number of columns, you can use one of many online validation websites. You can upload your file, and it will provide feedback on its formatting. One example is: