How to mass update data?

Hello,
I have tried to mass update user names (from "<first name> <last name>" to "<last name> <first name>"). I have prepared the xlsx file with ids and the new field names. I don't get any error at import, but the field are not changed. Is it related to the old version I am using? (v. 9.0.6).

Any solution? Thanks in advance,

use sql and update "resource" table column "name"

create script with set of update statements and execute:
UPDATE 'dbname'.`resource`
SET
`name` = "<last name> <first name>"
WHERE `name` = "<first name> <last name>" ;
---

Thanks. However, I need this kind of solution from the application. Is it possible?

Frankly, I've never tried

This is what I did. I have three columns: id, user name, real name, which is the element I want to change. The result column says that there is nothing to change, for each line. The result is the same, wheter in xlsx or csv format.
I did not see any information in the log file.
I've tried without the id column, and the error message is that the user name is mandatory. With the id but without the user name, I have the same behavior as with the user name.