Discussions

 View Only
Expand all | Collapse all

Connect QB Tables with excel so that we dont have to go to QB all the time to update records.

  • 1.  Connect QB Tables with excel so that we dont have to go to QB all the time to update records.

    Posted 06-14-2019 17:34
    Is there an easy way to connect QB tables with Excel? I tried to use From Web option in excel, however, it doesn't work. Please let me know if I am missing anything.
    step1
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1793360/RackMultipart20190614-72308-15m3idk-Step_1_inline.PNG?1560533496">
    Step2 - no response from here
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1793361/RackMultipart20190614-26372-1vcxw4b-Step_2_inline.PNG?1560533535">


  • 2.  RE: Connect QB Tables with excel so that we dont have to go to QB all the time to update records.

    Posted 06-21-2019 16:51
    Hello Raakesh,

    You can easily create a quickbase data table connected to your excel file with some limitations. Your excel file must be stored as .csv file.

    To do this in the QuickBase UI, click New Table and select Using connected data as shown below.