Feature available: PRO plan
Whether it is to visualize your customer file or the location of your suppliers, being able to add points on a map can be an essential functionality for the analysis of your catchment area.
Important: All data imported to OALLEY is only stored locally on your computer to guarantee the security and confidentiality of your data.
With OALLEY, you can add your own points on the map with data from an Excel file for a more detailed analysis.
Preparation of the file to be imported #
To import points on the map you must have an Excel file containing the list of addresses or GPS coordinates of your points.
Your file must absolutely contain a header in the first line, with at least one column for the address or GPS coordinates. Here is an example of a format you can import :
You can have as many columns as you want in your file.
Important: the cells containing the addresses must not contain a line break.
Save the file as CSV #
To import your file to OALLEY, you must save your file in CSV format. In Excel, the procedure is as follows:
- Click File > Save As.
- Pick the place where you want to save the workbook.
- In the Save As dialog box, navigate to the location you want.
- Click the arrow in the Save as type box and pick CSV UTF-8 (Comma delimited).
Import data #
To start adding data, click on “Add your data” in the Analysis and Data panel:
Then click on “Add Data”:
This opens the data import window:
Enter the name you want to give to your dataset, and choose the .csv file to import.
Then select the label of the column allowing to geolocalize your data:
Click on the Import button. Wait until the import is completed and click on Close.
To go further: