2025-07-03

Images to Google Earth/Ovi Maps - How to view local photos on Google Earth?

Questions to be solved?

How to view local photos on Google Earth?
How to display local images as geotagged placemarks on Google Earth?
How to put geotagged pictures on Google Earth?
How to view local images from Google Earth at the place where images were taken?
Displaying geotagged photos on Google Earth?
How to convert geotagged pictures to KMZ/KML files?
How to show local images as overlays on Google Earth?
KMZ file show images as place marks?
Images embedded in kms files show up in Google Earth?
Converting Geotagged photos to KML photo overlays on Google Earth?
Have geotagging photos displayed on Maps?
Creating place marks from geotagged photos?

Solutions

If you have one of the above questions, you can use the Images to Google Earth/Ovi Maps tool to solve it at https://s.wtsolutions.cn/gpsen.html

Sanpshot

images-to-google-earth-ovi-maps

Images to Google Earth/Ovi Maps

Images to Google Earth/Ovi Maps is a tool that allows you to display local geotagged images on Google Earth as one place mark overlay at corresponding GPS locations. All images stays on your local device, and will not be uploaded to Google Earth server, therefore only you and those who have your kmz files can view them.

How it works

Users Drag one photo or serveral photos to the dotted area on the website;
This tool will analyse the EXIF data of the photo and extract the GPS information;
This tool write the GPS information to the KMZ file, within the KMZ file, all images will be instructed to be displayed as one place mark overlay at corresponding GPS locations;
Users download KMZ file, and open it with Google Earth or Ovi Maps (Kmz file and images are all in the same folder on your local device);
From Google Earth/Ovi Maps, users can view all images as one place mark overlay at corresponding GPS locations;
Users click on one of the place mark icons, a overlay window will be displayed, and the image will be displayed in the overlay window;
In the window, users can view Filename, Latitude, Longitude, Altitude, and the photo displayed;

Extracting GPS data and export to CSV file

After users drag photos to the dotted area, they can click the “Export to CSV File” button in the “Pro Users” area;
This tool will extract the GPS information from the EXIF data of the photos, and write the GPS information to the CSV file;
Users can download the CSV file, and open it with spreadsheet software such as Excel and Numbers;
In the CSV file, users can view Filename, Latitude, Longitude, Altitude;

Applicable Scenarios

Geotag Analysis: Analyze the geographical distribution patterns of a large number of photos to study popular shooting areas.
Travel Route Recording: Record travel routes and stopover points to generate detailed travel reports.
Scientific Research Data Collection: Used in scientific research activities such as ecological surveys and geological investigations to establish georeferenced databases.
Commercial Applications: Industries such as real estate and tourist attractions that need to display geographical location information can create location visualization reports.
Law Enforcement Evidence Collection: Law enforcement officers can record the geographical location evidence of photos taken at crime scenes.
Insurance Investigation: Record the geographical location information of accident scenes during insurance claims.

Technical Features

Batch Processing: Supports exporting GPS data from hundreds of photos at once.
Complete Data: Extracts all available EXIF GPS information.
Format Compatibility: The generated CSV file is compatible with mainstream data analysis software.
High - Performance Processing: Processed by local hardware.
Privacy Protection: All processing is done locally in the browser, and photo data is not uploaded to the server.

2025-07-03

Images-to-google-earth-ovi-maps

Images to Google Earth/Ovi Maps - Display Images in Google Earth and Batch Export GPS Data to CSV File

Overview

One of the advanced features of the Images to Google Earth/Ovi Maps tool is the ability to batch export GPS information from photos into a CSV file. This feature is particularly suitable for users who need to analyze the geographical location data of a large number of photos, such as Geographic Information System (GIS) professionals, photographers, travel enthusiasts, etc. By converting the EXIF data of photos into structured tables, users can easily perform data analysis, visual display, and further geospatial processing.

Applicable Scenarios

Geotag Analysis: Analyze the geographical distribution patterns of a large number of photos to study popular shooting areas.
Travel Route Recording: Record travel routes and stopover points to generate detailed travel reports.
Scientific Research Data Collection: Used in scientific research activities such as ecological surveys and geological investigations to establish georeferenced databases.
Commercial Applications: Industries such as real estate and tourist attractions that need to display geographical location information can create location visualization reports.
Law Enforcement Evidence Collection: Law enforcement officers can record the geographical location evidence of photos taken at crime scenes.
Insurance Investigation: Record the geographical location information of accident scenes during insurance claims.

Detailed Usage Steps

Preparation
- Ensure that the photos contain GPS information (most photos taken by smartphones automatically include it).
- Check the photo format: Common formats such as JPG and PNG are supported.
- Purchase a usage code for advanced features (scan the QR code with Alipay to pay 20 yuan and get 30 - day usage rights).
Operation Process
1. Visit the images to Google Earth/Ovi Maps tool https://s.wtsolutions.cn/gpsen.html.
2. Drag the photos to the specified area (multiple - selection and dragging are supported).
3. Click the “Export GPS Data to CSV File” button in the “Advanced Users” area.
4. The system will automatically generate a CSV file containing the following information:
  - File name
  - Latitude
  - Longitude
  - Altitude
5. Download the generated CSV file.
Data Processing
- The generated CSV file can be directly opened with spreadsheet software such as Excel and Numbers.
- You can use the pivot table function in Excel for statistical analysis.
- It can be imported into professional GIS software such as ArcGIS and QGIS for spatial analysis.
- It supports data docking with platforms such as Google Earth and Ovi Maps.
- It can be combined with programming languages such as Python and R for big data analysis.

Technical Features

Batch Processing: Supports exporting GPS data from thousands of photos at once.
Complete Data: Extracts all available EXIF GPS information.
Format Compatibility: The generated CSV file is compatible with mainstream data analysis software.
High - Performance Processing: Processed by local hardware.
Privacy Protection: All processing is done locally in the browser, and photo data is not uploaded to the server.

Notes

Data Completeness:
- Some old photos may not contain GPS information.
- Photos taken indoors usually do not have GPS data.
- Some cameras may require manually enabling the GPS recording function.
Usage Limitations:
- Advanced features require verification of the usage code to use.
- The free version limits the processing of 6 photos at a time.
- Some photos in special formats may need to be converted before they can be read.
Accuracy Issues:
- GPS accuracy is affected by the shooting device.
- Position drift may occur in high - rise building areas.
- Post - processing data correction can be considered.

Frequently Asked Questions

Q: Why are the GPS data of some photos missing in the exported CSV file?
A: This may be because these photos do not contain GPS information themselves. Please check whether the original photos contain GPS data.

Q: Why is the data format in the CSV file incorrect?
A: Please make sure to use the latest version of Excel or other compatible software to open the file. If the problem still exists, you can try the following solutions:

Check the system regional settings.
Try opening the file with a text editor and saving it as UTF - 8 format.
Contact technical support for help.

Q: What if the exported altitude data is inaccurate?
A: The altitude data recorded by the device may have errors. It is recommended to:

Check whether the altitude sensor of the device is calibrated.
Use the reference points collected by professional GPS devices for correction.
Combine with Digital Elevation Model (DEM) data for correction.

Q: How to handle photo data in different time zones?
A: The tool supports the time zone conversion function. You can select the following options in the export settings:

Keep the original time zone.
Convert uniformly to UTC time.
Convert to the specified time zone.

Application Cases

Wildlife Research: Researchers take photos of animal activities in the wild and study the activity ranges and behavior patterns of animals by analyzing GPS data.
Urban Planning: Planners collect photos from all corners of the city and determine the areas that need key renovation through geographical distribution analysis.
Travel Blogs: Travel bloggers record the locations of all photos taken during their trips and generate interactive travel maps to share with readers.
Real Estate Marketing: Real estate agents organize photos of properties and create property maps with accurate location information.
Agricultural Monitoring: Farmers regularly take photos of farmland and analyze the growth status of crops through location data.

2025-06-23

json-to-excel

JSON to Excel v3.0.0 from Excel addin to Web application

1. Introduction

JSON to Excel 3.0.0 is a major update that expands the original Excel add-in into a full-fledged web application. You can now use it directly in your browser without installing any plugins. All conversions are performed in the browser. After previewing, you can click the download button to export the file in xlsx format. Of course, we still recommend using it as an Excel add-in for better integration with other Excel features.

2. Key Features

2.1 Basic Features

Convert JSON data to Excel format
Supports both flat and nested JSON structures
Automatic data type recognition

2.2 Professional Features

Supports batch processing of multiple JSON files
Custom nested delimiters: supports dot (.), underscore (_), double underscore (__), and slash (/)
Maximum nesting depth: Set the maximum flattening depth for JSON objects, ranging from 1 to 20, or choose unlimited depth

3. How to Use

3.1 Web Version

Open your browser and visit https://s.wtsolutions.cn/json-to-excel.html
Paste JSON data or upload a JSON file
Click the “Convert” button
Download the Excel file if needed

3.2 Excel Add-in Version

Open a new worksheet in Excel 2013/2016, Excel Online, or Office 365.
Home tab or Insert tab > Add-ins
In the search box, type “JSON to Excel”
Follow the on-screen instructions to install the add-in. You’ll see a button named JSON-to-Excel in the Home tab.
Home tab > JSON to Excel > Convert
You’re now ready to use the add-in.

4. Video Examples

Video Recorded Based on Older Version

Video Demonstrating Batch Processing of Multiple JSON Files to Excel

2025-06-18

excel-to-json

Excel to JSON online converter flat and nested JSON converter

Recently, while working with data, I encountered a challenge: converting data from an Excel spreadsheet into JSON format. During my search for a solution, I discovered the product Excel-to-JSON by WTSolutions, which turned out to be the lifesaver I had been desperately looking for! Today, I’d like to share my experience using this product.

Purpose of the Product

In modern data processing and development, JSON (JavaScript Object Notation) has become a highly popular data interchange format. It is concise, readable, and easy to transmit and parse across different programming languages and systems. On the other hand, Excel is the most commonly used spreadsheet software in our daily work, facilitating data entry, organization, and analysis.

The primary purpose of Excel-to-JSON is to quickly and accurately convert data from Excel spreadsheets into JSON format. This is incredibly useful for developers, as they can easily use the converted JSON data in scenarios like web development, API integration, and data analysis. For data analysts, converting Excel data to JSON also simplifies data processing and visualization.

System Requirements and How to Obtain

System Requirements

Excel-to-JSON boasts excellent compatibility, supporting Excel 2013 (or later), Excel Online, Office 365, and Mac versions of Excel. If you’re using it in a web browser, all you need is a JavaScript-enabled browser like Google Chrome, Mozilla Firefox, Safari, or Microsoft Edge.

How to Obtain

Getting this add-in is straightforward. In Excel 2013/2016 or later, Excel Online, or Office 365, open a new worksheet, select the Insert tab or Home tab > Add-ins, and search for “Excel-to-JSON” in the add-in search box. Click the add-in to launch it. Afterward, you’ll see the Excel-to-JSON button in the Home tab, and you can start using the plugin.

Usage Instructions

Sideloading Excel-to-JSON

There are two ways to load this add-in:

Loading in a Web Browser: Open a JavaScript-enabled web browser and navigate to the URL: https://s.wtsolutions.cn/excel-to-json.html.
Sideloading in Excel (Recommended): In Excel 2013/2016, Excel Online, or Office 365, open a new datasheet, select the Home tab or Insert tab > Add-ins, and type “Excel to JSON” in the search box. Follow the on-screen instructions to install the add-in. Once installed, you’ll see an Excel to JSON button in the Home tab. Click Home > Excel to JSON > Convert to start using it.

Preparing the Excel Spreadsheet

Prepare your Excel spreadsheet, ensuring you select at least two rows of data, with the first row treated as the header. There are two ways to load Excel data:

Loading in a Web Browser: Copy and paste Excel data into the text area. You can copy and paste data from Excel, Google Sheets, or any other Excel-compatible software, with data separated by tabs. Alternatively, you can paste comma-separated CSV data.
Sideloading in Excel: Directly select your data from the Excel worksheet.

Performing the Conversion

Select the data to convert and choose a mode: Flat or Nested JSON mode. If you’ve subscribed to Pro Features, you can also configure additional options. Finally, click the Start button, and shortly after, you’ll see the converted JSON below the button.

Saving the JSON

Once the conversion is complete, there are several ways to save the generated JSON to your local computer:

Copy and Paste: After JSON generation, you’ll see the output in the text area. You can simply copy and paste it anywhere you need.
Copy to Clipboard: After JSON generation, locate the Copy to Clipboard button. Click it, and the JSON will be copied to your clipboard.
Save to File: (Not available for Excel for Mac users) After JSON generation, find the Save As button. Click it, and you’ll be prompted to save the JSON to a file.

Key Features

Conversion Modes

Flat JSON Mode: Converts Excel data into a flat JSON format. For example, consider the following Excel table:

Name	Age	Company
David	27	WTSolutions
Ton	26	WTSolutions
Kitty	30	Microsoft
Linda	30	Microsoft
Joe	40	Github

Using Flat JSON Mode, the converted JSON would look like this:

[
    {
        "Name": "David",
        "Age": 27,
        "Company": "WTSolutions"
    },
    {
        "Name": "Ton",
        "Age": 26,
        "Company": "WTSolutions"
    },
    {
        "Name": "Kitty",
        "Age": 30,
        "Company": "Microsoft"
    },
    {
        "Name": "Linda",
        "Age": 30,
        "Company": "Microsoft"
    },
    {
        "Name": "Joe",
        "Age": 40,
        "Company": "Github"
    }
]

Nested JSON Mode: First converts the Excel data into Flat JSON, then uses the “Flat” package to unflatten keys with separators. By default, Excel-to-JSON calls the unflatten() function with the separator set to . and the overwrite parameter as true. If you’ve subscribed to Pro Features, you can customize the separator. For example, consider the following Excel table:

ID	Student.Name	Student.Surname	Student.Age
1	Meimei	Han	12
2	Lily	Jaskson	15
3	Elon	Mask	18

Using Flat JSON Mode, the converted JSON would look like this:

[{
    "ID": 1,
    "Student.Name": "Meimei",
    "Student.Surname": "Han",
    "Student.Age": 12
}, {
    "ID": 2,
    "Student.Name": "Lily",
    "Student.Surname": "Jaskson",
    "Student.Age": 15
}, {
    "ID": 3,
    "Student.Name": "Elon",
    "Student.Surname": "Mask",
    "Student.Age": 18
}]

Using Nested JSON mode:

[
  {
    "ID": 1,
    "Student": {
      "Name": "Meimei",
      "Surname": "Han",
      "Age": 12
    }
  },
  {
    "ID": 2,
    "Student": {
      "Name": "Lily",
      "Surname": "Jaskson",
      "Age": 15
    }
  },
  {
    "ID": 3,
    "Student": {
      "Name": "Elon",
      "Surname": "Mask",
      "Age": 18
    }
  }
]

Pro Features

For users subscribed to Pro Features, Excel-to-JSON offers even more powerful functionalities:

Nested Separators: Customize separators for nested JSON keys (/, _, .).
Empty Cell Handling: Three options for empty cells: empty string "", JSON null, or exclusion.
Boolean Formatting: Three boolean conversion formats: JSON true/false, string "true"/"false", or numeric 1/0.
Single Object JSON Output: When only one row of data exists, choose whether to output as a single JSON object or an array.
Date Formatting: Two options for date conversion: days since 1990-01-01 or ISO 8601 string format.
Custom Filename: Customize the filename when using the Save As feature.

Conclusion

Overall, Excel-to-JSON is an incredibly practical tool that has significantly improved my efficiency in converting Excel data to JSON format. It’s user-friendly, highly compatible, and packed with features, making it a product worth recommending to both developers and data analysts. If you frequently need to convert Excel data to JSON, give Excel-to-JSON a try—I’m sure it’ll pleasantly surprise you!

2025-06-12

excel-to-json

探索 Excel-to-JSON 高效数据转换的利器

最近，我在处理数据时遇到了一个难题：需要将 Excel 表格中的数据转换为 JSON 格式。在寻找解决方案的过程中，我发现了 Excel-to-JSON by WTSolutions 这款产品，它简直就是我苦苦寻觅的救星！今天，我就来和大家分享一下我使用这款产品的体验。

产品用途

在现代数据处理和开发中，JSON（JavaScript Object Notation）已经成为了一种非常流行的数据交换格式。它简洁、易读，并且易于在不同的编程语言和系统之间进行传输和解析。而 Excel 则是我们日常工作中最常用的电子表格软件，它方便我们进行数据的录入、整理和分析。

Excel-to-JSON 这款产品的主要用途就是将 Excel 表格中的数据快速、准确地转换为 JSON 格式。这对于开发者来说非常有用，因为他们可以将 Excel 中的数据转换为 JSON 后，方便地在 Web 开发、数据接口对接、数据分析等场景中使用。同时，对于数据分析师来说，将 Excel 数据转换为 JSON 也可以更方便地进行数据的处理和可视化。

系统要求与获取方式

系统要求

Excel-to-JSON 具有很好的兼容性，它支持 Excel 2013（或更高版本）、Excel Online、Office 365 和 Mac 版 Excel。如果你是在 Web 浏览器中使用，那么只需要使用支持 JavaScript 的浏览器，如 Google Chrome、Mozilla Firefox、Safari 或 Microsoft Edge 即可。

获取方式

获取这款插件非常简单。在 Excel 2013/2016 或更高版本、Excel Online 或 Office 365 中打开新工作表，选择“插入”选项卡或“开始”选项卡>加载项，在加载项搜索框中搜索“Excel-to-JSON”，点击加载项启动它。之后，你将在 Excel 的“开始”选项卡中看到“Excel-to-JSON”按钮，就可以开始使用此插件了。

使用方法

旁加载 Excel 转 JSON

有两种方式可以加载这个插件：

在 Web 浏览器中加载：打开支持 JavaScript 的 Web 浏览器，在浏览器中打开 URL：https://s.wtsolutions.cn/excel-to-json.html。
在 Excel 中旁加载（推荐）：在 Excel 2013/2016、Excel Online 或 Office 365 中打开一个新的数据表，选择“主页”选项卡或“插入”选项卡>加载项，在搜索框中输入“Excel to JSON”，按照屏幕上的说明安装加载项，安装完成后，你将在“主页”选项卡上看到一个“JSON 转 Excel”按钮，点击“主页”选项卡> Excel 转 JSON>转换，就可以开始使用了。

准备 Excel 表格

准备好你的 Excel 表格，需要注意的是，你需要选择至少两行数据，第一行将被视为表头。加载 Excel 数据有两种方式：

在 Web 浏览器中加载：将 Excel 数据复制并粘贴到文本区域，你可以复制并粘贴来自 Excel、Google Sheets 或任何其他 Excel 兼容软件的数据，数据之间用 Tab 分隔，也可以复制并粘贴逗号分隔的 CSV 数据。
在 Excel 中旁加载：直接从 Excel 工作表中选择你的数据。

进行转换

选择要转换的数据，然后选择模式：Flat 或 Nested JSON 模式。如果您已订阅“专业功能”，还可以设置更多选项。最后点击“开始”按钮，稍后你将在“开始”按钮下方看到转换后的 JSON。

保存 JSON

转换完成后，有几种方法可以将生成的 JSON 保存到本地计算机：

复制和粘贴：JSON 生成后，你将在文本区域中看到它们，你可以简单地将它们复制并粘贴到任何你想要的地方。
复制到剪贴板：JSON 生成后，你可以找到“复制到剪贴板”按钮，点击该按钮，JSON 将被复制到你的剪贴板。
保存到文件：（Excel for Mac 用户不可用）JSON 生成后，你可以找到“另存为”按钮，点击该按钮，系统将提示你将 JSON 保存到文件。

主要功能

转换模式

Flat JSON 模式：简单地将 Excel 数据表转换为扁平的 JSON 格式。例如，有如下 Excel 表格：

姓名	年龄	公司
David	27	WTSolutions
Ton	26	WTSolutions
Kitty	30	Microsoft
Linda	30	Microsoft
Joe	40	Github

使用 Flat JSON 模式转换后的 JSON 如下：

[
    {
        "姓名": "David",
        "年龄": 27,
        "公司": "WTSolutions"
    },
    {
        "姓名": "Ton",
        "年龄": 26,
        "公司": "WTSolutions"
    },
    {
        "姓名": "Kitty",
        "年龄": 30,
        "公司": "Microsoft"
    },
    {
        "姓名": "Linda",
        "年龄": 30,
        "公司": "Microsoft"
    },
    {
        "姓名": "Joe",
        "年龄": 40,
        "公司": "Github"
    }
]

Nested JSON 模式：首先将 Excel 数据表转换为 Flat JSON，然后使用“Flat”包对带有分隔符的键进行解平铺操作。Excel-to-JSON 调用 unflatten() 函数时，分隔符默认为“.”，overwrite 参数为 true。如果您订阅了“专业功能”，可以设置其他分隔符。例如，有如下 Excel 表格：

ID	学生.姓名	学生.姓氏	学生.年龄
1	Meimei	Han	12
2	Lily	Jaskson	15
3	Elon	Mask	18

使用 Flat JSON 模式转换后的 JSON 如下：

[{
    "ID": 1,
    "学生.姓名": "Meimei",
    "学生.姓氏": "Han",
    "学生.年龄": 12
}, {
    "ID": 2,
    "学生.姓名": "Lily",
    "学生.姓氏": "Jaskson",
    "学生.年龄": 15
}, {
    "ID": 3,
    "学生.姓名": "Elon",
    "学生.姓氏": "Mask",
    "学生.年龄": 18
}]

使用 Nested JSON mode:

[
  {
    "ID": 1,
    "Student": {
      "Name": "Meimei",
      "Surname": "Han",
      "Age": 12
    }
  },
  {
    "ID": 2,
    "Student": {
      "Name": "Lily",
      "Surname": "Jaskson",
      "Age": 15
    }
  },
  {
    "ID": 3,
    "Student": {
      "Name": "Elon",
      "Surname": "Mask",
      "Age": 18
    }
  }
]

专业功能

对于订阅了专业功能的用户，Excel-to-JSON 还提供了更多强大的功能：

嵌套分隔符：支持自定义嵌套 JSON 键的分隔符（/，_，.）。
空单元格处理：空单元格有三种处理方式：空字符串””、JSON null 或直接排除。
布尔值格式：有三种布尔值转换格式：JSON true/false、字符串”true”/“false”或数字 1/0。
单对象 json 输出格式：当只有一行数据时，可以选择是否输出为单对象 JSON 格式，或者输出为数组格式。
日期格式：日期转换有两种选项：自 1990 - 01 - 01 以来的天数或 ISO 8601 字符串格式。
另存为文件名：在使用“Save As”功能时，可以自定义文件名。

总结

总的来说，Excel-to-JSON 是一款非常实用的工具，它大大提高了我将 Excel 数据转换为 JSON 格式的效率。它的操作简单易懂，兼容性好，并且提供了丰富的功能，无论是对于开发者还是数据分析师来说，都是一款值得推荐的产品。如果你也经常需要进行 Excel 数据到 JSON 格式的转换，不妨试试 Excel-to-JSON，相信它会给你带来惊喜！