Put street address in column A and city-state-zip in column B, like this:

In CSV file:

600 CITRUS AVE STE 100J,FORT PIERCE FL 34950
542 KENNODY,MCGIRR IL
242 W D HILL RD,SHERMAN TX 75092

Alternatively, you can put city, state and zip in columns B, C and D, like this:

In CSV file:

600 CITRUS AVE STE 100J,FORT PIERCE,FL,34950
542 KENNODY,MCGIRR,IL,
242 W D HILL RD,SHERMAN,TX,75092

Close