Use Flask to convert a Pandas dataframe to CSV and serve a download

Question

I have a Pandas dataframe in my Flask app that I want to return as a CSV file.

return Response(df.to_csv()) 

The problem is that the output appears in the browser instead of downloading as a separate file. How can I change that?

I tried the following as well but it just gave empty output.

response = make_response(df.to_csv()) response.headers['Content-Type'] = 'text/csv' return Response(response) 

Answer 1

Set the Content-Disposition to tell the browser to download the file instead of showing its content on the page.

resp = make_response(df.to_csv()) resp.headers["Content-Disposition"] = "attachment; filename=export.csv" resp.headers["Content-Type"] = "text/csv" return resp 

Answer 2

This is pretty much the same solution but you can just pass the same info into Response:

return Response(        df.to_csv(),        mimetype="text/csv",        headers={"Content-disposition":        "attachment; filename=filename.csv"})