Open the exported CSV file from the Census Portal
1. Insert one row
2. Add these column titles: ScbID, Address, Match, Status, AddressCombined, Coordinates, CensusID, Label, ScbLongitude, ScbLatitude
3. Delete any rows that do not have coordinates returned
4. Enter
these formulas in columns I and J
CALC LONGITUDE IN EXCEL:
=LEFT(F2,FIND(",",F2,1)-1)
CALC LATITUDE IN EXCEL:
=RIGHT(F2,LEN(F2)-FIND(",",F2,1))
5. Now import the CSV file and update only using the primary key.