Common assets CSV import errors and how to fix them

When importing assets in bulk, it’s important to format the CSV correctly. Here are common mistakes and how to resolve them.

Error type	Cause	Solution
Date format mismatch	Date fields don’t match the format selected during upload	Use a consistent format (e.g., dd-mm-yyyy) and match it during import
Missing mandatory fields	Title, category, or code left blank	Ensure all required columns are filled
Invalid employee names	Employee name in file doesn’t match system records	Use the exact spelling as in the employee master
Wrong category name	Category doesn't exist or is misspelled	Use leaf-level category names exactly as listed in the system
File not in CSV format	Uploaded file is Excel, not CSV	Save the file as .csv before uploading
Extra commas or special characters	Causes column mismatch	Clean data to avoid extra commas or characters like &, %, etc.

Pro tips

• Always download and use the sample CSV provided.
• Open and save your file using tools like Google Sheets or Excel with CSV format selected.