Practical Guides

Learn practical Data, GIS and IT tasks step by step

Clear, practical guides designed to help you understand common technical tasks without unnecessary complexity.

Explore tutorials covering GIS, mapping, spreadsheets, file formats, networking and the tools available on MK Tech Tools.

Browse by topic

Guide categories

Data & Spreadsheets

Guides for CSV, Excel, data cleaning, conversion and everyday data tasks.

GIS & Mapping

Practical guides for maps, shapefiles, GeoJSON, coordinates and spatial data.

Networking & IT

Understand IP addresses, DNS, CIDR, ports and common networking concepts.

File Formats

Learn how common technical file formats work and when to use them.

Featured guides

Start with these practical topics

These guides focus on common questions and tasks people regularly encounter when working with data, GIS and IT.

New guides are being added over time.
GIS & MappingGuide coming soon

How to Create a Choropleth Map from Your Data

Learn how to prepare your data and create a choropleth map to visualize values by district, province, state or other geographic areas.

Choropleth map • GIS • Data visualization

GIS & MappingGuide coming soon

How to Convert CSV Coordinates to GeoJSON

A simple guide to converting latitude and longitude coordinates from a CSV file into GeoJSON for use in GIS and web maps.

CSV to GeoJSON • Coordinates • GIS

GIS & MappingGuide coming soon

How to Merge Polygons in a Shapefile

Learn when and why polygons are merged, and how to combine geographic areas into larger boundaries.

Merge shapefiles • Merge polygons • GIS

GIS & MappingGuide coming soon

What Is GeoJSON and How Is It Used?

Understand the GeoJSON format, its main components and why it is widely used for geographic data and interactive web maps.

What is GeoJSON • GeoJSON format • GIS

DataGuide coming soon

CSV vs Excel: What Is the Difference?

Understand the difference between CSV and Excel files, when to use each format and which is better for different types of data work.

CSV vs Excel • CSV vs XLSX • Data files

Networking & ITGuide coming soon

What Is an IP Address, Subnet and CIDR?

A beginner-friendly explanation of IP addresses, subnet masks and CIDR notation with practical examples.

IP address • Subnet • CIDR

Learn and use

Guides designed to work alongside our tools

MK Tech Tools is not only about providing utilities. The goal is also to help users understand what they are doing and why.

Many future guides will connect directly to tools on the site, so you can learn a task and then immediately try it yourself.

What you can expect

✓

Clear explanations without unnecessary jargon

✓

Step-by-step instructions for practical tasks

✓

Examples connected to real tools and workflows

✓

Beginner-friendly explanations where possible

Suggest a guide

Looking for a topic we have not covered yet?

If there is a Data, GIS, chart, visualization, networking or technical task you would like explained, send us your suggestion. It may become one of the next MK Tech Tools guides.

Data & spreadsheetsGIS & mappingCharts & visualizationIT & networking
Suggest a Guide →