Skip to main content
Question

Automatic export from QuickBase into Excel

  • October 16, 2013
  • 0 replies
  • 764 views
Hello!

There are a few parts to this project I'm trying to complete. First, I have specific filtered table reports I've created in QuickBase in multiple different tables. I'd like to automatically export the filtered reports into specific Excel sheets in a workbook.

For example, I have a table called "Clients" where I've created the report, "Active Clients". I also have an Excel Workbook called "Fact Sheets" with multiple different tabs (sheets). One of the worksheets is called "Clients". I want to export my Active Clients report into the Clients worksheet.

Is this possible? I've been trying to read up on the API guide (https://www.quickbase.com/api-guide/index.html) but it doesn't sound exactly like what I'm looking for.
This topic has been closed for replies.

  • DavidHawe
  • Quickbase Alumni
  • October 17, 2013
I would suggest finding an Excel expert. I am not sure but I believe you can use the "From Web" wizard or possibly use the embedded VBA in Excel to employee the QuickBase API to import QuickBase data to a sheet in Excel.
  • AnnaTamaoka
  • Author
  • Quickbase Alumni
  • October 17, 2013
Thank you! I'll try both suggestions and see how it goes. :)
  • anomDiebolt
  • Quickbase Alumni
  • October 18, 2013
You can do a "Web Query" from Excel. Under the Data tab select "From Web" (displayed on the far left) and browse to your QuickBase table and you are off to the races.
  • AnnaTamaoka
  • Author
  • Quickbase Alumni
  • October 18, 2013
Thank you for your response! I tried to do this, and it was almost exactly what I wanted. Unfortunately, the output was a bit more complicated than I have the knowledge for. So the short answer is that this would be able to work for anyone trying to do this, but I don't think it would work for me.

The long answer (if anyone is interested), is that I need the data of the table that I pull to appear in column/row A1. When I try to pull over the report from QuickBase, it seems to carry over much more information than is visible, including all 6 different types of reports and descriptions (i.e. "Table; Show your data in a spreadsheet-style report with rows and columns.") as well as the filters of the report and the summary of how many records are available. Another thing that doesn't work for me is that I have some multi-line text fields that show up in one cell per line; I need all lines to appear in one cell.

Thank you for your help!
  • anomDiebolt
  • Quickbase Alumni
  • October 18, 2013
Read this article:

http://www.kimgentes.com/worshiptech-web-tools-page/2010/8/19/web-connecting-csv-files-as-external-data-to-excel-spreadshe.html

The URL you would use would be a CSV report using either a report with this setting:

Options | Format = Comma-Separated Values

Or a URL that calls API_GenResultsTable

https://YOURSUBDOMAIN.quickbase.com/db/YOURDBID?act=API_GenResultsTable&qid=1&options=csv
  • AnnaTamaoka
  • Author
  • Quickbase Alumni
  • October 18, 2013
This is really helpful! I'll play around with this and see if it fits my needs. If not the project I'm working on, definitely another one I'm involved in. Thank you!
  • MM29114
  • Quickbase Alumni
  • December 4, 2013
Anna,
were you able to figure out how to get [Field 1] to pull into Cell A1 in Excel, and [Field 2] to pull into Cell B36 (or whatever other cell you wanted it to go into?
  • AnnaTamaoka
  • Author
  • Quickbase Alumni
  • December 6, 2013
Hello!
Thank you for following up. I don't think I was able to do exactly what I wanted, but it turned out that the group I was working with decided to go a different direction with the project that would benefit them more in the long run. We'll see...I may need to open this topic back up in the future, but for now I think everything is all set.

Thank you!
  • ArchiveUser
  • Quickbase Alumni
  • March 13, 2014
https://YOURSUBDOMAIN.quickbase.com/db/YOURDBID?act=API_GenResultsTable&qid=1&options=csv


This looks like something I could use....What would be the values I need to replace in the above line...?  "YOURSUBDOMAIN" I would replace with my sub domain...
What about "YOURBID?" what would replace this?
Where would I put the table name?

Sorry...new to trying this, but this would make the whole export table go much better.
Terms & ConditionsAccessibility statement