Forum Discussion

MuraliGangineni's avatar
MuraliGangineni
Qrew Cadet
7 years ago

Download Excel CSV file directly to the local system on the click of a button on the Table Report

I want an Action button on the current page table report where clicking on that button will directly downloads the Excel CSV File to my Local System. Is it possible to have a button like that in Qui...
APIs and custom code
App builders
Ask about Quickbase functionality
EvanMartinez's avatar
EvanMartinez
Moderator
7 years ago
Hi Murali, 

Currently a report can be saved as a CSV by using the option to Import/Export or 'Save as Spreadsheet' under the More dropdown on a table report. 'Save as Spreadsheet' will jump right to creating a CSV to download. Either will allow a user to pull the data from a Quick Base table into a CSV. Out of curiosity is there something about the two options under the More dropdown that make them undesirable for your use?_
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
7 years ago
He wants a friction-less single button way to download and doesn't want to navigate through the GUI.

My technique is very general but you can make it even simpler by just adding &opts=csv to the end of the report URL. This example will immediately download the CSV for the Formula Function report

Download Formula Functions Report as CSV:
https://login.quickbase.com/db/6ewwzuuj?a=q&qid=6&opts=csv

QuickBase immediately downloads the report as CSV because of the way the content-disposition header is set in the response. What you don't get with this simpler approach is (1) the ability to name the CSV file or (2) potentially modify the CSV in some fashion prior to download.

The technique I have supplied is extremely general. You can download your QuickBase data in any text format you want with the download(filename, content) function with a single button click.