> For the complete documentation index, see [llms.txt](https://openup.gitbook.io/wazimap-ng/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://openup.gitbook.io/wazimap-ng/point-mapper/shaping-data-for-point-collections.md).

# Shaping Data for Point Collections

The easiest tool to create or edit .csv files is Google Sheets — it can open both .csv and .xlsx files, and can export .csv files for upload to Wazimap NG. Any point collection requires the following three fields (as highlighted in red in Figure 2, below):

1. **`name`**;
2. **`longitude`**; and
3. **`latitude`**.

<figure><img src="https://3025923471-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M02trgcnmNckA-WvFeq%2Fuploads%2FxXmzCzgdY0NNwpJ8qaq5%2Fimage11.png?alt=media&amp;token=bc3f5b9b-9d28-4e4c-ad98-bba8189d8cd3" alt=""><figcaption><p>Figure 2: The three fields (in red) required for any point collection</p></figcaption></figure>

As shown in Figure 2, above, additional fields can be included as attributes for each point in the collection. In the Point Mapper view, these additional attributes are displayed in the More Info section of each point’s tooltip (refer to [**`Navigating Point Mapper`**](/wazimap-ng/point-mapper/navigating-point-mapper.md)).

The **`name`** field (column) of your point collection cannot be formatted as a number. It may be necessary to format the entire column to plain text by selecting the entire column and clicking **`Format > Number > Plain text`** (see Figure 3, below).

{% hint style="warning" %}
Since the attributes under the `name` column are displayed on the tooltip in Wazimap NG, it is important to label your points appropriately (refer again to [**`Navigating Point Mapper`**](/wazimap-ng/point-mapper/navigating-point-mapper.md)).
{% endhint %}

<figure><img src="https://3025923471-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M02trgcnmNckA-WvFeq%2Fuploads%2F4kW98pCSTh0IuqJRQGuc%2Fimage12.png?alt=media&amp;token=8230b074-8ca6-41c3-8e9d-cdbd569dc77a" alt=""><figcaption><p>Figure 3: Formatting the Name column to plain text in Google Sheets</p></figcaption></figure>

Additionally, column headings cannot start with a number (e.g., <mark style="color:red;">**`2019`**</mark>**` ``HDI`**), contain periods (e.g., **`SDG 3`**<mark style="color:red;">**`.`**</mark>**`1`**), or contain square brackets (e.g., **`HDI over the Years`` `**<mark style="color:red;">**`[`**</mark>**`Average`**<mark style="color:red;">**`]`**</mark>).

{% hint style="warning" %}
No cell within the first row below the column headers can be left blank either — if no attribute exists in these cells, simply add **`no data`**. A blank cell will result in that attribute not being displayed for any points (even if they have a value).
{% endhint %}

Once your point collection is complete (has the three required fields, is formatted correctly, and contains no blank cells in the first row), it can be exported as a .csv file. To do this, click **`File > Download > Comma-separated values (.csv)`** (see Figure 4, below).

<figure><img src="https://3025923471-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M02trgcnmNckA-WvFeq%2Fuploads%2FWuEMiXUfoDC4M4EGG2j8%2Fimage13.png?alt=media&amp;token=45f52fad-e363-43d5-a985-8993a3bf054f" alt=""><figcaption><p>Figure 4: Exporting a point collection as a .csv file from Google Sheets</p></figcaption></figure>

{% hint style="warning" %}
Take note of where this .csv file downloads to — you will need to locate it for upload to Wazimap NG later.
{% endhint %}