So, you need to export a CSV.
As with everything in Ruby on Rails, it's really easy to do this.
I will walk through how I built this feature to export sales leads on another Rails app of mine. But this same approach can be applied to any data you want to export as a CSV file.
We are going to build an endpoint that a user can navigate to, that will trigger a download of the CSV file.
The idea is, they land on a route like this https://example.com/export/leads.csv
and we start a download instead of rendering a normal page.
Create the Route
First we need to create a route that we point the user to.
Add something like this to your config/routes.rb
file:
get 'leads/export', to: 'leads#export'
Change the name of your controller to whatever you want. Same with the method name. I went with export
because that makes it clear what this method is responsible for.
Create the Controller
Rails will expect the leads controller to be defined at app/controllers/leads_controller.rb
, let's create that.
Initially, the contents of this controller should look something like this.
require 'csv'
class LeadsController < ApplicationController
def export
@leads = Leads.where(organization_id: current_user.organization_id)
respond_to do |format|
format.csv do
response.headers['Content-Type'] = 'text/csv'
response.headers['Content-Disposition'] = "attachment; filename=leads.csv"
end
end
end
end
We need our export
method to do a few things here.
- pull data from the database
- convert our data into a CSV file
- format the response so we download the CSV
First let's pull the data. We'll need to build a query and save the results to an instance variable.
@leads = Leads.where(organization_id: current_user.organization_id)
Next we have to convert the result of this query into the CSV format.
At the top of our controller let's import the built-in Rails csv
library:
require 'csv'
And now we can format our controller to respond when CSV is requested. Rails uses the respond_to
method to allow controller endpoints to respond to multiple formats. You will see a lot of endpoints that respond with HTML, JSON, and even XML.
Here's what those formats would normally look like.
respond_to do |format|
format.html
format.json { render json: @leads.to_json }
format.xml { render xml: @leads.to_xml }
end
We'll need to slightly modify this to return CSV data.
Our version will instead respond to format.csv
:
respond_to do |format|
format.csv do
response.headers['Content-Type'] = 'text/csv'
response.headers['Content-Disposition'] = "attachment; filename=leads.csv"
render template: "path/to/index.csv.erb"
end
end
This means when someone makes a request to our URL, which was https://example.com/export/leads.csv
, the tailing leads.csv
extension tells our server to respond with the csv format.
Also, these Content-Type headers tell the browser that we are returning a CSV file to download.
Building the CSV File
Our backend is fully wired up to export CSV for the user.
Now we need to generate the actual CSV file. The controller will automatically render the template found at app/views/leads/export.csv.erb
.
Let's create that, and then here's what it will look like:
<%- headers = ['Email', 'Date'] -%>
<%= CSV.generate_line headers %>
<%- @leads.each do |lead| -%>
<%= CSV.generate_line([lead.data['email'], lead.created_at]) -%>
<%- end -%>
Formatting a CSV file is very straightforward in Rails. We just need to call CSV.generate_line
to add a row.
First we declare a variable called headers
, and store the headers of our CSV file.
<%- headers = ['Email', 'Date'] -%>
Next we generate the first row for these headers with this call:
<%= CSV.generate_line headers %>
And last, we loop through our query result and again generate a row for each lead:
<%- @leads.each do |lead| -%>
<%= CSV.generate_line([lead.data['email'], lead.created_at]) -%>
<%- end -%>
And that's it.
Now we have an endpoint that a user can access to download their data as a CSV. You can point users to this endpoint with a button and the download should begin automatically.
Something like this should do the trick!
<a href="/leads/export.csv">Export CSV</a>
Of course, replace the query I used and pull whatever records you want in your controller.
Pass CSV.generate_line()
as many arguments as you want columns, and don't forget to pass headers in the first line to match!