Importing address info from a large spreadsheet and then creating address field -Step by Step?

Hi Mark,

When you are importing in this list of addresses into a spreadsheet are these supposed to be entirely new records or are they supposed to be updating records that already exist in Quick Base? If you are just importing in entirely new records you do not need to have a Record ID# field, Quick Base will import those new records in and assign them a record ID manually if you do not include it in the import. Otherwise if you are importing to update existing records you would want to include the Record ID of the records to be updated.

You will get a pop up message anytime you set an import to include the key field of your table just warning you that if you are importing in with a Record ID it will update existing records. That is just a warning to make sure the import is intentional and to prevent someone from accidentally picking the Record ID# when doing an import and overwriting the wrong records. 

Does your address field exist already in your table? If it does not I would suggest to create your address field first as that will make importing data in much easier. Then from there you would want to make sure your spreadsheet is broken up to line up with the address sub fields so essentially a column for street address 1, street address 2, country (If it is set to international) city, state, zip. This way when you go to import you can set the fields to line up as you need them to. It should look something like the image below when importing in.



This way each column in my import is set up to be named just like the fields in my application which means when I go to import Quick Base is able to match them up for me and it will update my existing records with these new addresses. I hope this suggestion on importing addresses in is helpful.