Prepare data for plotting

Usually customer data or business data comes in the format supported by Map Business Online. Importing such data is no-brainer. Map Business Online requirements to the data format are quite simple:

  • Each row in data file must correspond to one and only one customer, dealer, store, POS, or business record. Map Business Online will convert each row from the file into a location on map.
  • Address information must be split into Street address, City, State, and ZIP code columns. You don’t need all the columns to be present in your file. Usually Street address, City, and State are enough, or you can have just Street address and ZIP code. Note that Map Business Online can plot by ZIP code alone. It also supports a variety of other geographic identifiers including but no limited to City & state, latitude & longitude, or county FIPS code.

Here is an example of data file that corresponds to all Map Business Online requirements:

On another hand data demonstrated on the picture below doesn’t match Map Business Online format:

If you plot the file in Map Business Online, you will get two locations on map for Stone Age Computing instead of one. This is because you have products listed as records and not as columns. In such case you need to re-organize your data. You can use pivot table in Microsoft Excel or shuffle data manually but at the end you will need to format the dataset as following. The picture below shows that we have added Sales A, Sales B, and Sales C columns for respective product sales to our data sheet. Now the data is in format acceptable by Map Business Online:

Don’t hesitate to Contact us if you need help with data sheet re-organization.