# How to manually add users and email in console mode?

**URL:** <https://meta.discourse.org/t/how-to-manually-add-users-and-email-in-console-mode/26669>\
**Category:** Product Support\
**Created:** [23.Март.2015 14:16:43 UTC](https://meta.discourse.org/t/how-to-manually-add-users-and-email-in-console-mode/26669 "2015-03-23T14:16:43Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![tonycurzonprice](https://avatars.discourse-cdn.com/v4/letter/t/73ab20/32.png) [@tonycurzonprice](https://meta.discourse.org/u/tonycurzonprice)\
**Post date:** [27.Август.2015 21:12:52 UTC](https://meta.discourse.org/t/how-to-manually-add-users-and-email-in-console-mode/26669/8 "2015-08-27T21:12:52Z")

</div>

@Jared_Needell - I did a simple kludgey thing for multiple users:  
with a csv of all my users, I put them into a google sheet and created essentially this line for each entry with a string formula:

> =“u = User.create!(username: '”&B45&“', email: '”&A45&“', password: ‘xxx’, mailing\_list\_mode: ‘true’);u.approve(Discourse.system\_user, false) ; u.activate”

I then put the strings created into a file on the server (mail-import.rb), opened the console and typed:

> load ‘./mail-import.rb’

It worked a treat

---

_[View the full topic](https://meta.discourse.org/t/how-to-manually-add-users-and-email-in-console-mode/26669)._
