This is a super common question with a very quick solution. It’s also a great Excel/Google Docs trick to know with a ton of other uses.

Uploading to Storemapper requires that your address is all on one line in one column like:

| full address |

| 123 Main St. Washington, DC 20001 |

But sometimes you have your raw data split across columns. Something like this:

| street              | city                | state | zipcode |

| 123 Main St. | Washington | DC    | 20001   |

The above video is a very quick way to combine all those columns into one in seconds and paste them into our template. Of course if you get stuck on this, just email us the CSV and we’ll help you sort it out.