Try downloading a template, then inserting the data into that template (and ensure that any/all mandatory fields are compliant).
I personally always use .CSV for imports as I have had mixed results with .xlsx files, but that is just my preference and not a requirement
Share the full error trace, otherwise it would be difficult for anyone to help as to what the error is
Traceback (most recent call last):
File “apps/frappe/frappe/core/doctype/data_import/importer.py”, line 148, in import_data
doc = self.process_doc(doc)
File “apps/frappe/frappe/core/doctype/data_import/importer.py”, line 242, in process_doc
return self.insert_record(doc)
File “apps/frappe/frappe/core/doctype/data_import/importer.py”, line 261, in insert_record
new_doc.insert()
File “apps/frappe/frappe/model/document.py”, line 259, in insert
self.run_before_save_methods()
File “apps/frappe/frappe/model/document.py”, line 1040, in run_before_save_methods
self.run_method(“validate”)
File “apps/frappe/frappe/model/document.py”, line 909, in run_method
out = Document.hook(fn)(self, *args, **kwargs)
File “apps/frappe/frappe/model/document.py”, line 1259, in composer
return composed(self, method, *args, **kwargs)
File “apps/frappe/frappe/model/document.py”, line 1241, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File “apps/frappe/frappe/model/document.py”, line 906, in fn
return method_object(*args, **kwargs)
File “apps/education/education/education/doctype/student/student.py”, line 21, in validate
self.validate_user()
File “apps/education/education/education/doctype/student/student.py”, line 66, in validate_user
student_user.add_roles(“Student”)
File “apps/frappe/frappe/core/doctype/user/user.py”, line 489, in add_roles
self.save()
File “apps/frappe/frappe/model/document.py”, line 305, in save
return self._save(*args, **kwargs)
File “apps/frappe/frappe/model/document.py”, line 327, in _save
return self.insert()
File “apps/frappe/frappe/model/document.py”, line 254, in insert
self.set_new_name(set_name=set_name, set_child_names=set_child_names)
File “apps/frappe/frappe/model/document.py”, line 450, in set_new_name
set_new_name(self)
File “apps/frappe/frappe/model/naming.py”, line 163, in set_new_name
doc.run_method(“autoname”)
File “apps/frappe/frappe/model/document.py”, line 909, in run_method
out = Document.hook(fn)(self, *args, **kwargs)
File “apps/frappe/frappe/model/document.py”, line 1259, in composer
return composed(self, method, *args, **kwargs)
File “apps/frappe/frappe/model/document.py”, line 1241, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File “apps/frappe/frappe/model/document.py”, line 906, in fn
return method_object(*args, **kwargs)
File “apps/frappe/frappe/core/doctype/user/user.py”, line 48, in autoname
self.email = self.email.strip().lower()
AttributeError: ‘NoneType’ object has no attribute ‘strip’