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. 

Thank you Evan.  I did a small test on this and was able to get the info in a table, along with some other columns of data.  I only used about 750 records for this test, not the full  6000 addresses.  To your question, this was  an import of all new records.  

I'll have to do a few more trials to see if I really "got it down" with this procedure.  One other thing...I now notice that when I click on a record, the only info that comes up on the form is the map.....not any of the other fields.  Did I do something wrong when I imported the data this time?  Thank you very much for your help!  Mark

Mark, you will need to do a "Customize this form" when viewing a record to add the extra fields to the form.

Do I have to do each one, one at a time, or is there a way to just add all the fields to the form?

one by one.  I think that when fields are created during the import process, that they may not automatically get added to the form.

When viewing the record it will show the map with the address displayed just at the top of the map as a link and then when editing the same form it will show you the field to edit the address spread out. It just doesn't display each line individually as they all get grouped into the listing at the top of the map. If you also want to list out the address separate from the map you would need to add the sub fields. 

Thanks.  I know somehow when I went thru many trials yesterday that all fields were automatically added to this form, but perhaps I missed a switch somewhere this time.  Seems a bit dumb that you can't do a "all field" selection and add after the table is generated....

There may have been an option right after the import to add fields to form.  If you deleted the fields and re-imported and re-created them, maybe that question would pop up.

Thanks very much for the clarifications!