If you need to get an overview of your customers or your suppliers, importing your data on the map is a very useful feature to analyse your catchment area.
With OALLEY, you can add your own data to the map from an Excel file to perform a detailed analysis.
Preparing the file to be imported
To import your data on the map, you must have an Excel file containing the addresses of your points or GPS coordinates.
Your file must contain column headers, and a least one column containing addresses or GPS coordinates. Here is an example of file that can be imported:
You can have as many columns as you want in the file.
Saving the file as a CSV
To import your file in OALLEY, you need to save it as a CVS file:
- File > Save as
- Click on Browse
- In the dialog box, in the Save as type: zone, choose CSV (Comma delimited).
If you need detailed information, you can read this tutorial from Microsoft.
Import your data
To start importing your data, click on Add your data :
And then click on Add data :
This will open the data import popup :
Type the name of your dataset, and select the .csv file you want to import.
Indicate the header of the colomn that is used to geolocate your data (addresses or coordinates) :
Click on the Import button. Wait until the import is completed and click on Close.
Extracting data in a catchment area :
Once your data imported, you can see them on the map, know how many are in a given area, and extract them from a given area.
To do this extraction, go to Your data in the area analysis panel :
To see all your dataset on the map, click on the geolocation button of a given dataset.
To analyze your dataset in a given area, chosse the are your want to analyze ion the analysis panel, or directly on the map.
On each of your datasets, you will see the number of points existing in the chosen area. You can export these points and the related data by clicking on the download button of the dataset.
Now you know can import your own data on the map and analyze them. Go to the map to start importing your data.