Community & Support

Export Users Database for Excel

Is there currently a module setup where you can export the user list into a format that will work with Excel? I am have been search and can't seem to find what I need. Is it possible this function is included and I just didn't find it?

Thank you in advance for your help on this.

PS: If you list a module, could you explain the process on exporting with the module if it is complicated? Thanks!

Comments

If you have access to

If you have access to phpmyadmin on your webhost, you can simply choose the "Export" option and select the user tables you need and export to the desired file type.

_______________________________________________________________________________
http://www.hagrin.com - Just my little slice of the Interweb

_______________________________________________________________________________
http://www.hagrin.com - Just my little slice of the Interweb

True. It is just the person

True. It is just the person this is for is not savvy enough to do that. Maybe I can have a simple code done up where you can login and perform the dump etc. None-the-less - is there not a mod out there?

Have a look at the Database Administration module

http://drupal.org/handbook/modules/dba
http://drupal.org/project/dba

not sure if it does csv export but it might

@ghankstef - Wow, didn't

@ghankstef -

Wow, didn't know about this module - this is perfect for my clients that don't know how mySQL that well.

_______________________________________________________________________________
http://www.hagrin.com - Just my little slice of the Interweb

_______________________________________________________________________________
http://www.hagrin.com - Just my little slice of the Interweb

"there's a module for that!"

actually, there's two - one for each task.

exporting:
http://drupal.org/project/profile_csv

impoting:
http://drupal.org/project/user_import

haven't tested them thoroughly yet, though.

_________________________

signature under construction.

how to import a user list from Drupal 5 website to a Drupal 6 website

Hello,

Do you know how to import a user list from Drupal 5 website to a Drupal 6 website ?

Thanks

any help ?

any help ?

Thanks !

You could alternative use

You could alternative use http://drupal.org/project/feeds