How to separate an excel Geocode import

AndyNoble — Thu, 29 Aug 2019 20:35:01 GMT

How can you import multiple address from an excel sheet and add a separator? I have a list of businesses and a list of our Company Branches; I would like to put a different icon for the businesses and our Locations. I wonder if there is somewhere to do it by Type of Company/Address?

Ideas?

Re: How to separate an excel Geocode import

ShannonChavez — Mon, 09 Sep 2019 19:51:48 GMT

Good Afternoon Andy,

Thank you for your inquiry! From your post, I can identify 3 potential workflows. Can you help clarify for me the following (my questions are in bold):

How can you import multiple addresses from an excel sheet and add a separator?
- Do you have the addresses in excel currently? or do you need to import address into excel?
- Here is the online documentation on adding a map using excel
- What do you mean by separator? See examples below:
  - One address per cell
  - Two address with separator
I would like to put a different icon for the businesses and our Locations?
- Are you wanting to use your own image? In Maps for Office, see Style Layers > style by location (single symbol) > Advance options > Use a custom image >
- Or our styling options See Choose a layer theme
I wonder if there is somewhere to do it by Type of Company/Address?
- You may add data using an address but ensure it is in the recommended format, keeping in mind there is an associated cost to geocode {40 credits per 1,000 geocodes}.

I hope this was helpful! Please let me know if you have any other questions.

Best,

Shannon | Product Engineer

topic How to separate an excel Geocode import in ArcGIS for Office Questions

How to separate an excel Geocode import

Re: How to separate an excel Geocode import