Sometimes you will be asked to convert geozone .csv that was extracted from TT1 by SW, to a one, that fits TT2 geozone import requirements. Format of TT1 and TT2 geozone .csv is very similar, its just that the information of each geozone is written in one column in TT1 format, but it needs to be split in separate columns for TT2.

The format for TT1 is

"id,poi_name,address,latitude,longitude,notes,radius,creator_id" (in a single column)

The format for TT2 is

"poi_name;address;latitude;longitude;notes;radius" (“;” denote separate columns)

1. Select all entries with Ctrl + A.

2. Select "Data" -> "Text to Columns".

3. Select "Delimited" as original data type. Press Next.

4. Select "Comma" as delimiter. Press Next.

5. Do not make any changes on step 3, simply press "Finish".

6. The result:

7. Delete id and creator ID columns, as they are not needed.

8. Delete the headers (first row) and save as a .csv file. It is ready for UPLOAD!

Note: If you open the file from Note++ or Notepad it should look as something like this (notice how columns are delimited by “;” and there are no headers).

Also notice that only poi_name, latitude and longitude are mandatory fields.