Importing users from Wordpress/CSV

[Ojay]

Hi all,

I'm new to Supabase but am a big fan of what I've seen so far. I'm looking to get a little bit of guidance on the best approach to get a few thousand users (exported from Wordpress as a csv) into our auth.users table.

I found this very handy comment (thanks @raimille1) which looks perfect, though running this in our SQL editor with a few thousand entries isn't ideal.

Looking through the docs I saw the bulk data loading option, which looks great, but for some reason looks far too straightforward? I've no idea why, its obviously fine for regular data but am wondering whether it's the correct approach with users?

All users are email/password as oppose to social providers.

Any pointers would be most welcome. Thank you!

Mark