How to create a HERE Places extract in MS Excel format using HERE PEP (HERE Places Extract Portal) Tool

The HERE Places Extract Portal (PEP):

HERE Places Extrakt Portal | Welcome (https://pep.ext.here.com)

How to define the format of the Places Extract

After Product Creation variables have been selected, please chose Extract Type "CSV" - before submitting the request



Creating a .xlsx-file out of the product file

Please save the file on a local folder and unzip the file twice:



Open the file with MS Excel

In Excel open the saved file "Data - From Text/CSV



After defining "Tile Origin" (i.e. UTF-8), "Delimiter" (i.e. Tab), "Data Type Detection" (- if needed), press "Load".

The .xlsx-file will open accordingly.

Example: