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:
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.