First of all, Thank you so much for purchasing the Located - Store Mapper.
This documentation is to help you regarding each step of customizing your map. Please refer to the sidebar to find topics you are looking for.
When importing the only columns that are required are the name and address/(latitude and longitude). If the address is not included you will need the latitude and longitude and vice versa. however you should not delete columns from the template as they are need when importing even if they have no data.
If your locations are in the format of city,state,zipcode, etc then you can combine these all into one column using excel and the instructions in this link. If you still cannot get the formatting correct you can email your spreadsheet to email@example.com and I can help you get it into the correct format.
Note that if you have any tags added into the tags section in the manage locations popup the marker icon and marker color setting will be ignored. You will have to set the marker icon from the tags section for each tag.