Could you show me an example of a row you are importing?
Thanks for the reply, here is the screenshot of what i am importing
https://gasophe.com/wp-content/uploads/2023/03/screenshot.jpg
Thanks
Read the documentation please. This CSV is completely bad formed.
In Documentation tab you have the instructions:
Columns position(Documents should look like the one presented into screenshot. Remember you should fill the first two columns with the next values)
Username: you can leave it empty and the username will be generated randomly
Email: required, although you can use this addon to allow users to be imported without an associated email address.
Respect to the spreadsheet, the best spreadsheet to manage CSV of anything is LibreOffice or OpenOffic calc, this is free software like WordPress.