#362 Exporting CSV and Excel

Jul 02, 2012 | 6 minutes | Views

As you will see it is easy to add a CSV export option to Rails. Here I also show how to export for Excel in a variety of formats.

Click to Play Video ▶

Download:
source codeProject Files in Zip (56.3 KB)
mp4Full Size H.264 Video (21 MB)
m4vSmaller H.264 Video (8.94 MB)
webmFull Size VP8 Video (9.65 MB)
ogvFull Size Theora Video (22.1 MB)

Yannick Schutz about 5 years ago

Thanks a lot!
For a pro episode about XLS you can maybe try https://github.com/randym/axlsx
Really useful for advanced excel usage.

Ernest Shulikovski about 5 years ago

Randy Morgan about 5 years ago

acts_as_xlsx is also a very quick way to get up and running with rails.

grab me on #axlsx if you have any questions.

Yannick Schutz about 5 years ago

Thanks Randy! You really helped us with that gem:)

Randy Morgan about 5 years ago

Thanks Yannick. It has been a true community effort. Huge respect to the people out there who forked and added the feature they needed. I'd love to see a Pro cast showing chart generation, multiple sheets, styled and localized headers and all that jazz. For now, here is a blog post showing how easy it is.

http://axlsx.blogspot.jp/2011/12/using-actsasxlsx-to-generate-excel-data.html

Andy L about 5 years ago

+1 for axlsx cast

vineelsonnathi about 5 years ago

Can we have subsheets under worksheet in axlsx? Let me know.

Ochko about 5 years ago

+1 axlsx cast. It saved my time

Javi about 5 years ago

This is great! Does anyone know about similar gems for Open Document?

Randy Morgan about 5 years ago

This is the only one I know about - not quite as smooth of an API but if you are dealing with a fixed template it is great.
https://www.ruby-toolbox.com/projects/odf-report

Frank W about 5 years ago

+1, we use axlsx for reporting and found it very helpful. Also Randy has been very responsive in case of questions!

Geoffroy Montel about 5 years ago

Thanks guys for AXLSX ! It perfectly suits my needs !

Mohammed Al-sheikh almost 4 years ago

+1 for axlsx

Enrique García Cota about 5 years ago

I needed a simple, straightforward way of exporting AR collections to excel, and I ended up doing the to_xls gem.

Zach about 5 years ago

This is the to_xls gem that I'm using. It's perfect for spitting out simple arrays with limited formatting but unable to tackle anything more involved.

https://github.com/splendeo/to_xls

An example of my use:

http://stackoverflow.com/questions/11112581/calling-an-activerecord-association-method-from-an-array-in-rails-3-2

Ernest Shulikovski about 5 years ago

Mr. Bates, thank you!
I thought that I need some heavy gem to be able to generate medium complex XLS files. I am so glad you showed me wrong, I am up and running without any additional dependency. Btw. you could post a link to that XML reference you mentioned in Show Notes:
http://msdn.microsoft.com/en-us/library/aa140066%28v=office.10%29

kobaltz about 5 years ago

The only issue that I saw with the CSV export was that it would return all data from that table. I put it on a user list and has to make a index.csv.erb file that would post just the required data.

Not a big deal since I was able to put in whatever information I wanted.

          ruby
        
First Name,Last Name,Email Address,Status,Company,Last Login,Last IP

<% @users.each do |user| %>

<%= user.first_name %>,<%= user.last_name %>,<%= user.email %>,<%= "Active" if user.user_status %><%= "Inactive" if not user.user_status %>,<%= user.company.company_name %>,<%= time_ago_in_words(user.updated_at.localtime) %>,<%= user.ipaddress %>

<% end %>

Mohammad El-Abid about 5 years ago

          
        
def self.generate_csv(fields, records, options = {})
  CSV.generate(options) do |csv|
    csv << fields.collect(&:humanize)
    records.each do |record|
      csv << record.attributes.values_at(*fields)
    end
  end
end

generate_csv([:id, :username], members, options[:csv])

Nathan D Acuff about 5 years ago

While it is primarily a tool for making PDFs, you can also use DocRaptor to generate XLS, if what you need is more involved. Being able to select pdf instead of xls without too much additional effort is a nice bonus, and it is also available as a heroku addon. Yes, there is a small document fee after the first five, so clearly not suitable for everything.

Tom Zmyslo about 5 years ago

Another useful idea for a "Pro" episode on this topic would be generating the document while using pagination for just a page of data, or after filtering results and exporting a document with just those results.

Awesome episode as always though, thanks!

a3gis about 5 years ago

Well that's maybe a bit short for a "Pro", you just need a few lines to do that ;)

sdstoic almost 5 years ago

I would like to export the filtered results, as well. What are those few lines I'd need? Appreciate the help...

Paz Aricha about 5 years ago

How about an episode on Importing csv/xls files to your app?

murdoch about 5 years ago

Ryan about 5 years ago

Peter Meszaros about 5 years ago

Synthmax about 5 years ago

Yes ++
I need it all the time when a customer has a huge amount of legacy date in XLS format they want to move online

Muhammad Fauzi about 5 years ago

i need it..

Misha Tatinets about 5 years ago

I need it too

Alex Watt about 5 years ago

Percy Keeley about 5 years ago

I use the Roo gem to import data in .xls files.

See http://roo.rubyforge.org/ -and- https://github.com/hmcgowan/roo

Anthony Barone about 5 years ago

+1 Please do this Ryan... I'm a pro customer too : ).

Bob Walsh about 5 years ago

in an index view that already does sorting and filtering, stuck on one point: creating a link_to that passes those parameters back to index.

so from http://0.0.0.0:3000/users/198/contacts?letter=C

this link_to
<%= link_to "Excel", user_contacts_path(format: 'xls') %>

passes
{"action"=>"index", "controller"=>"contacts", "user_id"=>"198"}

How do I preserve my variable number of parameters?

Erick Alvarez about 5 years ago

You can use
<%= link_to "Excel", user_contacts_path(params.merge(format: 'xls')) %>

and this will maintain the current parameters you have plus the ones you add or edit inside merge.

memoht almost 5 years ago

A bit belated, but I just implemented this feature into a new app I am working on and was looking for how to download only records in the current view or in a query. +1 for your tip above. Thank you. It works! It works!

James Jelinek over 3 years ago

I was banging my head on how to preserve my search criteria into the CSV/XLS export. This worked great! Thanks for saving me the headache. I owe you Starbucks.

Juergen Helmers about 5 years ago

<%= link_to "Excel", user_contacts_path(format: 'xls'), :letter => 'c' %>

should do it...

Ray Rogers about 5 years ago

Importing CSV files would be a great pro epsidoe also.

Anthony Barone about 5 years ago

ewige about 5 years ago

Juergen Helmers about 5 years ago

I am using will_paginate in a search page. After restricting the number of records according to the search form fields I am calling paginate on them.

When I export to CSV I only export the current number of records on the page as defined in :per_page. How do I trick my controller to export all records when export to CSV?

Erick Alvarez about 5 years ago

apply the pagination until the format.html inside respond_to
format.html { over here }

this way format.csv is not affected by paging

Dana over 4 years ago

Erick, is there any way you could provide an example of your suggestion? I'm also using pagination and would like the exported files to contain only the search results. (Not just the first 25 results as defined in my controller.)

Rob Jones about 5 years ago

Keep in mind that Excel XML output is not readable by Apple Numbers.

Numbers will display the raw XML. It will take the older 'native' Excel format.

Come on, Apple, I want to like the program but the last update was 2009...

Randy Morgan about 5 years ago

While there are some things like graphs that do not interop very well, I have never experienced Numbers opening up an xlsx file as raw XML. Interested to hear what version of Numbers you are working with. I Currently using 1.2 (436) for confirming https://github.com/randym/axlsx interoperability with LibraOffice and Numbers

Rob Jones about 5 years ago

Numbers '09 version 2.1 (436) ... should be the latest (did you transpose 1 and 2?)

Randy Morgan about 5 years ago

yes, you are quite right. the version numbers where transposed. sorry about that That version supports a considerable amount of the ECMA-376 specification - also known as office open xml. what did you use to generate your data that opened raw xml? I think you'll find axlsx to actually work. we've been sucessful in interop with Numbers and LibreOffice and expect to release google docs operability this week.

Oliver Prater about 5 years ago

We had the same error described above in a legacy App, but the cause was that the XML is sent with an extension of XLS not XLSX.

Changing the extension to .XLSX solved it for us.

Rob Jones about 5 years ago

In general I find using a csv view template to be more useful that a to_csv method in a model.

The problem with the view template is that the file will be downloaded with the last component of the URL as the name.

For example from a Show action with a URL like /posts/2.csv you'll get a file called 2.csv, which is not very friendly

Clinton Nixon has a nice solution in this stackoverflow post

http://stackoverflow.com/questions/94502/in-rails-how-to-return-records-as-a-csv-file

He creates a render_csv method in the application controller that adds headers to the response that use either the user supplied filename or defaults to the action name

For example, this produces a file called 'myfile.csv'

          ruby
        
   respond_to do |format|
      format.html
      format.csv {
        render_csv('myfile')
      }
  end 

Ryan Johnson about 5 years ago

Excel XML is known as SpreadsheetML

FAIR WARNING:

SpreadsheetML file sizes will be about 3-4 times larger than native XLS files. Not really a problem for small files, but with large data sets this could eat up your system resources to generate the file.
SpreadsheetML will only be readable by Microsoft Office. Other mainstream office suites will open it as an XML document.

The CSV approach fits my needs 9 times out of 10. However if you require a native Excel format, please use a gem and avoid using the SpreadsheetML method.

Zach about 5 years ago

Excel will also always throw a "unreadable content" error when opening a SpreadsheetML file. It's just a crappy user experience all the way around; do not want.

ano1chan about 5 years ago

+1
A painful memory while you are exporting 50K above of row in SpreadsheetML
And this occupy one of the worker while in production.
Even you finish export with SpreadsheetML, your customer may can't open it because it is too big and eat up the memory in excel.
I end up writing a rake task and put that in background with spreadsheet gem.
Smaller output and better user experience.
May be I am doing it wrong but that's my experience.

paritycube over 3 years ago

Hi ano1chan

I am having the same Issue now , i am exporting excel files with large records , consuming my all memory, can you help ?

Kevin Chambers about 5 years ago

I haven't used it, but this looks like a viable option for more complex needs where you really want to use a template approach:
https://github.com/dasil003/csv_builder

Johnny Shields over 4 years ago

I followed this RailsCast tutorial, then later discovered csv_builder. Like you said, the template/view approach is much better! I think this RailsCast should be revised to use csv_builder rather than putting CSV view logic in the Controller as it recommends!

Note new repo URL: https://github.com/gtd/csv_builder

devwout about 5 years ago

It is possible to get around the encoding issues for csv-formatted excel files: use UTF-16 little endian encoding (with a byte order mark).

          ruby
        
BOM = "\377\376"
BOM + Iconv.conv('utf-16le', 'utf8', data)

Deb about 4 years ago

Where did you put that code?

Greg V about 5 years ago

XML spreadsheets MUST have the .xlsx extension

digitig almost 3 years ago

Maybe that's changed. In Office 2013 I can open the XML file (with a warning) if it has a .xml extension, but Excel rejects it completely if I rename it to .xlsx.

Akshay Rawat about 5 years ago

Remember to set the Content-Disposition header for such downloads.

Cirdes about 5 years ago

Using send_data method I can pass filename like that
format.csv { send_data @attendees.to_csv, {filename: filename}}
How can I change the default filename for xls without using send_date?

format.xls # { send_data @products.to_csv(col_sep: "\t") }

Thomas Maximini about 5 years ago

want to know that as well... did you find a solution?

oxleyj about 5 years ago

I'd like to know this as well.

Esteban Arango Medina almost 5 years ago

Put it before your render ;)

          ruby
        
headers["Content-Disposition"] = "attachment; filename=\"#{filename}\"" 

Lucas Repolês over 4 years ago

Thank you very much Esteban. It was just what I was looking for.

Joshua Pinter over 2 years ago

Genius, thank you very much.

Alex Blakemore about 5 years ago

Can anyone explain why the class method Products::to_csv is successfully getting called from the controller code below?

@products = Product.order(:name)
send_data @products.to_csv

@products is not the Products class object, but the method gets called. Then inside to_csv, it calls the all method. Does that repeat the query? or does it somehow apply all to the array @products?

To make it even more confusing, if I repeat this setup with an arbitrary method name instead of to_csv inside the rails console, I get NoMethodError. What's going on?

Alexei Danchenkov about 5 years ago

That is because @products.class is Array, which responds_to? :to_csv. I guess you should call to_csv or whatever method name you have as class method: send_data Products.order(:name).to_csv

Andy Weber almost 5 years ago

For me Products::to_csv did not successfully get called. Instead, a comma separated list of objecs was rendered. e.g #<MyObject:0x007fb05ee9eb00>,#<MyObject:0x007fb05ee9e4e8> (which is the same output as when there is no def self.to_csv)

I was only able to use this design by changing
format.csv { send_data @products.to_csv }
to
format.csv { send_data Product.to_csv(@products) }

ruby-1.9.3-p125
Rails 3.2.8

Anthony DeFreitas almost 5 years ago

I had the same issue but your change gave me the error: can't convert Array into Hash

format.csv { send_data Product.to_csv } worked for me.

bstruck almost 5 years ago

Thank you, I had to do the same.

LucasCioffi over 4 years ago

I got the same "can't convert Array into Hash" error from

          products_controller.rb
        
format.csv { send_data Product.to_csv(@products) }

but it seems to work if you pass @products as a variable into the model by adding it in the parentheses and in the .each loop as I'm passing all_products in below.

          product.rb
        
def self.to_csv(all_products)
  CSV.generate do |csv|
    csv << column_names
    all_products.each do |product|
      csv << user.attributes.values_at(*column_names)
    end
  end
end

The advantage is that you can define @products in the controller in order to only get the products you want such as in this example:

          products_controller.rb
        
@products = Product.find_all_by_color("green")
respond_to do |format|
  format.csv { send_data User.to_csv(@products) }
end      

Tony over 4 years ago

Thank you, I had run into the same issue. This fixed it.

M Rossetti almost 4 years ago

thanks @lucascioffi

LucasCioffi over 3 years ago

Update: To make this work in XLS format, we need to pass in the tab character, so I modified my controller to look like this:

          ruby
        
@products = Product.find_all_by_color("green")
respond_to do |format|
  format.csv { send_data Product.to_csv({},@products) }
  format.xls { send_data Product.to_csv({col_sep: "\t"}, @products) }
end

And then this is how product.rb receives the call of .to_csv with the tab character and @products passed in as variables from the controller:

          
        
  def self.to_csv(options,products)
    CSV.generate(options) do |csv|
      csv << column_names
      products.each do |product|
        csv << product.attributes.values_at(*column_names)
      end
    end
  end

Dana over 4 years ago

I tried following this screencast and gave up because I was running into an issue identical to what Andy Weber found.

Am currently using the following code, which does work:

format.csv { render :text => Product.to_csv }

Mike O'Dell about 4 years ago

I ran into the exact same issue. Thanks for sharing, really helped me out.

sergeyki over 4 years ago

I think you define products as following:

@products = Product.all
@products.class #---> Array

but when you fetch data by calling order():

@products = Product.order(:name)
@products.class #---> ActiveRecord::Relation
in this case you do not have to call Product twice, like Product.to_csv.

Thomas Maximini about 5 years ago

Does anybody know how I can rename the .xls file when using

respond_to do |format|
format.html
format.xls
end

The file is always called as the controller actions...
thanks !

Paul Springett about 5 years ago

You might be interested in this gem I made called CSV shaper that allows you to create CSV output using a really nice Ruby DSL.

https://github.com/paulspringett/csv_shaper

minifigmaster125 about 5 years ago

I'm having a problem with the xls.erb file. HTML or XML, when I open it in excel, the file isn't being parsed. I just see all the code, line by line, the way it is in the erb file. However, any of the erb lines, like <% if ... %> statements are correctly interpreted.

I've done the mime type in the initializer as well.

Any help?

vineelsonnathi about 5 years ago

How to use subsheets in a worksheet. Any idea?

Thanks

Ace Suares about 5 years ago

Great!

Thomas Klemm almost 5 years ago

Knight's Spreadsheets (Ruby) section compiles a list of gems that can help with parsing and writing Spreadsheets and CSV. Knight.io is a gem wiki for developers, a current project of mine.

TEE JIA HEN over 4 years ago

not working after joins

viniciusgati over 4 years ago

is there a way to insert images on the "non dependency way" to export xls with html in the file?

my images dont work fine, i think i can't do this by this way.

cao7113 over 4 years ago

Wonderful cast! I used roo to import some legency-excel data. Exporting excel is useful in rails application.

Thanks a lot!

Patrick Espake over 4 years ago

Not working with Office in Windows and Google Docs.
Office in Windows and Google Docs don't show de spreadsheet (corrupted file) :(

Confiz over 4 years ago

Same for me. File is corrupted. "General input/output" error.
I am using liber-office on Debian Ubuntu 12.04. Dont know why its corrupted.

Morgan J Lopes over 4 years ago

I am not sure why this is happening but .xls is showing up in the browser window and not downloading.

Matt Slay over 4 years ago

Here's another nice gem that can handle exporting data to CSV, Excel, JSON, and HTML:

Dossier

https://github.com/adamhunter/dossier

Chip over 4 years ago

Is there a way to follow this same direction for a partial? My view starts with a form that passes params back to the same URI which formats a partial. I'm struggling to make this lesson translate to my scenario. Advice? Ideas?

Chip over 4 years ago

see this SO question for details on my problem: http://stackoverflow.com/questions/15121588/rails-3-export-csv-from-partial

Confiz over 4 years ago

File is corrupted. "General input/output" error.
I am using liber-office on Debian Ubuntu 12.04. Dont know why its corrupted.

umdstu over 4 years ago

For CSV files, I was able to set the send_data type param as "text/csv". For the XLS xlm schema approach, are you all getting the file downloaded to have the .xls extension? My filename is just the name of the view, without extension.

Thanks

Jun Lin over 4 years ago

JavaScript way, for table:

http://datatables.net/extras/tabletools/

Al over 4 years ago

Followed the cast and for some reason when it exports CSV file, i get all records in one row and each cell is #User:0x007fb87415c460 and etc...any idea what could be causing this?

Dana over 4 years ago

Might want to try something like this, Al. (Stolen from a post above.)

format.csv { render :text => Product.to_csv }

Sandeep Kumar over 4 years ago

Can anyone tell how to export 100,000 records of data to csv in seconds.

Thanks in advance.

Skully over 4 years ago

Anyone know how to solve encoding issues with xls files generated by the simple "html" definition of a table described in the cast?

I have problems on import in LibreOffice, MS Office with special characters and umlauts (§, ö etc.).

brunocalado about 4 years ago

Use
csv << product.attributes.values

instead of:
csv << product.attributes.values_at(*column_names)

Edwin about 4 years ago

Anyone know how I can do a spec test about a csv export? Thanks

jaywengrow about 4 years ago

Is anyone else getting the message (when opening up in Windows Excel): 'The file you are trying to open, .... , is in a different format than specified by the file extension. etc..' ? I don't get this when using Mac Excel (2011), but it seems to be an issue with Windows Excel (2010). Any workarounds?

David Acevedo almost 4 years ago

I'm having the same issue with Windows Excel (2007) the file opens correctly just throws that error every time.

matt-stringer about 4 years ago

I have a document that has spanish characters, accents and ñ. Is there way ensure that these are exported correctly? Or better put, how can I change the encoding to 'Latin-1'?

Piyush Gupta about 4 years ago

I am pasting my code here, it does the following
- downloads the file, not only make it in file system
- libre complaint, also windows, and browser

Even though I dont like to write and delete , but with spreadsheet seems like the only solution.

          ruby
        
puts "# write the file
    
book.write "Employee_History_#{ params[:id]}.xls"
    
# send the file
    
send_file "Employee_History_#{ params[:id]}.xls", :type => "application/vnd.ms-excel", :filename => "data.xls", :stream => false
    
# and then delete the file
    
File.delete("Employee_History_#{ params[:id]}.xls")"

Piyush Gupta about 4 years ago

I am pasting my code here, it does the following
- downloads the file, not only make it in file system
- libre complaint, also windows, and browser

Even though I dont like to write and delete , but with spreadsheet seems like the only solution.

          ruby
        
puts "# write the file
    
book.write "Employee_History_#{ params[:id]}.xls"
    
# send the file
    
send_file "Employee_History_#{ params[:id]}.xls", :type => "application/vnd.ms-excel", :filename => "data.xls", :stream => false
    
# and then delete the file
    
File.delete("Employee_History_#{ params[:id]}.xls")"

Greg Blass about 4 years ago

Has anyone figured out how to insert a new line in a cell using the Microsoft XML approach?

Greg Blass over 3 years ago

The answer is:

.join("").html_safe

christina2013 almost 4 years ago

Hi,
How can I format the index.xls.erb so that the xls which is exported has columns with different width and :word-wrap: normal ?
Thanks,
christina2013

Luis Bivar Ramos almost 4 years ago

Does anyone know how to add totals with this approach?

srinu4122 over 3 years ago

Hello,
I had an application with rails 4 & rubyzip gem installed.
I have 3 tables - students, exams & results.

I followed this video http://railscasts.com/episodes/362-exporting-csv-and-excel

I'm able to download individual table csv files but not all 3 at a single click.

And I want to download all these 3 table csv files as a zip file with rubyzip or something else.

Please help me. I searched every end of google but didn't find an accurate result.

newextasy over 3 years ago

Please, help srinu4122. I have same question)

mbratch about 3 years ago

I am running Excel 2007 and the XLS/XML format described in this Railscast doesn't work. I copied it over carefully. Excel 2007 just says that there's something wrong with the "Table" format but doesn't tell me what. It says to see a log file in a long path name it gives me for the details, but that path doesn't even exist (thanks Microsoft). Has anyone gotten an XLS format to work on Windows?

mbratch about 3 years ago

Oh nvm, operator error on my part. I actually does work, but does show a warning message up front.

Synthmax about 3 years ago

I'm having a problem with many browsers opening the file instead of downloading it.

The best solution so far has been to use send_data and set ' disposition: "attachment; filename=A_COOL_TITLE" instead

          ruby
        
respond_to do |format|
      format.html
      format.csv { 
        send_data(
          @products.to_csv, 
          disposition: "attachment; filename=A_COOL_TITLE",
          type: 'text/csv',
          stream: 'true', 
          buffer_size: '4096' 
        )

      }
end

I also found that turbo-link can cause issues so I added 'data-no-turbolink' => true to the download link

Ben Hughes about 3 years ago

This doesn't seem to work at all - file download or not. No matter what I do - even with the most basic example 100% identical to the shown source code - I get a "can’t be opened" error with Numbers (have not tried with windows). Just going to have to find a different solution entirely.

R|S|L over 2 years ago

For those who have need PDFtoXLS...

https://github.com/Ricardosluiz/Ruby_on_Rails-PDFtoXLS

wingleungchoi over 2 years ago

The XML Spreadsheet does not work. :(
My OS X 10.02 and Numbers version: 3.5
what i can see in Numbers are the following
<?xml version="1.0"?>

Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"

xmlns:o="urn:schemas-microsoft-com:office:office"

xmlns:x="urn:schemas-microsoft-com:office:excel"

xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"

xmlns:html="">http://www.w3.org/TR/REC-html40">

Worksheet ss:Name="Sheet1">

Table>

Row>

ID

Name

Release Date

Price

/Row>
........

Sithara about 2 years ago

What if we have something like

          
        
class CouponController < ApplicationController
  def index
    @coupons = Coupon.all.page(params[:page])
    @coupons = @coupons.for_amount(params[:amount]) if params[:amount].present?
    @coupons = PaginatingDecorator.new(@coupons)

    respond_with(@coupons) do |format|
      format.html
      format.csv { render :text => coupons_csv }
    end
  end

 private

  def coupons_csv
    column_names = %w(code name id amount expiration_date)
    CSV.generate do |csv|
      csv << column_names
      @coupons.each do |coupon|
        csv << column_names.map{ |attr| coupon.public_send(attr) }
      end
    end
  end

Here in coupons_csv I'll not receive the entire coupon list - I'll receive only the paginated set.So what would be the best way to get ALL filtered coupons into the csv and get per-page#paginated coupons in the index page?

barshn almost 2 years ago

Thanks you so much,saved a lot of time for a feature I had to add.
Wondering if there is a way for generating the same .csv file so it would be saved in the rails public direcoty instead.
I have a script I wrote for that csv file
help will be much appriciated,thanks

Steven almost 2 years ago

This gem may be helpful, pretty useful julia_builder

Igor Kasyanchuk almost 2 years ago

You can use this gem too

if you simply need to export data as admin to excel you can use this gem https://github.com/igorkasyanchuk/rails_db to excel or csv

bparanj over 1 year ago

This episode has been updated to Rails 5 as a blog post Exporting Records in CSV and Excel Formats in Rails 5

dericky about 1 year ago

I know this is a pretty old thread, but I had a question about updating inputted files. I'm at the point where I can get files (only working with CSV right now) to update (adding new entries and updating existing ones) but I've noticed that deleting entries from the CSV file does not delete from the database. Would I have to write code to check each entry in the database with each on in the CSV?

rainahuang about 1 month ago

www.shoesmaxs.com
www.nikeyeah.com
www.lightupshoe.sale
www.nikeshoesales.com

Skyefrank 29 days ago

That's great.You have done good job.
www.nikemax.shoes
www.mkpee.com
www.nikeshoesales.com
www.shoesmaxs.com
www.lightupshoe.sale
www.mkfact.com
www.mkzho.com
www.mkuker.com
www.nikeyeah.com
www.nikebtc.com

Skyefrank 25 days ago

www.nikemax.shoes
www.mkpee.com
www.nikeshoesales.com
www.shoesmaxs.com
www.lightupshoe.sale
www.mkfact.com
www.mkzho.com
www.mkuker.com
www.nikebtc.com
www.mkyoo.com
www.nikedrill.com

Skyefrank 15 days ago

www.shoesmaxs.com/adidas-originals-c-34_35.html
www.shoesmaxs.com/adidas-superstar-c-34_36.html
www.shoesmaxs.com/adidas-yeezy-750-boost-c-34_37.html
www.shoesmaxs.com/adidas-yeezy-boost-350-c-34_38.html
www.shoesmaxs.com/basketball-shoes-air-foamposite-c-25_32.html
www.shoesmaxs.com/basketball-shoes-air-foamposite-one-c-25_30.html
www.shoesmaxs.com/basketball-shoes-air-foamposite-pro-c-25_31.html
www.shoesmaxs.com/nike-air-max-flyknit-air-max-c-2_33.html
www.shoesmaxs.com/basketball-shoes-kevin-durant-7-c-25_26.html
www.shoesmaxs.com/basketball-shoes-kobe-10-c-25_27.html
www.nikedrill.com
www.nikedrill.com/air-force-1-air-force-1-high-c-51_52.html
www.nikedrill.com/air-force-1-air-force-1-low-c-51_53.html
www.nikedrill.com/air-jordan-air-yeezy-c-1_35.html
www.nikedrill.com/air-jordan-jordan-1-c-1_6.html
www.nikedrill.com/air-jordan-jordan-10-c-1_18.html
www.nikedrill.com/air-jordan-jordan-11-c-1_7.html
www.nikebtc.com/air-jordan-c-7.html
www.nikebtc.com/nike-air-foamposite-c-3.html
www.nikebtc.com/nike-air-force-c-5.html
www.nikebtc.com/nike-air-max-c-41.html
www.nikebtc.com/nike-free-c-89.html
www.nikebtc.com/nike-lebron-c-34.html
www.nikebtc.com/nike-shox-c-121.html
www.nikebtc.com/nike-zoom-c-1.html
www.mkzho.com
www.mkzho.com/michael-kors-bags-c-1.html
www.mkzho.com/michael-kors-bags-mk-clutches-c-1_9.html
www.mkzho.com/michael-kors-bags-mk-hamilton-c-1_15.html
www.mkzho.com/michael-kors-bags-mk-handbags-c-1_14.html
www.mkzho.com/michael-kors-bags-mk-satchels-c-1_8.html
www.mkzho.com/michael-kors-bags-mk-shoulder-bags-c-1_2.html
www.mkzho.com/mk-accessories-c-3.html
www.mkzho.com/mk-accessories-jewelry-c-3_4.html
www.mkzho.com/mk-crossbody-bags-c-5.html
www.mkzho.com/mk-tote-c-6.html
www.mkzho.com/mk-tote-jet-set-c-6_7.html
www.mkzho.com/mk-tote-mk-shoulder-tote-c-6_11.html
www.mkzho.com/mk-wallets-c-10.html
www.mkzho.com/new-arrivals-c-13.html
www.mkzho.com/valuespree-c-12.html
www.mkyoo.com/
www.mkyoo.com/checkbook-wallets-c-52/
www.mkyoo.com/package-deals-c-50/
www.mkyoo.com/satchel-c-49/
www.mkyoo.com/shoulder-bags-c-48/

Skyefrank 14 days ago

Skyefrank about 1 hour ago

www.yastore.eu
www.yastore.eu/kway-c-127.html
www.yastore.eu/moncler-c-8.html
www.yastore.eu/gilet-moncler-c-8_10.html
www.yastore.eu/donna-c-127_133.html
www.yeezyu.co.uk/
www.yeezyu.co.uk/nmd-boost-c-14.html
www.yeezyu.co.uk/ultra-boost-c-24.html
www.yeezyu.co.uk/yeezy-boost-c-29.html
www.yeezyu.co.uk/adidas-zx-flux-c-11.html
www.chaussureshub.fr
www.chaussureshub.fr/jordan-c-1.html
www.chaussureshub.fr/new-balance-c-56.html
www.chaussureshub.fr/nike-air-max-c-259.html
www.chaussureshub.fr/nike-air-force-c-261.html
www.chaussureshub.fr/nike-free-c-72.html
www.ochaussures.fr/
www.ochaussures.fr/nike-air-max-c-76.html
www.ochaussures.fr/nike-air-jordan-c-53.html
www.ochaussures.fr/nike-air-huarache-c-48.html
www.ochaussures.fr/-adidas--c-1.html
www.ochaussures.fr/yeezy-boost-350-c-1_10.htm

First sign in through GitHub to post a comment.