# Exporting mysql data to excel?

**URL:** <https://www.ruby-forum.com/t/exporting-mysql-data-to-excel/157480>\
**Category:** Rails\
**Created:** [January 12, 2009, 6:35am UTC](https://www.ruby-forum.com/t/exporting-mysql-data-to-excel/157480 "2009-01-12T06:35:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![martin\_mercy2001](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/d2c977/32.png) [@martin\_mercy2001](https://www.ruby-forum.com/u/martin_mercy2001)\
**Post date:** [January 12, 2009, 6:35am UTC](https://www.ruby-forum.com/t/exporting-mysql-data-to-excel/157480/1 "2009-01-12T06:35:41Z")

</div>

Dear all,

Could anyone please suggest about how to export mysql data’s to excel.  
Is there any plugins or gem to do so?

Thanks in advance

regards,  
Jose Martin

---

<div class="post-metadata">

**Author:** ![martin\_mercy2001](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/d2c977/32.png) [@martin\_mercy2001](https://www.ruby-forum.com/u/martin_mercy2001)\
**Post date:** [January 12, 2009, 2:43pm UTC](https://www.ruby-forum.com/t/exporting-mysql-data-to-excel/157480/2 "2009-01-12T14:43:08Z")

</div>

dare ruby wrote:

> Dear all,
> 
> Could anyone please suggest about how to export mysql data’s to excel.  
> Is there any plugins or gem to do so?  
> By far the simplest solution is to output to Comma Separated Value (CSV)  
> files. Excel can open them as a spreadsheet. Ruby has a CSV class in  
> it’s standard library for reading and writing CSV format.

---

<div class="post-metadata">

**Author:** ![martin\_mercy2001](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/d2c977/32.png) [@martin\_mercy2001](https://www.ruby-forum.com/u/martin_mercy2001)\
**Post date:** [January 12, 2009, 6:17pm UTC](https://www.ruby-forum.com/t/exporting-mysql-data-to-excel/157480/3 "2009-01-12T18:17:36Z")

</div>

try the spreadsheets gem. it allows you to open up a spreadsheet and  
insert  
records into it.

On Mon, Jan 12, 2009 at 5:43 AM, Robert W. \<