DEV Community: WTSolutions

How HR Can Generate 500 Onboarding Letters in 5 Minutes with Excel

WTSolutions — Fri, 07 Aug 2026 07:08:35 +0000

The Scenario: Campus Hiring Season, 500 Onboarding Letters to Send

If you work in HR, you already know what's coming. Campus recruiting season is here, and your director just dropped an Excel spreadsheet on your desk: 500 new hires, each with their name, department, position, start date, and salary. The request? "Get their onboarding letters done. EOD today."

You open your Word template, copy a name from Excel, paste it in, save as a new file, change the next name, repeat. At a normal pace, one letter takes about 2 minutes (including proofreading). That's 1,000 minutes — roughly 17 hours. Two full days of nonstop typing, assuming no breaks, no lunch, no life.

But there's another way. It takes 5 minutes.

Step 1: Prepare a Word Template

Open a Word document and format it like your usual onboarding letter. The only difference: replace every variable piece with a placeholder wrapped in curly braces.

Dear {Name},

Congratulations on joining {Company}. We are pleased to offer you the position of {Position} in the {Department} department.

Start Date: {Start_Date}
Salary: {Salary}
Reporting To: {Manager}

Please bring your ID documents to {Office_Address} on your first day to complete the onboarding process.

Best regards,
{Company}
{Date}

This template takes about 15 minutes to set up — and then you can reuse it every year.

Step 2: Open Your Excel Data

Your Excel sheet looks like this:

Name	Department	Position	Start_Date	Salary	Manager	Office_Address
Zhang Wei	Engineering	Frontend Dev	2026-09-01	15000	Li Si	Pudong Tower A
Li Li	Marketing	Operations	2026-09-03	12000	Wang Fang	Pudong Tower B
...	...	...	...	...	...	...

Make sure the column headers match your {Placeholders} in the Word template.

Step 3: Open Sheet-to-Doc, Paste Data, Generate

Visit Sheet-to-Doc. Here's the entire workflow:

Upload your prepared Word template
Copy and paste your Excel data into the website (or upload a CSV/Excel file)
Set the filename rule to Onboarding_Letter_{Name}.docx
Click "Generate"

Within seconds, your browser downloads a ZIP archive. Unzip it, and you'll find 500 individual Word files — each named after the employee, each with the correct personal information filled in.

From opening the website to having the files ready: under 5 minutes.

Data Security: Why HR Can Trust This

HR data is among the most sensitive in any organization — salaries, ID numbers, home addresses. A single leak can mean serious compliance issues.

Sheet-to-Doc processes everything locally in your browser:

Data is never uploaded to any server
All processing happens on your own computer
Data is cleared immediately after processing

This means even your most sensitive payroll data never leaves your machine. For an extra layer of security, you can use the offline desktop version, which runs completely without internet access.

Beyond Onboarding: What Else Can HR Automate?

Onboarding letters are just the beginning. Here's a list of HR document types that Sheet-to-Doc handles with ease:

Document Type	Data Source	Template Placeholders
Termination Certificate	Departure Register	`{Name}` `{Departure_Date}` `{Position}`
Salary Confirmation	Payroll Sheet	`{Name}` `{Monthly_Salary}` `{Social_Insurance}` `{Housing_Fund}`
Training Notice	Training Roster	`{Name}` `{Training_Date}` `{Training_Location}` `{Course}`
Transfer Notification	Transfer Approval	`{Name}` `{Old_Position}` `{New_Position}` `{Effective_Date}`
Bonus Letter	Bonus Calculation	`{Name}` `{Bonus_Amount}` `{Payment_Date}` `{Tax}`
Contract Attachment	Contract Data	`{Name}` `{Contract_Term}` `{Salary}` `{Job_Description}`

One template framework, reused all year round. Swap in a new Excel file each time — a batch of documents in minutes.

Is the Free Version Enough?

The free version of Sheet-to-Doc supports up to 10 rows per batch. If you process small batches monthly — say a few dozen people — the free version will likely cover you.

But if you're generating 500 onboarding letters for campus recruiting, or hundreds of salary confirmations every pay cycle, the Pro version is the way to go. No row limits, plus access to encryption, loop placeholders, and other advanced features.

Final Thoughts

HR work shouldn't be defined by endless copy-pasting. When you first cut 500 onboarding letters from 17 hours down to 5 minutes, you'll realize — all that time you've been wasting could be spent on the things that actually matter.

Start now: https://s.wtsolutions.cn/sheet-to-doc

Building a Complete Data Pipeline: Excel to JSON to Word Contracts, 1000 Documents in 10 Minutes

WTSolutions — Fri, 07 Aug 2026 07:07:46 +0000

The Problem: How Do You Move One Excel Sheet Through Three Systems?

Many companies run their business like this:

The sales team records client details and contract terms in Excel
The backend system needs JSON data to integrate with the CRM
The legal team needs to generate formal Word contracts from those same terms

The traditional approach: manually export three times, adjust formats individually. It's slow, error-prone, and nobody enjoys it.

Let's show you how to build a complete automated pipeline using three WTSolutions tools — turning one Excel sheet into data flowing through three systems seamlessly.

The Tool Stack

Step	Tool	What It Does	Platforms
Step 1	Excel-to-JSON	Excel spreadsheet → structured JSON	Web / Excel Add-in / WPS Add-in / Local App
Step 2	Data Transfer	Push JSON to backend API	Any HTTP client
Step 3	JSON-to-Excel	API response → Excel for review	Web / Excel Add-in / WPS Add-in / Local App
Step 4	Sheet-to-Doc	Excel data → batch Word contracts	Web / Excel Add-in / WPS Add-in / Local App

Step 1: Excel-to-JSON — Turn Your Spreadsheet into API-Ready Data

Imagine your sales team maintains a sheet like this:

Client	Product	Quantity	Unit_Price	Total	Contract_ID
Shanghai ABC Corp	Cloud Service A	50	2000	100000	CT-2026-001
Beijing XYZ Group	Cloud Service B	30	3500	105000	CT-2026-002
...	...	...	...	...	...

Open this in Excel-to-JSON, select "Flat Mode," and click Convert. In seconds, you get:

[
  {
    "Client": "Shanghai ABC Corp",
    "Product": "Cloud Service A",
    "Quantity": 50,
    "Unit_Price": 2000,
    "Total": 100000,
    "Contract_ID": "CT-2026-001"
  },
  {
    "Client": "Beijing XYZ Group",
    "Product": "Cloud Service B",
    "Quantity": 30,
    "Unit_Price": 3500,
    "Total": 105000,
    "Contract_ID": "CT-2026-002"
  }
]

Push this JSON to your CRM or backend API via an HTTP POST request. If your system expects nested structures, switch to "Nested Mode" and set the delimiter to . — the tool generates multi-level JSON automatically.

Available platforms: Web app, Excel Add-in (Office 2013+/Office 365), WPS Add-in, REST API, MCP service, and local desktop application. No matter your environment, there's an entry point for you.

Step 2: JSON-to-Excel — Bring API Data Back into a Spreadsheet

After your backend processes the data, you might need to bring results back into Excel for business colleagues to review or hand off to the next step.

JSON-to-Excel supports three input methods:

Paste — Paste JSON text directly
Upload — Upload .json or .jsonl files
URL Load — Enter an API endpoint URL and let the tool fetch data automatically

Customization options include:

Max nesting depth: 1-20 levels or unlimited; deeper levels auto-convert to strings
Empty value handling: Empty string, null, or exclude
Boolean format: true/false, "true"/"false", or 1/0

The output Excel file can be handed to a colleague or fed directly into Sheet-to-Doc.

Step 3: Sheet-to-Doc — Batch-Generate Word Contracts from Excel

Now your Excel data needs to become formal contracts. This is exactly what Sheet-to-Doc excels at.

Prepare a Word contract template with {Client} {Product} {Total} as placeholders
Open Sheet-to-Doc and upload your template
Paste your Excel data or upload the file
Set filename rule: Contract_{Client}_{Contract_ID}.docx
Click "Generate"

Within seconds, you get a ZIP file with Word contracts named by client. 1000 contracts? Same timeline — just a few minutes.

Pro Tip: Loop Placeholders for Multi-Product Contracts

If a single contract has multiple product line items, Sheet-to-Doc's Loop Placeholders handle it elegantly:

Contract: {Contract_ID}
Client: {Client}

Line Items:
{#products}
  - {Product_Name} × {Quantity} = {Subtotal}
{/products}

Total: {Total}

Combined with nested-mode JSON from Excel-to-JSON, a single data row generates a contract with multiple itemized rows.

The Full Pipeline: Before vs. After

Task	Manual Process	Tool Pipeline
Excel → JSON	Manually format JSON	One-click, seconds
JSON → API	Copy-paste into API docs	HTTP POST, automated
API → Excel	Manually reorganize results	JSON-to-Excel, instant
Excel → Word	Copy-paste row by row	Batch generate, thousands in minutes
Total (1000 records)	~8 hours	~10 minutes

Data Security Throughout the Pipeline

All three tools support local processing — data never leaves your device:

Excel-to-JSON: Local desktop version runs fully offline
JSON-to-Excel: Web version processes in-browser; local version works without internet
Sheet-to-Doc: Browser-side processing; desktop version adds offline + document encryption

For sensitive data like contract amounts and client details, the local desktop versions are the safest choice.

Final Thoughts

Excel, JSON, and Word — three data formats that most businesses handle every single day. Instead of having colleagues manually shuffle between them, string them into an automated pipeline.

Excel-to-JSON gets data flowing. JSON-to-Excel brings it back organized. Sheet-to-Doc turns it into formal documents. Three tools, one pipeline, 1000 contracts, 10 minutes.

Start now:

From 22 Hours of Overtime to Leaving Work on Time Every Day

WTSolutions — Fri, 07 Aug 2026 07:07:16 +0000

2025 Me: The Person Who Worked 8 Extra Hours Every Week

Let me tell you what my work life used to look like.

I'm an admin manager at a mid-size manufacturing company, responsible for contract management, certificate issuance, and internal document workflows. Sounds office-y, right? In reality, it was almost entirely manual labor.

Every Friday afternoon, I'd receive the same batch of tasks:

30 supplier contracts: Fill in supplier names, amounts, and terms from the procurement team's Excel sheet into our Word template
50 internal transfer letters: HR gives me a roster, and I generate each transfer notice one by one
100 training attendance confirmations: After each training session, fill the attendance data into confirmation letters for each department

The method: copy, paste, change value, save. Repeat for every single row.

I did the math:

Task	Volume	Per-Item Time	Total
Supplier Contracts	30	15 min	7.5 hours
Transfer Letters	50	8 min	6.7 hours
Training Confirmations	100	5 min	8.3 hours
Total	180 docs	—	22.5 hours

Every Friday, I'd work until 10 PM or later. After three months of this, I started questioning whether admin work was just supposed to be endless copy-pasting.

2026 Me: Leaving the Office at 6 PM Sharp

The change happened when I discovered Sheet-to-Doc.

My first time using it, I expected another piece of complicated software. Instead, the actual experience was:

Open the website
Upload my Word contract template (just replace variable fields with {placeholders})
Paste the Excel data
Click "Generate"

30 supplier contracts? 3 minutes. 50 transfer letters? 2 minutes. 100 training confirmations? 4 minutes.

That Friday, I finished everything by 5:30 PM and left at 6:00 PM sharp.

The comparison:

Metric	Before (2025)	After (2026)
Weekly doc generation time	22.5 hours	9 minutes
Overtime frequency	5 days/week	Almost never
Error rate	~5-8 per month	Zero
Friday departure time	10:00 PM	6:00 PM

But the Real Change Went Beyond Saving Time

Saving time was just the surface-level win. What truly made me think "this was worth it" were these things.

1. No More Getting Yelled At for Typos

When you copy-paste manually, mistakes happen. Wrong row, wrong column, wrong value. Contract amounts mistyped, names misspelled, positions swapped — these errors weren't frequent, but the consequences were serious.

Once I typed "12 billion" instead of "120,000" on a contract. Finance caught it during review, but my director still called me in for a serious talk. With the tool, data comes straight from Excel — there's no "reading the wrong row" problem.

2. File Naming Finally Makes Sense

Before, every generated file was named "New Document 1.docx," "New Document 2.docx"... Organizing them was a nightmare. Now I set a naming formula: Contract_{Supplier}_{Contract_ID}.docx. Files come out perfectly organized — no more half-hour renaming sessions.

3. My Data Never Leaves My Computer

The contracts I handle contain sensitive company information. At first, I was worried about "will an online tool leak my data?" Once I learned that Sheet-to-Doc processes everything locally in my browser — data never uploads to any server — I felt at ease. And for even higher security, there's a fully offline desktop version.

The Moments That Used to Be "Not Worth the Overtime"

Before writing this, I tracked my week:

Monday: 30 supplier contracts in 9 minutes → used the rest of the time to optimize our contract approval workflow
Tuesday: 50 transfer letters in 2 minutes → spent the extra time learning the new HR system
Wednesday: 80 training confirmations in 4 minutes → organized a year's worth of contract archives
Thursday: 120 salary confirmations in 6 minutes → trained a new team member on the tool
Friday: Weekly report + next week's plan → left at 6:00 PM

Those 22 hours I used to spend on Friday nights? I'm now doing things I "never had time to think about":

Optimizing department workflows
Learning new systems
Training my team
Even having dinner with my family on time

If You're Considering Switching

My advice is simple: try it and see.

Sheet-to-Doc's free version supports up to 10 rows of data — enough to verify whether it fits your workflow. If it works, upgrading to Pro costs just a few dollars. Compared to the 22 hours you gain every week, it's a no-brainer.

Stop spending your best hours on the most mechanical work.

Try it now: https://s.wtsolutions.cn/sheet-to-doc

PDF-to-Image-PDF - open-source PDF tool - convert to image PDF

WTSolutions — Wed, 05 Aug 2026 11:59:03 +0000

What is PDF-to-Image-PDF?

PDF-to-Image-PDF is a free and open-source cross-platform desktop application specifically designed for converting PDF files to images or image-based PDF files, with support for adding watermarks. This tool uses local processing, requiring no internet connection and no data upload to servers, ensuring the security and privacy of user data. As an open-source project, users are free to use, modify, and distribute the code.

Core Features

PDF-to-Image-PDF offers the following core features:

PDF to Images：Convert PDF files to one image per page
PDF to Image-based PDF：Convert PDF to image-based PDF files
Text Watermark Support：Add text watermarks to converted files
Adjustable DPI Settings：Control image quality and file size by adjusting DPI
Real-time Conversion Progress Display：Intuitively show the conversion process
Automatic Saving：Automatically save to the same directory as the original file
File Safety：Only generate new files, do not overwrite existing files

How It Works

The workflow of PDF-to-Image-PDF is as follows:

User selects PDF files
Set output parameters and watermark options
Render PDF pages to images
Synthesize images into a new PDF file
Add watermarks to new PDF file (if any)
Save to the same directory as the original file
User preview the generated PDF

Open Source Features

PDF-to-Image-PDF adopts a free and open-source model, with all features completely free for users. As an open-source project, users can:

Free to Use: Use all features without any payment
Free to Modify: View and modify the source code to customize functionality
Free to Distribute: Distribute software copies freely without restrictions
Community Collaboration: Contribute to the project and help it grow
Code Auditing: Review the code to ensure security and privacy

Download Links

Users can choose the appropriate version according to their operating system:

Official Download Page
Windows Version
macOS Version
Linux Version

Get Source Code

As an open-source project, users can access the source code:

Visit the official website to get the latest version: https://s.wtsolutions.cn/pdf-to-image-pdf.html

Security Advantages

A major highlight of PDF-to-Image-PDF is its local processing approach and open-source nature:

No Internet Connection Required: All processing is done locally, not dependent on the network
No Data Upload: Will not upload users' PDF files to any server
Data Privacy: Ensure that users' sensitive information is not leaked
File Safety: Only generate new files, do not overwrite existing files
Code Auditable: As an open-source project, the source code is transparent and publicly available for review, ensuring no security vulnerabilities or backdoors
Community Oversight: Global developers review the code together, quickly identifying and fixing security issues

Application Scenarios

PDF-to-Image-PDF is suitable for the following scenarios:

Document Protection：Prevent documents from being edited by converting to image-based PDF
Watermark Addition：Add copyright watermarks to important documents
Cross-platform Compatibility：Ensure consistent display of PDF on different devices
File Size Optimization：Balance file size and quality by adjusting DPI

How to Get

If you are interested in PDF-to-Image-PDF, you can get it through the following ways:

Visit the official website: https://s.wtsolutions.cn/pdf-to-image-pdf.html
Download now with all features free: Download Now
Access the source code for customization and contribution

Summary

PDF-to-Image-PDF is a powerful, secure and reliable free and open-source PDF conversion tool that provides users with simple and efficient PDF processing solutions. Both individual users and enterprise users can benefit from it. As an open-source project, it not only provides high-quality PDF conversion features but also grants users the right to audit code, customize features, and participate in community building.

How to Convert JSON to Table in WPS Office - JSON-to-Excel WPS Add-in Complete Guide

WTSolutions — Wed, 05 Aug 2026 11:57:58 +0000

In daily data processing work, JSON has become the universal standard for data exchange. However, when we need to analyze, filter, edit, or share JSON data, converting it to a tabular format like Excel or CSV is often the most practical approach. WPS Office, one of the most popular office suites worldwide, offers a great environment for working with tabular data. Many users want to directly convert JSON to tables within WPS.

This comprehensive guide will walk you through using the WTSolutions JSON-to-Excel WPS Add-in to effortlessly convert JSON to tables in WPS Office — including JSON to Excel, JSON to CSV, and how to open and process JSON files.

Why Convert JSON to Tables?

JSON format is widely used for its simple structure and excellent readability in Web APIs, mobile applications, and data storage. But in practice, we often need to convert JSON data to tabular formats to:

Analyze and visualize data: Use WPS spreadsheet features for sorting, filtering, and charting
Generate financial reports: Transform JSON financial data into standard Excel reports
Migrate and share data: Deliver JSON data in tabular format to non-technical stakeholders
Process batches: Handle multiple JSON files at once for improved efficiency
Export to CSV: Convert JSON to CSV format for compatibility with more applications

JSON-to-Excel Toolkit Overview

WTSolutions JSON-to-Excel is a powerful toolkit for converting JSON to Excel, supporting both flat and nested JSON structures. It provides a full-scenario solution:

Method	Best For
Web App	Casual use, cross-platform operations
Excel Add-in	Users primarily using Microsoft Excel
WPS Add-in	Users primarily using WPS Office
API Service	Developer automation and integration
MCP Service	AI model integration
Local App	Offline environment usage

WPS Add-in Features

The WPS add-in is specially designed for WPS Office users, providing seamless integration:

✅ Supports Windows and Linux WPS platforms
✅ Convert JSON data directly within WPS spreadsheets
✅ Supports both flat and nested JSON structures
✅ Flexible conversion modes (Flat / Nested)
✅ Multiple delimiter options (Dot, Underscore, Double Underscore, Forward Slash)
✅ Customizable max nesting depth (1-20 levels)
✅ Batch processing of multiple JSON files
✅ Load remote JSON files via URL

Step 1: Get the WPS Add-in

System Requirements

WPS for Windows: Latest version
WPS for Linux: Latest version

Installation Steps

Getting the WPS add-in requires a side-load operation:

Visit the official release page: https://json-to-wps-workbook.wtsolutions.cn/publish.html
Follow the detailed steps on the page to complete installation
After installation, you'll see the JSON-to-Excel button in WPS

Video Tutorial

Watch the video below for a quick overview of the add-in installation process:

Video guide available in Simplified Chinese on the official page

Step 2: How to Open and Convert JSON Files in WPS

After installing the add-in, you can convert JSON data to WPS tables through three methods:

Method 1: Copy & Paste JSON Data

This is the simplest and fastest approach, ideal for single medium-sized JSON datasets:

Prepare JSON data: Ensure your JSON data follows the correct format (array or object structure)
Open WPS Spreadsheet: Create a new blank WPS spreadsheet document
Launch Add-in: Click the JSON-to-Excel button in WPS
Paste Data: Copy and paste your JSON data into the add-in's text area
Configure Conversion Settings (optional):
- Select conversion mode: Flat or Nested
- Set delimiter (nested mode): Dot ., Underscore _, Double Underscore __, or Forward Slash /
- Set max nesting depth (1-20, default: unlimited)
Click "Go" Button: Wait for conversion to complete
View Results: After conversion, you'll see a new sheet in WPS containing the converted data

Method 2: Load Local JSON Files

Ideal for larger JSON files or batch conversion:

Prepare JSON Files: Save your JSON data as .json files
Open Add-in: Launch the JSON-to-Excel add-in in WPS
Select Files: Click the "Load JSON File(s)" button and select one or more JSON files from your computer
Batch Processing: Load up to 20 JSON files at once for batch conversion
Click "Go" Button: All selected files will be converted sequentially
View Report: After conversion, a report is generated including:
- Filename
- Conversion result (success/failure)
- Corresponding sheet name
- Error message (if any)

Method 3: Load JSON Files from URL

Ideal for JSON data stored on remote servers:

Prepare JSON URL: Ensure the JSON file is accessible via a public URL
Open Add-in: Launch the JSON-to-Excel add-in in WPS
Enter URL: Fill in the URL of the JSON file in the URL input field
Batch Processing: Load up to 20 URLs at once
Click "Go" Button: The add-in will automatically download and convert the data

Conversion Modes Explained

Flat Mode

Suitable for simple JSON objects where all properties map directly to columns:

Input JSON:

[
  {"name": "John", "age": 25, "occupation": "Engineer"},
  {"name": "Alice", "age": 30, "occupation": "Designer"},
  {"name": "Bob", "age": 28, "occupation": "Product Manager"}
]

Output Table:

name	age	occupation
John	25	Engineer
Alice	30	Designer
Bob	28	Product Manager

Nested Mode

Suitable for JSON with nested structures, automatically expanding nested properties into multi-level columns:

Input JSON:

[
  {
    "id": 1,
    "student": {
      "name": "Mike",
      "familyname": "Smith",
      "age": 12
    }
  },
  {
    "id": 2,
    "student": {
      "name": "Emma",
      "familyname": "Johnson",
      "age": 15
    }
  }
]

Output with Different Delimiters:

Dot (.) Delimiter:

id	student.name	student.familyname	student.age
1	Mike	Smith	12
2	Emma	Johnson	15

Underscore (_) Delimiter:

id	student_name	student_familyname	student_age
1	Mike	Smith	12
2	Emma	Johnson	15

Max Nesting Depth Setting

When JSON contains multiple levels of nesting, you can set the max nesting depth to control conversion behavior. Nested objects exceeding the max depth will be converted to strings.

How to Convert JSON to CSV

The JSON-to-Excel WPS add-in's core functionality converts JSON to WPS spreadsheets (.xlsx format). If you need CSV format, you can achieve it through these methods:

Method 1: Save As CSV in WPS

Convert JSON to WPS spreadsheet using the add-in
In WPS, click File → Save As
Select CSV File (*.csv) as the save type
Click Save

Method 2: Use the Web App

If you don't need to edit data in WPS, use the JSON-to-Excel Web App:

Open the web app
Paste JSON data or upload JSON files
Select conversion settings
Click "Go" button
After conversion, click "Download" to get the Excel file
Open the downloaded Excel file in WPS and save as CSV

Supported Data Types

JSON-to-Excel supports the following JSON data type conversions:

JSON Type	Example	WPS Table Output
String	`"text"`	Display text directly
Number	`123`, `45.67`	Numeric value
Boolean	`true`, `false`	Text "true"/"false"
Null	`null`	Blank cell
Array	`[1, 2, 3]`	Converted to string "[1,2,3]"
Object	`{"x": 1}`	Flat mode → string; Nested mode → expanded

Real-World Use Cases

Scenario 1: API Data Export

JSON data from Web APIs typically needs conversion to tables for analysis:

{
  "status": "success",
  "data": [
    {"product": "Laptop", "price": 999, "stock": 150},
    {"product": "Wireless Mouse", "price": 15, "stock": 2000},
    {"product": "Mechanical Keyboard", "price": 89, "stock": 500}
  ]
}

Simply extract the data array and paste it into the add-in to quickly generate a product inventory table.

Scenario 2: Log Data Processing

Server logs are typically stored in JSON format. The add-in can quickly convert them to tables for troubleshooting and analysis.

Scenario 3: Batch Data Consolidation

When you need to process multiple JSON files and merge them into a single Excel workbook, the batch processing feature greatly improves efficiency.

Free vs. Pro Version

Feature	Free	Pro
Max rows per conversion	6 rows	Unlimited
All advanced features	✅	✅
Batch processing (local files)	✅	✅
Batch processing (URL)	✅	✅
Multiple delimiters	✅	✅
Custom max nesting depth	✅	✅
Ads displayed	Yes	No ads

💡 Pro subscription applies to both JSON-to-Excel and Excel-to-JSON tools!

Frequently Asked Questions

Q1: What format should my JSON data be in?

JSON data can be in either of these formats:

Array of objects: [{"key": "value"}, {"key": "value"}]
Single object: {"key1": "value1", "key2": "value2"}

Each object supports up to 100 properties, and arrays support up to 1000 objects.

Q2: Can I edit the converted table data?

Absolutely! The converted data is regular WPS spreadsheet data, so you can perform any editing operation including formatting, adding formulas, creating charts, etc.

Q3: What size JSON files are supported?

Each conversion supports up to 1000 rows and 100 columns. For larger datasets, consider using the API or MCP service for batch processing.

Q4: Is my data safe?

When using the WPS add-in, your data is processed directly within WPS without being uploaded to servers. For offline users, the Local App version is also available.

Q5: How do I batch convert multiple JSON files?

Click the "Load JSON File(s)" button in the add-in to select up to 20 JSON files for batch conversion. Each file will be converted to a separate sheet.

Summary

The JSON-to-Excel WPS add-in provides WPS Office users with a complete solution for converting JSON to tables. Whether you need JSON to Excel or JSON to CSV, whether your JSON data is flat or has complex nested structures, this tool handles it all with ease.

Through the methods described in this guide, you can:

✅ Open and convert JSON files directly in WPS
✅ Quickly transform JSON data into WPS spreadsheets
✅ Batch convert JSON to CSV format
✅ Handle complex nested JSON structures
✅ Enable automated conversion through APIs

Start using the JSON-to-Excel WPS add-in today and make your data processing work more efficient!

Related Resources:

How to Import Geotagged Photos to Google Earth: A Step-by-Step Guide

WTSolutions — Wed, 05 Aug 2026 11:56:06 +0000

The Question Every Geo-Photographer Asks

You have a folder of photos taken with your phone or camera. Each one carries GPS coordinates hidden inside its metadata. You want those photos to appear on Google Earth — pinned at the exact spot where each was taken — so you can relive a trip, document a site, or share a location-aware story with someone else.

The problem: Google Earth has no built-in "import my photos and place them automatically" button that handles batches of geotagged images gracefully. Doing it photo by photo, manually entering coordinates, is impractical for any real collection.

This guide shows you how to import geotagged photos to Google Earth in minutes using the free WTSolutions "Images to Google Earth/Ovi Maps" tool — covering single photos, batch imports, and the common pitfalls that cause photos not to appear.

What You Need Before You Start

1. Photos that contain GPS data

A "geotagged photo" is a JPEG whose EXIF metadata includes latitude, longitude, and (usually) altitude. Most smartphones write this automatically when location services are on.

Quick check: On macOS, open the photo in Preview → Tools → Show Inspector (⌘I) → GPS tab. On Windows, right-click → Properties → Details → scroll to GPS. If you see coordinates, you're ready. If not, see our Photo Geotagging Best Practices guide — photos without GPS cannot be placed on the map.

2. Google Earth installed

Download the free Google Earth app from earth.google.com for desktop (Windows/Mac/Linux).

3. The Images to Google Earth tool

Open it in any modern browser: https://s.wtsolutions.cn/gps.html. No installation required for the online version; a desktop offline version is also available for Windows, Mac, and Linux.

How to Add Geotagged Photos in Google Earth: The Complete Workflow

Step 1: Open the tool and set the language

Go to https://s.wtsolutions.cn/gps.html. Click the English button in the top-right language switcher if the interface is in Chinese. The page loads with the photo drop zone ready.

Step 2: Import your geotagged photos

How to import a single photo with GPS location:

Drag one JPG/JPEG file from your file explorer into the dashed drop zone, or
Click the Select Images button and choose one file

How to import geotagged photos in batch:

Drag multiple photos (or an entire folder selection) into the drop zone at once, or
Click Select Images and pick several files in the file dialog

The tool immediately reads each photo's EXIF data — extracting GPS coordinates, altitude, and capture timestamp. The free version handles up to 6 photos per batch; a Pro Code unlocks unlimited imports for larger collections.

Format note: JPG and JPEG are fully supported. Photos shared through messaging apps (WeChat, WhatsApp, email attachments) often have their EXIF GPS stripped during compression — always work from originals transferred via USB, SD card, AirDrop, or cloud storage.

Step 3: Configure Map Settings

Click the Download KMZ File button to open Map Settings. For importing to Google Earth, set:

Map Service Provider: Google Earth (this embeds photos inside the KMZ so the file is fully portable and shareable)
Icon Style: pick any — Camera is a good default that communicates "photo location"
Image Display Width: 600 px (default) for general use; raise to 1000–1500 px for presentations; lower to 300–400 px for large batches

Close the settings. No path configuration is needed for Google Earth — unlike Ovi Maps, which requires a local image path.

Step 4: Export to KMZ

After the photos are loaded and processed, find the Data Export section below the drop zone. Click Export to Image KMZ File.

The tool generates a .kmz file — a compressed KML archive with your photos embedded inside. This single file contains everything Google Earth needs: the coordinates, the photo images, the icons, and the styling.

A browser download prompt appears; save the KMZ to a location you'll remember.

Step 5: Open the KMZ in Google Earth

On desktop:

Double-click the .kmz file — Google Earth opens it automatically if it's your default for that extension, or
Open Google Earth → File → Open → select the KMZ file

Step 6: Explore your photos on the globe

Google Earth flies to the location of your first photo. You'll see a pin for every imported photo at its exact GPS coordinates. Click any pin to open its photo popup. Drone photos taken at altitude appear as floating pins at their true height — striking in 3D view.

Use the scroll wheel or pinch to zoom, tilt, and rotate. Your photos now live on the globe, each in its rightful place.

That's It — You've Imported Geotagged Photos to Google Earth

The entire workflow from photo folder to globe-pinned map typically takes under a minute for a batch of photos. No manual coordinate entry, no scripting, no GIS expertise required.

Importing Geotagged Photos to Google Earth: Common Questions

Why don't my photos show up on the map after import?

This is the most common issue, and it almost always means the photos lack GPS data. Causes:

Photos were shared via messaging or social apps — these strip EXIF metadata. Re-transfer the originals via USB, SD card, AirDrop, or cloud.
Location services were off when the photo was taken — check your camera app's location/GPS toggle.
Photos were edited or exported through software that strips EXIF — some editors remove metadata by default.

Fix: Verify GPS data exists (see the "Quick check" above), then re-import the originals. The tool silently skips photos with no GPS — they won't appear in the KMZ.

Can I import geotagged photos to Google Earth without any software?

Not for batches. Google Earth can display a single photo via its built-in "Image Overlay" tool, but placing it at the correct GPS coordinates requires manual entry — and repeating that for dozens of photos is impractical. The WTSolutions tool automates the entire batch by reading EXIF data and writing the coordinates into a KMZ for you.

How do I add a photo to a specific GPS location in Google Earth?

If your photo already has GPS in its EXIF, the tool places it automatically — no manual coordinates needed. If the photo has no GPS, you can:

Use a companion GPS editor to write the coordinates into the photo's EXIF first
Re-import the photo with the tool — it will then pin to the location you set

What image formats can I import?

JPG and JPEG are fully supported, which covers the vast majority of phone and camera photos. PNG files are not the primary target; convert them to JPEG if needed.

How many photos can I import at once?

Free version: up to 6 photos per batch
Pro version: unlimited — suitable for trip archives, drone surveys, and large documentation projects

You can run multiple free batches and merge the resulting KMZ files in Google Earth (open them all at once, then save the combined view).

Does the tool upload my photos to a server?

No. All processing happens locally in your browser (or on your computer if you use the desktop version). Your photos never leave your device. The exported KMZ for Google Earth embeds copies of the photos at the display width you chose — the originals remain untouched.

Can I share the imported map with someone else?

Yes — this is one of the main advantages of the Google Earth export. Email kmz along with images, put it on a USB stick, or upload it to cloud storage. Anyone who opens it in Google Earth sees all your photos in place .

Why are some pins in the wrong location?

GPS accuracy depends on the capturing device. Indoors, in canyons, or under dense tree cover, the GPS fix can drift. Drone photos and outdoor phone photos are usually accurate to a few meters; indoor photos may be off by tens of meters. For the trajectory export, capture-time ordering also depends on the camera clock being set correctly. If you would like to manually modify the coordinates, you can do so with Images-GPS-editor at https://s.wtsolutions.cn/image-gps-editor.html

Tips for a Better Import

Organize photos before importing

Name files meaningfully (2026-07-trip-paris-001.jpg) — the filename becomes the pin's label in Google Earth. A consistent naming convention makes a large map navigable.

Use the right icon for your context

Camera: general photo documentation
Yellow Pushpin: high-visibility, presentations
Green Circle: dense batches where minimal visual weight matters
Pink Blank: contrast against green/natural backgrounds

Export a CSV alongside the KMZ

The CSV export gives you one row per photo (filename, latitude, longitude, altitude) — perfect for a backup record, spreadsheet analysis, or importing into other GIS tools later.

Re-import with different settings anytime

Because processing is instant and local, you can change the icon or image width and re-export the same batch as many times as you like. Try the default 600 px first; bump it up if a photo needs more detail.

Combine multiple trips into one map

Import each trip separately, export a KMZ for each, then open all the KMZ files in Google Earth at once. They layer automatically into a single multi-trip atlas. Save the combined view (File → Save Place As) to create one master KMZ.

Going Further: Beyond a Single Import

Once you've mastered the basic import, the same tool supports more advanced workflows:

Trajectory export: connects your photos' GPS points in chronological order — perfect for hiking routes, road trips, and drone flight paths
GeoJSON export: feeds your photo locations into GIS software like QGIS or ArcGIS for spatial analysis
Ovi Maps export: produces a KMZ optimized for teams using Ovi Maps (奥维地图) instead of Google Earth
Offline desktop version: runs without internet — ideal for fieldwork in remote areas

Each of these starts from the same drag-and-drop import described above; only the export step changes.

Conclusion

Importing geotagged photos to Google Earth doesn't have to involve manual coordinate entry or complicated GIS software. The WTSolutions Images to Google Earth tool reads the GPS already embedded in your photos and generates a ready-to-open KMZ in seconds — whether you're importing a single photo with a GPS location or a batch of hundreds from a trip, survey, or drone flight.

The workflow is always the same: enable GPS when you shoot → transfer originals → drag into the tool → export KMZ → open in Google Earth. Master these five steps and every photo you take from now on can live on the globe exactly where it belongs.

Start importing your geotagged photos to Google Earth right now at https://s.wtsolutions.cn/gps.html.

Images to Google Earth & Ovi Maps: A Tool That Turns Your Images into an Interactive Map

WTSolutions — Tue, 04 Aug 2026 07:58:36 +0000

Have you ever wondered if you could drop all your images onto a map and see where you've been — not just as a list of dates, but as actual pins scattered across the globe?

That's exactly what Images to Google Earth / Ovi Maps does. It reads the GPS data embedded in your photos' EXIF metadata, generates a KMZ file, and lets you drop it into Google Earth or Ovi Interactive Maps — instantly turning any collection of photos into an interactive, geolocated map.

Let's explore how this simple tool is being used across very different industries.

How It Works — In 30 Seconds

Open https://s.wtsolutions.cn/gps.html
Choose your target map software: Google Earth or Ovi Maps
Pick an icon style (camera, circle, pin, and more)
Drag and drop your photos onto the page
Download the generated KMZ file and open it in your map software

That's it. No account, no upload — all processing happens locally in your browser, so your photos never leave your device.

Applications Across Industries

🏗️ Engineering & Surveying

Surveyors and civil engineers take hundreds of site photos during a project. Instead of sorting them by date in a folder, they can import the KMZ into Google Earth to see every photo plotted at its exact GPS location — making it trivial to verify coverage, spot gaps, and deliver a spatial record to the client.

🌾 Agriculture & Land Management

Farmers and agronomists regularly fly drones over fields to monitor crop health. By generating a KMZ from the aerial images, they can overlay the flight path directly on the terrain and quickly identify which zones were photographed, compare different flights, and track changes over time.

🏘️ Urban Planning & Real Estate

City planners and real estate agents use this tool to visualize building inspections, site surveys, and property photos on a map. A real estate agent can drop a KMZ into Google Earth and walk a client through every photo of a neighborhood — each pin opening to the actual image.

🛰️ Drone & Aerial Photography

Drone operators use it as a flight debriefing tool: after a flight, they generate a KMZ and see the entire flight path in 3D — revealing gaps, overlaps, and altitude changes that a flat photo gallery can't show.

🧭 Travel & Adventure

The simplest use case: travel. Take all the photos from a trip, generate one KMZ, and watch your journey unfold on the map. Each pin is a moment. It's a visual diary of where you've been, far more engaging than a photo album.

📰 News & Field Research

Journalists and researchers on field assignments can create geo-referenced photo logs — crucial for accuracy in reporting or research documentation. Knowing exactly where each photo was taken is non-negotiable in field science.

A Simple Example: A Weekend Mountain Hike

Let's walk through a real-world scenario step by step.

The Situation:
You just came back from a 2-day mountain hiking trip. You took about 80 photos along the trail. Now you want to visualize the route you actually walked, not just what your GPS watch recorded.

Step 1 — Prepare your images

Make sure your phone or camera had GPS/location services enabled during the hike. Most modern devices do this by default. These images should contain GPS coordinates in their EXIF metadata.

Step 2 — Open the tool

Go to https://s.wtsolutions.cn/gps.html in your browser.

Step 3 — Choose your map

Select Google Earth as your target. Pick a camera icon style for a visual look.

Step 4 — Drag and drop

Select all 80 hiking images and drag them onto the page. The tool reads the GPS data from each image's EXIF information.

Step 5 — Download and open

Click download to get the KMZ file. Double-click it — it opens in Google Earth automatically.

Step 6 — See your route

You'll see a series of pins along the mountain trail, each representing a image. You can:

Zoom in on any pin to see the image preview;
Toggle the "Placemarks" folder to show or hide all image markers at once;
Rotate the 3D view to see how your route climbs and descends through the terrain.

That's it. In under two minutes, your weekend hike is now a 3D visual story on the globe.

💡 Tip: If you select Ovi Maps instead, you'll also need to enter the local folder path where your photos are stored (e.g., file:///Users/yourname/Pictures/hike/), so the map software can link to the actual image files on your disk.

Free vs. Pro

Feature	Free	Pro
Images per batch	6	Unlimited
KMZ generation	✅	✅
Custom image display size (20–3000 px)	✅	✅
Export GPS data to CSV	✅	✅
Multiple icon styles	✅	✅
Google Earth + Ovi Maps support	✅	✅
Cross-platform (Win / Mac / iOS / Linux / Android)	✅	✅

For a casual trip or quick preview, the free version works great. If you're a professional handling large photo sets and need GPS data export, the Pro version is the way to go.

Key Takeaways

Simple. Drag, drop, done. No technical knowledge required.
Private. Everything runs in your browser. No data ever leaves your device.
Versatile. Used by drone pilots, surveyors, farmers, travelers, journalists, and real estate agents — anyone who takes geotagged photos.
Cross-platform. Works on Windows, Mac, iOS, Linux, and Android.

If you take images that matter — whether for work or life — try turning them into a map. You'll see your world from a whole new perspective.

Sheet-to-Doc Skill: Let AI Assistants Generate Word Documents for You

WTSolutions — Wed, 22 Jul 2026 01:50:16 +0000

Do you frequently need to generate Word documents with the same format in your daily work? For example, batch-generating contracts, certificates, invitations, or reports. Manual copy-pasting is not only time-consuming but also prone to errors. Today, I'd like to introduce a powerful AI tool — Sheet-to-Doc Skill — that lets you automatically generate documents through simple conversation with your AI assistant.

What is Sheet-to-Doc Skill?

Sheet-to-Doc Skill is a plugin designed specifically for AI assistants (such as Cursor, Claude, OpenClaw, and others). It helps AI understand how to work with Word templates and data, automatically generating professional Word documents.

Simply put, you only need to tell the AI what you want, and it will automatically complete the document generation for you, without needing to learn complex commands or tools.

Core Features

Document Generation: Replace {field} placeholders in Word templates with JSON data
Placeholder Extraction: Extract all placeholder keys from templates for data validation
Footer Mark: Automatically adds footer attribution to generated documents
Cross-Platform: Works on Windows, macOS, and Linux
Command Line Interface: Easy to use via terminal
API Access: Import as a module for programmatic use

Why Use Sheet-to-Doc Skill?

1. Lower the Learning Curve

Traditional tools require manual operation, while Sheet-to-Doc Skill lets the AI do the work for you. You just need to describe your needs in natural language, and the AI will execute automatically.

2. Improve Work Efficiency

Compress hours of manual work into minutes, giving you more time to focus on more important tasks.

3. Reduce Human Errors

Eliminate errors from manual copy-pasting and ensure 100% accuracy in generated documents.

4. Integrate into AI Workflows

Can be used in conjunction with other AI tools to achieve more complex automation processes.

How to Install Sheet-to-Doc Skill

Method 1: Install via OpenClaw

If you're using the OpenClaw AI platform, you can install it with the following commands:

# First, install OpenClaw
npm install -g openclaw

# Then install Sheet-to-Doc Skill
openclaw skills install @he-yang/sheet-to-doc-skill

Method 2: Install via Skills CLI

If you're using other AI platforms that support Skills:

npx skills add https://github.com/he-yang/sheet-to-doc-skill --skill sheet-to-doc-skill

Once installed, your AI assistant will have document generation capabilities.

Quick Start: A Complete Usage Example

Scenario: Batch Generate Employee Welcome Letters

Let's say you need to generate personalized welcome letters for 50 new employees. Here's how to use Sheet-to-Doc Skill to complete this task.

Step 1: Prepare the Word Template

Create a Word document with placeholders that need to be filled with data:

Dear {name},

Welcome to {company}. Your position is {position}.

Your contact information:
- Email: {email}
- Phone: {phone}

Your start date is {start_date}. Please bring the required documents to the HR department on that day.

We look forward to working with you!

Best regards,
{company}

Save this document as welcome_letter.docx.

Step 2: Prepare Employee Data

Create a JSON file containing all employee information:

{
  "name": "John Doe",
  "company": "Example Tech Co., Ltd.",
  "position": "Senior Software Engineer",
  "email": "john.doe@example.com",
  "phone": "+86 13800138000",
  "start_date": "August 1, 2026"
}

Save as employee_data.json.

Step 3: Let AI Generate the Document

Now, you only need to tell the AI:

"Please replace the data in the template welcome_letter.docx with the content from employee_data.json, and generate a new Word document welcome_letter_output.docx."

The AI will automatically execute the following steps:

Read the Word template
Read the JSON data
Fill the template with the data
Generate the new Word document

Command Line Method

If you prefer using the command line, you can run:

# Basic usage
node scripts/generate.js \
  --template welcome_letter.docx \
  --data employee_data.json \
  --output welcome_letter_output.docx

# Using short parameters
node scripts/generate.js -t welcome_letter.docx -d employee_data.json -o welcome_letter_output.docx

# Using JSON string directly
node scripts/generate.js -t template.docx -d '{"name":"John Doe","company":"Example Tech"}' -o output.docx

Practical Scenarios and Examples

Example 1: Generate Product Quotations

Requirement: Generate personalized product quotations for 100 clients.

Template Example:

{company_name} Quotation

Client: {customer_name}
Date: {date}

Product: {product_name}
Quantity: {quantity}
Unit Price: {unit_price} USD
Total: {total_price} USD

Notes: {notes}

{company_name}

Data Example:

{
  "company_name": "Example Tech Co., Ltd.",
  "customer_name": "Li Ming",
  "date": "July 22, 2026",
  "product_name": "Smart Office Equipment Kit",
  "quantity": 10,
  "unit_price": 5000,
  "total_price": 50000,
  "notes": "Installation and debugging service included"
}

Example 2: Generate Training Certificates

Requirement: Generate completion certificates for all trainees who attended a training course.

Template Example:

Certificate of Completion

This is to certify that {student_name} has successfully completed the {course_name} training
held from {training_date} with excellent performance.

Instructor: {instructor_name}
Certificate No.: {certificate_number}

{company_name}
{date}

Data Example:

{
  "student_name": "Wang Xiaohong",
  "training_date": "July 1-10, 2026",
  "course_name": "Project Management Fundamentals Training",
  "instructor_name": "Prof. Chen",
  "certificate_number": "CERT-2026-001",
  "company_name": "Example Tech Co., Ltd.",
  "date": "July 15, 2026"
}

Example 3: Generate Project Reports

Requirement: Generate standardized progress reports for multiple projects.

Template Example:

Project Progress Report

Project Name: {project_name}
Project Manager: {manager_name}
Report Date: {report_date}

This Week's Work:
{weekly_summary}

Progress: {progress_percentage}%

Issues Encountered:
{issues}

Next Week's Plan:
{next_week_plan}

{manager_name}
{report_date}

Data Validation: Extract Placeholders from Templates

Before generating documents, you can check what placeholders exist in your template to ensure your data includes all required fields.

Command Line Method

# Extract placeholders
node scripts/generate.js --extract-placeholders --template welcome_letter.docx

# Short version
node scripts/generate.js -e -t welcome_letter.docx

Output example:

{
  "success": true,
  "placeholders": ["company", "email", "name", "phone", "start_date", "position"],
  "count": 6,
  "message": "Extracted 6 placeholder(s) from template"
}

Query via AI

You can also simply ask the AI:

"Please check what placeholders are in the template welcome_letter.docx? What data do I need to prepare?"

The AI will automatically execute the extraction and tell you the required fields.

Advanced Usage

API Call

If you need to integrate document generation into your code:

import { generateDocument, extractPlaceholders } from './scripts/generate.js';

// Generate document
const result = generateDocument(
    'template.docx',
    { name: 'John Doe', company: 'Example Tech' },
    'output.docx'
);

console.log(`Document generated: ${result}`);

// Extract placeholders
const placeholders = extractPlaceholders('template.docx');
console.log('Required fields:', placeholders);

// Validate data completeness
const data = { name: 'John', company: 'Example' };
const missingFields = placeholders.filter(field => !data.hasOwnProperty(field));

if (missingFields.length > 0) {
  console.error('Missing fields:', missingFields);
}

Frequently Asked Questions

Q: What's the difference between Sheet-to-Doc Skill and the full Sheet-to-Doc?

Sheet-to-Doc Skill is a simplified version focused on AI integration scenarios. The full Sheet-to-Doc supports additional features, including:

Batch document generation (each row generates an independent document)
Multiple data sources: Excel, CSV, JSONL
Image insertion: {image|_inline_image}
QR code generation: {url|_qrcode}
Conditional logic: {field==value}
Loop processing: {#data}{/data}
Document encryption
Remove footer attribution

Q: Do I need Node.js?

Yes, Sheet-to-Doc Skill requires Node.js 18 or higher. If you're already running AI tools, you typically don't need to install anything extra.

Q: Are generated documents watermarked?

The simplified version adds a footer attribution to generated documents, indicating the source. This respects the product author. If you need to remove the attribution, you can upgrade to the full version of Sheet-to-Doc.

Summary

Sheet-to-Doc Skill is a powerful AI tool that helps you easily automate Word document generation. Whether you're generating contracts, certificates, quotations, or reports, you just need to prepare your template and data, tell the AI what you need, and it will handle the rest automatically.

Start Using Now:

Installation: Follow the steps above
Full Documentation: https://sheet-to-doc.wtsolutions.cn/en/latest/index.html
Official Website: https://sheet-to-doc.wtsolutions.cn

If you need more powerful features, you can upgrade to the full Sheet-to-Doc product, which supports batch generation, multiple data sources, image insertion, QR code generation, and more advanced features.

License: This skill is licensed under the MIT License. Sheet-to-Doc Skill is an open-source project. Welcome to use and contribute.

Sheet-to-Doc Skill

WTSolutions — Wed, 22 Jul 2026 01:38:40 +0000

A simplified AI Skill for generating Word documents from Word templates and JSON data. This is a free simplified version of full-featured Sheet-to-Doc product.

Features

Document Generation: Replace {field} placeholders in Word templates with JSON data
Placeholder Extraction: Extract all placeholder keys from templates for data validation
Footer Mark: Automatically adds footer attribution to generated documents
Cross-Platform: Works on Windows, macOS, and Linux
Command Line Interface: Easy to use via terminal
API Access: Import as a module for programmatic use

Requirements

Node.js 18+
docxtemplater
pizzip

Installation

OpenClaw Installation

npm install -g openclaw

openclaw skills install @he-yang/sheet-to-doc-skill

Skills Installation

npx skills add https://github.com/he-yang/sheet-to-doc-skill --skill sheet-to-doc-skill

Quick Start

1. Create a Word Template

Create a .docx file with {field} format placeholders:

Dear {name},

Welcome to {company}. Your position is {position}.

Email: {email}
Phone: {phone}

2. Prepare JSON Data

{
  "name": "John Doe",
  "company": "Example Tech Co., Ltd.",
  "position": "Senior Engineer",
  "email": "john.doe@example.com",
  "phone": "+86 13800138000"
}

3. Generate Document

Using Command Line

# Basic usage
node scripts/generate.js \
  --template template.docx \
  --data data.json \
  --output output.docx

# Using short parameters
node scripts/generate.js -t template.docx -d data.json -o output.docx

# Using JSON string directly
node scripts/generate.js -t template.docx -d '{"name":"John","company":"Example"}' -o output.docx

Using API

import { generateDocument } from './scripts/generate.js';

const result = generateDocument(
    'template.docx',
    { 'name': 'John Doe', 'company': 'Example Tech' },
    'output.docx'
);

console.log(`Document generated: ${result}`);

Placeholder Extraction

Extract required placeholders from a template to validate your data:

# Extract placeholders
node scripts/generate.js --extract-placeholders --template template.docx

# Short version
node scripts/generate.js -e -t template.docx

Output:

{
  "success": true,
  "placeholders": ["company", "email", "name", "phone", "position"],
  "count": 5,
  "message": "Extracted 5 placeholder(s) from template"
}

API Usage

import { extractPlaceholders } from './scripts/generate.js';

const placeholders = extractPlaceholders('template.docx');
console.log('Required fields:', placeholders);

// Validate data completeness
const data = { "name": "John", "company": "Example" };
const missingFields = placeholders.filter(field => !data.hasOwnProperty(field));

if (missingFields.length > 0) {
  console.error('Missing fields:', missingFields);
}

Command Line Options

Option	Short	Description
--template	-t	Word template file path (.docx)
--data	-d	JSON data file path or JSON string
--output	-o	Output file path
--extract-placeholders	-e	Extract placeholder keys from template (no generation)

Project Structure

skill/
├── SKILL.md              # Skill metadata and documentation for AI Agents
├── README.md             # This file
├── package.json          # Project dependencies and scripts
└── scripts/
    └── generate.js       # Core document generation logic

Debugging

When document generation fails, use the placeholder extraction feature to debug:

import { extractPlaceholders } from './scripts/generate.js';

// Step 1: Extract placeholders from template
const templatePlaceholders = extractPlaceholders('template.docx');

// Step 2: Compare with your data keys
const dataKeys = Object.keys(yourData);

// Step 3: Find mismatches
const missingInData = templatePlaceholders.filter(p => !dataKeys.includes(p));
const extraInData = dataKeys.filter(k => !templatePlaceholders.includes(k));

console.log('Missing keys:', missingInData);
console.log('Extra keys:', extraInData);

Upgrade to Full Version

This is a simplified free version. For complete features, upgrade to the full Sheet-to-Doc:

Batch document generation (each row generates an independent document)
Multiple data sources: Excel, CSV, JSONL support
Image insertion: {image|_inline_image}
QR code generation: {url|_qrcode}
Conditional logic: {field==value}
Loop processing: {#data}{/data}
Document encryption
Remove footer attribution

License

MIT License

Support

Official Website: https://sheet-to-doc.wtsolutions.cn
Documentation: https://sheet-to-doc.wtsolutions.cn/en/latest/index.html
Contact: he.yang@wtsolutions.cn

The Photos I Almost Forgot: How I Found My Way on a Map

WTSolutions — Mon, 20 Jul 2026 07:09:53 +0000

The Map Hiding in My Photo Album

My phone has nearly 10,000 photos—most of them from trips over the years. But honestly, they just sit there quietly in folders. I scroll through them occasionally, take a look, and move on.

The moment that made me start thinking about this was last year, when a friend asked: "What good photos did you take in Kyoto during your last trip to Japan?"

I searched for a while and only found a few blurry screenshots. With so many photos, I couldn't even remember where I shot them or what I captured. In that moment, I suddenly realized—these photos recorded more than just images. They held time, place, and stories. But all of that information was scattered in the corners of my photo album, never opened again.

An Accidental Discovery

About six months ago, I was searching online for "photo geotagging tools," wondering if there was any way to connect photos with maps. That's when I came across this tool: WTSolutions' Images to Google Earth/Ovi Maps.

Honestly, I didn't pay much attention at first. This kind of tool sounded like something only GIS professionals would use. But when I saw "online version, no download, just drag and drop," I decided to click through anyway.

Drag and Drop—That's It?

The page was remarkably simple. Nothing complicated. I grabbed 6 photos from my Xi'an trip and dragged them onto the page. Then it just started processing automatically.

A few seconds later, there was a download link for a KMZ file on the page.

I was stunned. That was it? No sign-up, no payment, no tedious settings?

Still skeptical, I dragged the KMZ file into Google Earth.

Then I saw something I'd never seen before—those photos appeared one by one on the map, right where I had taken them back then. I could fly over the Earth and click each photo to see the view from that moment.

It's hard to describe that feeling. It was like suddenly having a photo album that could talk.

Ovi Maps: Better for China

Later, I tried again with Ovi Maps. Honestly, Google Earth isn't always convenient in China, and Ovi Maps worked much better for me when I needed to check maps in work scenarios.

In Ovi Maps, the photos appear as icons on the map, and you can click to see the actual photo. For colleagues who need to locate shooting sites for work, this feature is simply a game-changer.

Privacy: What Really Won Me Over

To be honest, I was initially hesitant about online tools. Uploading my personal photos to some unknown website? That gave me pause.

But after reading the website's explanation, I discovered that all processing happens locally in the browser. The photos never get uploaded to any server. This meant—even my most private photos could be handled with confidence.

This was the point that changed my mind entirely. So many online tools require uploading data. The fact that this one processes everything locally is genuinely different.

It Changed How I Organize My Photos

Now, every time I return from a trip, the first thing I do isn't post on social media—it's import those photos onto a map.

Looking at the dense cluster of markers on the map, I suddenly realized—I've been to far more places than I thought. All those "been there" moments, connected on a map, form a real travel trajectory.

And this approach made me re-examine what a photo really means. It's not just a static image anymore—it's a coordinate, a moment, an anchor of memory in space.

Not Just Travel—It's Life

Later, I started using this tool for everyday work too. On one project trip, I took lots of site photos. After importing them into Ovi Maps, the entire project progress became visible at a glance. My colleagues all said, "This feature is incredibly practical."

I also use it for urban exploration. I walk around and shoot photos on weekends, then import them into the map on Sunday night to see where I've been that week. Unknowingly, a "life map" of my own is forming.

Is the Free Version Enough?

For everyday users, the free version's limit of 6 photos per batch is more than sufficient. Most of the time, I don't need to process dozens or hundreds at once, so the free version has been with me all along.

Of course, if you're a power user, upgrading to the Pro version is a reasonable choice. Unlimited processing, custom image sizes, GeoJSON export—these features genuinely solve real problems.

But honestly, as someone who uses this feature occasionally, the free version has already brought me tremendous value.

Wrapping Up

Sometimes I think the value of a tech product isn't about how powerful its features are, but whether it can truly enter our lives and change how we see the world.

For me, this tool is exactly that kind of existence. It didn't teach me any advanced GIS systems, and it didn't make me a photography master. It just helped me rediscover every photo in my album—they're not just images; they're my footprints on this planet.

If you have thousands of photos sitting in your album with no idea what they hold, give this method a try.

You won't just see a map. You'll see the roads you've walked.

>> Try Images to Google Earth/Ovi Maps <<

I Shot Hundreds of Drone Photos—Here's How I Turned Them into a Flight Path

WTSolutions — Mon, 20 Jul 2026 07:08:37 +0000

Hundreds of Photos, One Folder

I'm a drone enthusiast—not professional, but someone who loves taking their drone on every trip. Honestly, the best part of drone flying isn't the shooting moment itself, but the review. That bird's-eye perspective is something only someone who's actually flown a place can truly understand.

But after every flight, hundreds of photos get dumped into a folder and just pile up. I'll open a few occasionally, but they quickly get buried under the next batch.

It wasn't until one day that I realized—these photos aren't just images. They're a flight trajectory.

From One Photo to an Entire Map

Every time I fly, the drone automatically records GPS data for each photo. Theoretically, if I could extract that GPS information and place the photos back on a map, I could see exactly where my drone flew.

But doing it manually? Hundreds of photos, opening each one's properties, copying coordinates, pasting them one by one into a map—just the thought of it made me give up.

That was until I found WTSolutions' Images to Google Earth/Ovi Maps.

Drag and Drop—It Just Gets It

The operation was so simple it almost embarrassed me. I dragged an entire folder of photos onto the webpage, and the tool automatically extracted the GPS data from each image. Within seconds, it generated a KMZ file.

I downloaded it, dragged it into Google Earth.

Then I saw something I'd never seen before—every photo my drone took appeared one by one on the map, connected in flight order into a continuous path. I could see the entire flight area at a glance, and clearly understand the spatial relationship between every shooting point.

It's hard to describe. It was like I finally had a real map of my entire flight.

This Is Almost a Must-Have for Drone Operators

Honestly, as a drone operator, this tool solved a problem I'd always wanted to solve but never imagined could be this simple.

Flight debriefing. After every flight, I can clearly see which areas I covered, how far I flew, and which spots I missed. This has helped me improve my flight technique significantly.

Client delivery. Sometimes I do aerial work for others—construction sites, terrain surveys. I just send the KMZ file to the client, and they can open it in Google Earth to see exactly where each photo was taken. No more explaining photo by photo "where is this?"

Creative inspiration. Sometimes after a flight I realize I missed an angle. But looking at the map, I can figure out that flying from another direction would fill the gap. The map gives me a much better sense of spatial relationships in my flights.

Ovi Maps: A Drone Enthusiast's New Favorite Tool

For drone operators in China, Ovi Maps is actually more practical than Google Earth.

The reason is simple: Ovi Maps can overlay various layers—contour lines, satellite imagery, terrain maps. After importing the KMZ file, I can see photo positions in the actual flight environment, combined with contour lines to judge altitude and terrain relationships.

Once I was flying in a mountainous area. After importing the photos into Ovi Maps, the contour lines revealed a valley I had completely missed. I later flew specifically there and captured some stunning shots I never would have found otherwise.

A Special Request: Helping a Village Map Its Collective Assets

What truly made me realize this tool's value extends far beyond personal interest was a special request from a client.

One day, a friend who does drone aerial photography reached out. He was working on a survey for a village—mapping their "san zi," the collective assets of rural communities: funds, physical assets, and natural resources like land, forests, water bodies, and buildings that belong to the entire village.

For years, these assets were recorded on paper ledgers and kept in the memory of aging village officials. Boundaries were unclear, areas didn't match, and the accounts were a mess. Now policy demands digitalization—every plot of land, every forest patch, needs to be mapped precisely.

"I flew dozens of missions and took over a thousand photos," he told me. "But photos alone aren't enough. I need to turn the GPS location of each photo into a manageable map."

I had him try this tool. He dragged the GPS-tagged drone photos into it, generated a KMZ file, and imported it into Ovi Maps.

Then I saw what delighted him—every field, every forest, every homestead appeared on the map exactly where the drone had photographed it. The village officials could stand at the edge of a field with a tablet, tap a marker on the map, and see the real aerial photo taken from above. The boundaries were crystal clear.

"This is way faster than manually tracing everything," he said. "And when villagers come to identify boundaries on-site, they can just look at the photos. Disputes disappear almost instantly."

Later he told me the survey resolved several historical issues: land thought to belong to the village turned out to be the neighboring village's on closer inspection; conversely, they recovered two edge plots that had been completely missed from the old ledger.

This moment made me realize that drone aerial photography + GPS mapping tools is no longer just a hobbyist's toy. It has entered the actual workflow of grassroots governance.

It Changed How I Think About Flight Logs

My old flight log was pretty traditional: time, location, weather, flight duration. But those entries were too dry—I'd forget them quickly after reading.

Now, after importing each flight's photos onto a map, my flight log becomes a visual landscape. Without any text, I can immediately see where I flew, how long I was up, and what area I covered.

Sometimes, when I look back at previous flight records, seeing those markers on the map, I suddenly remember how strong the wind was that day, or how the sunlight hit the terrain. Every point on the map is a flight memory.

Is the Free Version Enough for Drone Operators?

For an everyday drone hobbyist, the free version's 6-photo limit is honestly quite tight. A single flight typically produces dozens or even hundreds of aerial photos, and 6 is nowhere near enough to debrief an entire flight.

So for me, upgrading to the Pro version makes sense. Unlimited processing, custom image display sizes, GeoJSON export—these features are genuinely useful for drone operators.

Especially GeoJSON export. Sometimes I import flight data into flight planning software for more advanced data analysis. That feature made me feel the tool's value went far beyond its original promise.

Wrapping Up

What makes drone flying most captivating isn't how high you fly or how far you shoot—it's how you see the world from a completely different angle.

This tool didn't change how I fly. But it changed how I look at my flights. Instead of seeing a pile of scattered photos, I now see a complete flight—with a starting point, a trajectory, a covered area, and every photo's corresponding ground position.

Every time I import photos after a flight, it feels like the final step of completing the mission—placing a visual stamp on that flight.

If you're a drone operator, or just someone who loves capturing the world from above, this tool will make you redefine what "flight logging" really means.

>> Try Images to Google Earth/Ovi Maps <<

Excel-to-JSON & JSON-to-Excel - The Ultimate Data Conversion Bridge by WTSolutions

WTSolutions — Fri, 10 Jul 2026 01:49:24 +0000

The Easiest Bridge Between Excel and JSON

WTSolutions introduces two powerful data conversion tools that seamlessly connect spreadsheets with JSON - Excel-to-JSON and JSON-to-Excel. These professional tools cover bidirectional conversion scenarios with full-platform, full-scenario solutions designed to boost your data transformation efficiency.

https://s.wtsolutions.cn/excel-json-product.html

Two Products, One Mission

Excel-to-JSON

Quickly convert spreadsheet data into structured JSON within Excel or WPS. Whether you're working on frontend/backend development, data migration, or API integration, this tool supports both flat and nested modes to meet all your requirements.

JSON-to-Excel

Transform JSON data (including deeply nested structures) into well-formatted Excel spreadsheets. With support for paste, file upload, and URL loading input methods, batch processing becomes incredibly efficient.

Key Features That Set Us Apart

More than simple format conversion - these tools serve as your professional data processing partner.

Flat & Nested JSON Support

Both tools handle flat structures and multi-level nested JSON conversion with ease. Customizable delimiters (dot ., underscore _, double underscore __, slash /) allow flexible control over nesting levels.

Fine-grained Data Control

Empty cells: Choose between empty string, null, or exclude from output
Boolean values: Support for true/false, string "true"/"false", or numeric 1/0 formats
Date formats: ISO 8601 standard or days-since-1900 numeric format

Full-scenario Coverage

Six deployment forms to meet any use case:

Web App: Use directly in browser, no installation required
Excel Add-in: Seamless in-place conversion within Excel
WPS Add-in: Same conversion experience in WPS
REST API: HTTPS POST requests for automated integration
MCP Service: Direct AI model invocation for intelligent workflows
Local App: Fully offline support for maximum data security
Local Excel Addin: Direct conversion within Excel, full offline support

AI Integration (MCP)

The MCP (Model Context Protocol) service enables AI models to directly invoke Excel-JSON conversion capabilities, creating intelligent data processing workflows that integrate seamlessly with modern AI tools.

Privacy First Approach

Data is processed locally in your browser or on your device - never uploaded to servers for storage. Local solutions support fully offline use, ensuring maximum data security for sensitive information.

Cross-platform Support

Full support for Windows, Mac, and Linux desktop platforms, plus web access via any browser. Convert data anytime, anywhere, regardless of your operating system.

Flexible Conversion Settings

Every detail is controllable, ensuring the output matches your expectations exactly.

Conversion Mode

Flat mode: Ideal for simple tables with straightforward data structures
Nested mode: Handles multi-level structures and complex data relationships

Nested Delimiter

Choose from dot (.), underscore (_), double underscore (__), or slash (/) to match different naming conventions in your data.

Excel → JSON Specific Options

Empty cell handling: Three output options (empty string, null, or exclude)
Boolean format: JSON true/false, string "true"/"false", or numeric 1/0
Date format: ISO 8601 standard or days-since-1900

JSON → Excel Specific Options

Max nesting depth: Customizable from 1-20 levels or infinite; deeper levels are automatically stringified to prevent data loss

Simple & Transparent Pricing

One Pro Code works for both products. Affordable pricing meets professional needs.

Free Version

Up to 6 rows per conversion
Basic conversion features
Web / Excel / WPS all platforms

Pro (Web-based)

Unlimited data conversion
All advanced conversion settings
Ad-free experience
10 devices supported
7-day free trial
Both products included

Pro (Local Solution)

Unlimited data conversion
Lifetime access
Fully offline support
Bound to one device ID
Both products included

Ready to Boost Your Data Conversion Efficiency?

Whether you're a developer needing to integrate Excel data with APIs, a data analyst migrating between formats, or an AI enthusiast looking to enhance your workflows, Excel-to-JSON and JSON-to-Excel provide the perfect solution.

Start your 7-day free trial today and experience professional-grade data conversion!

Excel → JSON Get Started
JSON → Excel Get Started