Behind the Bytes: Exploring the World of Digital Forensics Incident Response

KMLer: a CSV / XLSX to KML Tool

Tool output point and horizontal accuracy depicted through Google Earth.

KMLer – a free-to-use CSV / XLSX to KML tool! KMLer supports point files, Horizontal Accuracy visualization, and easy Extended Data selection.

Location data is some of the most powerful information available in digital investigations – but turning raw coordinates in a spreadsheet into something meaningful and visually clear can be frustrating. Investigators and examiners frequently receive and export location data in CSV or XLSX format yet need KML files for effective mapping and analysis.

KMLer was created to bridge that gap.

This free, offline tool converts CSV and XLSX files into KML format quickly and reliably, while also supporting horizontal accuracy visualization and customizable Extended Data. Designed with investigative workflows in mind, KMLer runs entirely offline – eliminating the need to upload sensitive case data to third-party websites – while still providing clear visualization and defensible reporting.

Version 1.0 Features:

  • Easy to install and use application
  • CSV / XLSX table preview in real time
  • Horizontal Accuracy visualization with custom color and transparency
  • Selectable Extended Data attributes
  • Processing data to include hash values (SHA-256 and MD5) included in the final Processing Report PDF file.

CSV / XLSX Preview:

Start by selecting your input file and the contents will immediately be available within the preview window. Columns sizes are adjustable, and horizontal scrolling is supported.

Previewing the contents assists in the accurate selection of Latitude, Longitude, and (if present) Horizontal Accuracy.

Latitude / Longitude Auto Selection:

We have incorporated logic that may auto select your Latitude, Longitude, and Horizontal Accuracy columns. If not, dropdowns are present to allow column selection or change.

Horizontal Accuracy Visualization:

When applying visualization to mapping functions we know some things work better than others. That is why we support Accuracy Color, allowing you to select the exact color that best suits your needs.

Need more or less transparency? That’s supported too – default is 50% (0.5).

Extended Data Options:

KML Extended Data (ExtendedData) is a mechanism for attaching custom metadata to features in a KML file. This allows users to include additional information beyond the standard KML fields.

In our program, you can easily add Extended Data by selecting column names in the Extended Data Options window.

Don’t need Extended Data? That’s fine – the program works just as well without it.

Processing:

The Process button is not available until an output location and file name is selected. Your file name will be adjusted with “_points” and saved within your output location.

If your data supports Horizontal Accuracy alongside the point data then another file with “_polygons” will be saved as well.

Processing Report:

Generates a PDF documenting KML production. Captures the input file location and its hash values (SHA-256 and MD5). Records all KML output file locations and their hash values. Additional KML settings and Extended Data selections are also documented.

Get it Today:

KMLer is available to download at our GitHub here.

Acknowledgements:

This software includes the CustomTkinter library, which is licensed under the MIT License. Copyright (c) 2023 Tom Schimansky. The full license text can be found in the LICENSE file provided here.

This software uses the Pillow library (PIL fork), licensed under the Historical Permission Notice and Disclaimer (HPND).

This software uses the ReportLab library, licensed under a BSD-style license. Copyright (c) 2000-2025 ReportLab Inc. Licensing information for the open-source version of the ReportLab toolkit can be found under 1.3 here.

This software uses the openpyxl library, which is licensed under the MIT License. Copyright (c) 2010–2024 Charlie Clark, Eric Gazoni, and other openpyxl contributors.



Leave a comment

About US

Metadata Forensics, LLC’s mission is to provide thorough and accurate digital investigation services. Seeking the digital truth is what we strive for in each case, and client satisfaction is one of our top priorities. Metadata Forensics, LLC has global experience in digital forensic investigations and uses the industry-leading tools in our quest for the answers our clients are seeking.

Here, we will post articles written by our Digital Forensic Examiners; highlighting original research, experiences, and other information to further the Digital Forensic Incident Response Community.