Forum Discussion
In general you can import data into Quickbase by importing a CSV file (or Excel xlsx format) and during the import process you match up the columns on the CSV with the target fields they are to be mapped to. That is available under the import / export menu located among other places under the options for the table home page.
Where is becomes more tricky is if there are multiple Google sheets which are inherently Parent Child relationships and you need to match up the children with their Related Parents. That is the case we would have to understand more about the relationships between your various tables in order to give you some guidance there. But if it's a single table import it should be pretty straightforward.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- KaylaShugart2 years agoQrew Member
Thank you, Mark. I'm working on a draft version of this in my builders account to test it out. I'm nervous about importing all these fields incorrectly into our company account and causing a mess.
------------------------------
Kayla Shugart
------------------------------- KaylaShugart2 years agoQrew Member
Apologies, I forgot to add. I can prep the CSV to be clean and aligned to the fields from the screenshot in the app, but I'm not sure how to connect the two once I've imported the csv?
------------------------------
Kayla Shugart
------------------------------- MarkShnier__You2 years ago
Qrew Legend
Can you clarify. Are you saying you want to do a one time import and move the source of truth over to Quickbase, or are you saying that the ongoing source of truth is Google sheets and you want that mirrored in Quickbase on some automated basis to reflect what is the source of truth in Google sheets.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------