Automatic download of QuickBase data to Excel spreadsheet

Excel is acting like a newly opened second browser in a sense so that the ticket / credentials established with your current browser (Chrome, FireFox, Edge etc) session has nothing to do with the ticket / credentials established for the newly opened Excel session. In other words you have to log in QuickBase from Excel to establish a independent QuickBase session even if you have a session active QuickBase session in your browser.

I don't have Excel on my current machine but I did test the following procedure using Open Office Calc which has a similar but different interface to Excel's Web Query feature (Microsoft may have renamed this feature in more recent versions). In Calc you don't have those yellow boxed arrows as Excel has so you have to use this navigation:

Insert | Link to External Data | Paste URL | Select Table Identifier

The URL I pasted into Calc was as follows:

https://haversineconsulting.quickbase.com/db/main?a=SignIn&loginid=HaversineConsulting&passw...

Unrolled the URL looked like this:

https://haversineconsulting.quickbase.com/db/main?a=SignIn
&loginid=HaversineConsulting
&password=MYPASSWORD
&nexturl=https://haversineconsulting.quickbase.com/db/bgcwm2m4g

I then selected a Table Indentifier (a cruder selection mechanism to Excel's boxed yellow arrows) and that table populated. What is going on is that Calc is logging in to QuickBase and following the redirect to the URL specified through the nexturl parameter. I would try a similar URL from your application but initially specify a nexturl parameter without any ampersands in them to test if Excel will operate similarly. If it does you can URLEncode any ampersands in the nexturl parameter.

Let us know if this procedure works in Excel (I think it will)

and, what about when the login string, combined with the nexturl string, and the API to get the particular query I want... altogether is just too many characters? is there a way to hop from one page to the next programmatically?

Hi Jonathan, I installed the Selenium reference into my Excel.  The VBA commands allow me to navigate around QuickBase and collect data. 

Hello,

I am looking into creating an excel query for a quickbase table. I used the Data - New Query - Web Query, in the field I insert the web site where the table sits and hit Enter. Excel returns a Navigator window where the table view shows a two-row four-column table that is not even close to what the actual table has.

My goal: I pull tables from quickbase on a regular bases and wanted to automate the operation by creating a web query and refreshing it every time I am ready to export tables from QB into excel. 

I have read the posts regarding my matter but the posts are old and the approaches are not working in my case.

Thank you in advance,
Alec.

Ping Eric at Data Collaborative    WIth their DC Merge tool, you can do it easily.

Take a look at our XL Docs for Quick Base add-on

You can demo it here:  https://juicedtech.quickbase.com/db/bj446yrpq

Keith
info@juicedtech.com

Hello,

I did not see any other responses for my thread. I thought if we get this resolve, it would benefit many quickbase users. Below is my whole idea of what I want:

My process: I pull several tables from quickbase every week and it is manual.
What I want (possible solution): An excel template with live connections / queries to the quickbase tables where I refresh them every time I need the tables and use the tabs. This will eliminate manual pulls that are time consuming and so repetitive at times.

I was able to get to the point where it directs me to save or open the file. I am looking for more intelligent ways to manage the repetitive processes.

Thanks and look forward to hearing solutions.
Hope many of us will benefit from this.

Alec.