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

hagrin’s picture

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

jerett’s picture

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?

ghankstef’s picture

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

not sure if it does csv export but it might

hagrin’s picture

@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

luco’s picture

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.

_________________________

"There is no off position on the genius switch."
- David Letterman

wwwoliondorcom’s picture

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

wwwoliondorcom’s picture

any help ?

Thanks !

dawehner’s picture

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