---
title: "Prepare your list of location in the template"
url: "https://kb.chargeplanner.ai/en/article/fill-the-template"
language: "en"
last_updated: "2025-07-07T10:21:09.430Z"
---

# Prepare your list of location in the template

In this step, you’ll **prepare the Excel file that contains the list of locations to be tested** in your project. Whether you’re evaluating new potential sites or testing changes to existing ones, this file is the starting point for uploading your data into the module. 

### **Hotspot exercise projects**

The following information needs to be provided for each of the locations / lines: 

#### **Step 1: Fill in the required characteristics in the "General Information" section**

> *The columns in **bold** are mandatory. All the other columns can be left blank or can be removed. In that case the default value will be considered.*

Here you need to give information on **the localisation** of the location:

-   The **location name**, this will be the name you will see in the results table
-   The **name of the brand** for which you want to test the locations (in order to know which brand you can choose, the tab "Guidelines" gives a full overview) 
-   **Country** of the tested location; BE, NL, DE, FR, ES,UK... Use the official two-letter ISO country codes.
-   Either **address fields** (address, postal code, city) or **coordinates** (lat, lon) must be provided (see note below).

> *Additional information on address fields & coordinates :* 
> 
> *Locations must have or coordinates or either the full address fields or both. You can provide:*
> 
> -   *either coordinates without any address information; the address fields will be found by reversed geocoding.*
> -   *or complete address fields without coordinates; these will be assigned by geocoding the indicated address, in case of low accuracy of the address, you will get notified in the following* [***step***](https://kb.chargeplanner.ai/en/article/upload-the-template)*.*
> -   *or both coordinates and address fields; the tool will always prioritise coordinates for the geographical positions.* 

![](https://cdn-assets.productfruits.com/41d05c6f-749d-47a8-a5cf-faa8672a5175)

#### **Step 2 : Location informations**

Here you need to give the **general configuration** for the charging location. When you leave a cell for a characteristic in the Excel file blank, the default value will be assigned/calculated.

-   **#**  **Ultrafast** charging points (>150 kW)
-   **#** **Fast** charging points (49 - 150 kW)
-   **\# Slow** charging points (<50kW): As our model does not predict consumption for Stay & Charge, this will have no impact on the prediction. You can delete this column from the table or leave it empty. You can then adapt this procedure to specific cases.
-   **Average power of all chargers by type**: indicate the average power of all charging points on the location by power category (fast, ultrafast).
-   **Maximum power** among all chargers by type: indicate the maximum power of all charging points by power category (fast, ultrafast)
-   **Price** per kWh (ultra) fast charging: indicate the price per kWh for the location

> **Tip: How to find an optimal configuration**
> 
> If you want to assess the optimal configuration for a site, it is possible to test multiple combinations of charging points. Each tested combination should be a separate line (linked to the same location name).

#### **Step 3: Fill in the segment information**

Here you can give extra information on each of the segments "Charge & Go" &"Visit & Charge". When you leave a cell for a characteristic in the Excel file blank, the default value will be assigned/calculated. It is also possible to remove these columns from the table.

-   **State:** Enter here "Open" for "Charge&go" & "Visit&charge" (They are "Open" by default). 

This is an example of how the file can be filled out:

![](https://cdn-assets.productfruits.com/a18b043b-3394-4894-84dd-5454f19a14a7)

> ***Important remark :*** *The number of lines to be processed per file is **limited to 3 000.***

### **Optimal characteristics projects**

The Excel file you downloaded contains the **full list of your actual network** (based on the period you [previously chose](https://kb.chargeplanner.ai/en/article/select-a-period)), with their actual characteristics.

You have to **edit** the Excel file to **modify the location characteristics you want to test**. We recommend changing only one location characteristic at a time (per row)  to accurately assess its impact. Changing multiple characteristics simultaneously will result in a combined effect, making it harder to isolate individual influences.

From the column "**General attributes**", you can change the characteristics of your locations, previous columns are mandatory and they must not be modified.

* * *

Once your file is ready, you can go to the next step: [**Upload the template**](https://kb.chargeplanner.ai/en/article/upload-the-template)