Forum Discussion

AdminEntry's avatar
AdminEntry
Qrew Cadet
8 years ago

Automatic download of QuickBase data to Excel spreadsheet

I'm using a data connection ("From the web") in Excel to automatically download the data that I need from QuickBase. The only issue I'm facing now is that from time to time my data connection seem...
Data import and export
AlisherNizamov's avatar
AlisherNizamov
Qrew Trainee
7 years ago
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.
  • AdminEntry's avatar
    AdminEntry
    Qrew Cadet
    7 years ago
    Hello Alec,

    Here's how I made this work for me.  

    1. Make sure the report you want to export/download is in "Normal" format.

    2. Set the Dynamic Filters to "None".

    3. Uncheck the "Allow users to search using the Quick Search field".

    4. In Excel, make the connection to the report in the way you specified. Make sure that when you get to the step where you select the dataset you want to download, you click the little arrow that selects the entire table.

    5. The report will download and it will look wonky. Don't worry about that. Now go back to Quick Base and change the format of that same report to "Tab-Separated Values" and save it.

    6. Go back to Excel and refresh your query.  You should now see the report in the format that you need.

    Hope that helps.

    Juan
  • AlisherNizamov's avatar
    AlisherNizamov
    Qrew Trainee
    7 years ago
    Juan, thanks for the response.

    Here is what I am doing: in Excel I go to Data - New Query - From another Source - From Web - in the dialogue in the URL field I paste the link of the quickbase where the table sits - hit OK and below is what it displays. The headers in the display table are not what I have in the table in QB.