DEV Community: Bobo

Validate JSON Like a Pro: Catch Syntax Errors Before They Break Your App

Bobo — Sat, 13 Jun 2026 17:12:20 +0000

Validate JSON Like a Pro: Catch Syntax Errors Before They Break Your App

A single missing comma in a JSON config file can take down your entire application. Here's how to validate JSON files before they cause damage.

Install json-tidy

npm install -g json-tidy-pro

Validate Single File

json-tidy validate config.json
# ✅ Valid JSON!

Validate Multiple Files

json-tidy validate config/*.json
# ✅ config.json: Valid
# ❌ database.json: Invalid - missing comma at line 42
# ✅ routes.json: Valid

Integrate into Git Hooks

# .git/hooks/pre-commit
#!/bin/bash
npx json-tidy validate config/*.json
if [ $? -ne 0 ]; then
    echo "❌ Invalid JSON detected. Fix before committing."
    exit 1
fi

Integrate into CI/CD

# .github/workflows/validate.yml
name: Validate JSON
on: [push]
jobs:
  validate:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v3
      - run: npx json-tidy validate ./config/**/*.json

Common JSON Errors json-tidy Catches

Missing commas in objects and arrays
Trailing commas (not allowed in strict JSON)
Unquoted property names
Single quotes instead of double quotes
Comments (not valid in JSON)
Extra trailing content

Install

npm install -g json-tidy-pro

🎪 Visit us: https://www.tucaowall.vip/
⭐ Get free DigitalOcean credit: https://m.do.co/c/fc5cb7b29a0d
🔧 CLI Toolkit Pro - Unified CLI for devs: Buy $9.99

Have a JSON horror story? Share it in the comments!

json-tidy: Stop Manually Formatting JSON Files

Bobo — Sat, 13 Jun 2026 17:05:02 +0000

JSON Shouldn't Be a Chore

Every developer has been there: you copypaste JSON into an online formatter, hit format, copypaste back. Then you wonder "why is there no CLI for this?"

There is now.

npx json-tidy-pro format messy.json
npx json-tidy-pro validate config.json
npx json-tidy-pro minify data.json
npx json-tidy-pro convert data.json --to yaml

Features

Format & Beautify

Indent properly, sort keys, colorize output.

Validate

Check structure, detect duplicate keys, validate against a schema.

Minify

Condense JSON to one line for API payloads and storage.

Convert

JSON → YAML, JSON → CSV, JSON → TOML.

Installation

npm install -g json-tidy-pro

npm package
GitHub repo---

More Resources

🛠️ My tools & open-source projects: GitHub
📝 Blog & updates: TucaoWall
☁️ Deploy your own cloud server and get $25 credit: DigitalOcean
🐙 CLI Toolkit Pro (bundle of all my CLI tools): npm
💼 Hire me on Freelancer: a0982

How to Convert Excel Files to CSV and JSON Programmatically

Bobo — Fri, 12 Jun 2026 17:39:07 +0000

How to Convert Excel Files to CSV and JSON Programmatically

Excel files are everywhere. But most programs work better with CSV or JSON. Here's how to bridge the gap.

Method 1: CLI (Fastest)

npm install -g csv-toolkit-pro

# Excel to CSV
csv-toolkit-pro convert input.xlsx -o output.csv

# Excel to JSON (via CSV)
csv-toolkit-pro convert input.xlsx -o temp.csv
csv-toolkit-pro convert temp.csv -o output.json

Method 2: REST API

npm install -g csv-api
csv-api --port 3000 &

curl -X POST http://localhost:3000/convert   -F "file=@report.xlsx"   -F "format=csv"

Method 3: Programmatic

const csvToolkit = require('csv-toolkit');

// Convert Excel to CSV
csvToolkit.convert('report.xlsx', 'report.csv');

One-Liner Conversion

# Convert all Excel files in a folder
csv-toolkit-pro convert ./excel_files/*.xlsx -o ./csv_files/

Supported Formats

csv-toolkit supports:

.xlsx (Excel 2007+)
.xls (Excel 97-2003)
.csv
.tsv
.json

Install

npm install -g csv-toolkit-pro

🎪 Visit us: https://www.tucaowall.vip/
⭐ Get free DigitalOcean credit: https://m.do.co/c/fc5cb7b29a0d
🔧 CLI Toolkit Pro - Unified CLI for devs: Buy $9.99

How do you handle Excel conversions? Share your workflow!

csv-toolkit: The CSV/Excel Swiss Army Knife You Didn't Know You Needed

Bobo — Fri, 12 Jun 2026 17:37:17 +0000

Why Another CSV Tool?

There are a thousand CSV parsers in Node.js. So why build another one?

Because I got tired of writing the same 20-line script every time someone asked me to "just merge these 12 CSV files" or "remove duplicates from this export."

csv-toolkit-pro is the CLI tool I wish existed: one command, zero config, and it just works.

Quick Start

npx csv-toolkit-pro merge file1.csv file2.csv -o merged.csv
npx csv-toolkit-pro clean messy.csv --dedup --strip-whitespace
npx csv-toolkit-pro analyze sales.csv --stats
npx csv-toolkit-pro convert data.csv --to json

Install once, use everywhere:

npm install -g csv-toolkit-pro

What It Does

Merge

Combine multiple CSVs with matching columns into one file. Handles encoding, header mismatches, and large files (100k+ rows) without breaking a sweat.

Clean

Remove duplicate rows
Strip whitespace and fix encoding
Filter by column values
Fill missing values
Normalize date formats

Analyze

Column statistics (min, max, avg, count, nulls)
Value distribution
File size and row count
Export summary as JSON

Convert

CSV → JSON
CSV → Markdown table
CSV → Excel (.xlsx)
JSON → CSV

Why Use It?

Task	Without csv-toolkit	With csv-toolkit
Merge 5 CSVs	30 min (write script)	3 seconds
Clean export data	15 min (Excel + formulas)	2 seconds
Analyze sales data	20 min (pivot table)	5 seconds
Convert to JSON	10 min (write code)	2 seconds

Excel Support

Version 1.1+ includes full .xlsx support:

csv-toolkit-pro convert data.xlsx --to csv
csv-toolkit-pro merge data.xlsx report.csv -o combined.xlsx

Installation

# Global install
npm install -g csv-toolkit-pro

# Or use without install
npx csv-toolkit-pro --help

More Resources

🛠️ My tools & open-source projects: GitHub
📝 Blog & updates: TucaoWall
☁️ Deploy your own cloud server and get $25 credit: DigitalOcean
🐙 CLI Toolkit Pro (bundle of all my CLI tools): npm
💼 Hire me on Freelancer: a0982

Introducing CLI Toolkit Pro: 8 CLI Tools in One Package

Bobo — Thu, 11 Jun 2026 16:57:32 +0000

One CLI to Rule Them All

I maintain 8 individual CLI tools (csv-toolkit-pro, json-tidy-pro, batch-image-tool, text-processor-pro, file-batch-toolkit, pdf-toolkit-pro, csv-processing-api-server, creator-automation-bot).

They're all useful individually. But typing 8 different command names is annoying.

CLI Toolkit Pro bundles all of them into one unified interface:

npx cli-toolkit-pro csv merge file1.csv file2.csv
npx cli-toolkit-pro json format data.json
npx cli-toolkit-pro image compress ./photos/
npx cli-toolkit-pro text replace ./logs/ "old" "new"
npx cli-toolkit-pro file rename ./downloads/ --pattern "doc-{n}"
npx cli-toolkit-pro pdf merge doc1.pdf doc2.pdf

What's Inside

Module	Individual Package	CLI Toolkit Command
CSV/Excel	csv-toolkit-pro	`cli-toolkit csv ...`
JSON	json-tidy-pro	`cli-toolkit json ...`
Images	batch-image-tool	`cli-toolkit image ...`
Text	text-processor-pro	`cli-toolkit text ...`
Files	file-batch-toolkit	`cli-toolkit file ...`
PDFs	pdf-toolkit-pro	`cli-toolkit pdf ...`

Installation

npm install -g cli-toolkit-pro

npm package
GitHub repo---

More Resources

🛠️ My tools & open-source projects: GitHub
📝 Blog & updates: TucaoWall
☁️ Deploy your own cloud server and get $25 credit: DigitalOcean
🐙 CLI Toolkit Pro (bundle of all my CLI tools): npm
💼 Hire me on Freelancer: a0982

Turn Your CSV Files Into a REST API in 2 Minutes

Bobo — Thu, 11 Jun 2026 16:56:57 +0000

CSV as a Service

Sometimes you don't want a CLI. You want an API. You want to upload a CSV, do something to it, and get the result back programmatically.

csv-processing-api-server gives you exactly that:

npx csv-processing-api-server
# Server running on http://localhost:3030

Then make API calls:

curl -X POST http://localhost:3030/api/clean \
  -F "file=@messy.csv" \
  -F "options={\"dedup\": true}"

API Endpoints

Endpoint	What It Does
`POST /api/clean`	Upload + clean (dedup, strip whitespace, fill nulls)
`POST /api/convert`	CSV → JSON, CSV → Excel
`POST /api/analyze`	Column stats, distribution, summaries
`GET /api/health`	Server status

npm install -g csv-processing-api-server

npm package
GitHub repo---

More Resources

🛠️ My tools & open-source projects: GitHub
📝 Blog & updates: TucaoWall
☁️ Deploy your own cloud server and get $25 credit: DigitalOcean
🐙 CLI Toolkit Pro (bundle of all my CLI tools): npm
💼 Hire me on Freelancer: a0982

text-processor: The Find-and-Replace Tool That Handles 1000 Files at Once

Bobo — Thu, 11 Jun 2026 16:54:52 +0000

text-processor: The Find-and-Replace Tool That Handles 1000 Files at Once

Remember when you had to update a copyright year across your entire website? Or replace a deprecated API call in 500 source files? text-processor handles it in seconds.

Install

npm install -g text-processor-pro

Bulk Find and Replace

# Update copyright year across all HTML files
text-processor replace "*.html" "Copyright 2025" "Copyright 2026"

Extract Lines Matching a Pattern

# Extract all error messages from logs
text-processor extract "*.log" "ERROR" -o all_errors.txt

Count Words and Lines

text-processor count "*.md" --words --lines

Format Text

text-processor format input.txt --uppercase -o output.txt

Real-World Example: Log Analysis

# Step 1: Extract all 500 errors
text-processor extract "/var/log/*.log" "HTTP/1.1 500" -o errors_500.txt

# Step 2: Count unique error patterns
text-processor count errors_500.txt --lines

# Step 3: Replace sensitive data in logs
text-processor replace "/var/log/*.log" "password=[^&]+" "password=[REDACTED]"

Install

npm install -g text-processor-pro

Source Code

Check out the source on GitHub: text-processor-pro

🎪 Visit us: https://www.tucaowall.vip/
⭐ Get free DigitalOcean credit: https://m.do.co/c/fc5cb7b29a0d
🔧 CLI Toolkit Pro - Unified CLI for devs: Buy $9.99

What text processing tasks do you face? Share in the comments!

Introducing CLI Toolkit Pro: 8 CLI Tools in One Package

Bobo — Wed, 10 Jun 2026 17:47:12 +0000

One CLI to Rule Them All

I maintain 8 individual CLI tools (csv-toolkit-pro, json-tidy-pro, batch-image-tool, text-processor-pro, file-batch-toolkit, pdf-toolkit-pro, csv-processing-api-server, creator-automation-bot).

They're all useful individually. But typing 8 different command names is annoying.

CLI Toolkit Pro bundles all of them into one unified interface:

npx cli-toolkit-pro csv merge file1.csv file2.csv
npx cli-toolkit-pro json format data.json
npx cli-toolkit-pro image compress ./photos/
npx cli-toolkit-pro text replace ./logs/ "old" "new"
npx cli-toolkit-pro file rename ./downloads/ --pattern "doc-{n}"
npx cli-toolkit-pro pdf merge doc1.pdf doc2.pdf

What's Inside

Module	Individual Package	CLI Toolkit Command
CSV/Excel	csv-toolkit-pro	`cli-toolkit csv ...`
JSON	json-tidy-pro	`cli-toolkit json ...`
Images	batch-image-tool	`cli-toolkit image ...`
Text	text-processor-pro	`cli-toolkit text ...`
Files	file-batch-toolkit	`cli-toolkit file ...`
PDFs	pdf-toolkit-pro	`cli-toolkit pdf ...`

Installation

npm install -g cli-toolkit-pro

npm package
GitHub repo---

More Resources

🛠️ My tools & open-source projects: GitHub
📝 Blog & updates: TucaoWall
☁️ Deploy your own cloud server and get $25 credit: DigitalOcean
🐙 CLI Toolkit Pro (bundle of all my CLI tools): npm
💼 Hire me on Freelancer: a0982

PDF Operations Without Opening Adobe Acrobat

Bobo — Tue, 09 Jun 2026 16:59:48 +0000

PDFs Don't Need to Be Painful

Need to merge 5 PDFs into one? Split a 200-page document? Extract text from a scanned contract?

Stop opening Adobe Acrobat and waiting 30 seconds for it to load:

npx pdf-toolkit-pro merge doc1.pdf doc2.pdf doc3.pdf -o combined.pdf
npx pdf-toolkit-pro split thick.pdf --pages 1-50
npx pdf-toolkit-pro extract text scanned.pdf -o extracted.txt
npx pdf-toolkit-pro info report.pdf

Features

Merge: Combine multiple PDFs into one
Split: Extract specific pages or ranges
Extract Text: Pull text content (works with OCR-scanned docs too)
Compress: Reduce file size
Metadata: View and edit PDF metadata

npm install -g pdf-toolkit-pro

npm package
GitHub repo---

More Resources

🛠️ My tools & open-source projects: GitHub
📝 Blog & updates: TucaoWall
☁️ Deploy your own cloud server and get $25 credit: DigitalOcean
🐙 CLI Toolkit Pro (bundle of all my CLI tools): npm
💼 Hire me on Freelancer: a0982

PDF Operations Without Opening Adobe Acrobat

Bobo — Tue, 09 Jun 2026 16:54:23 +0000

PDFs Don't Need to Be Painful

Need to merge 5 PDFs into one? Split a 200-page document? Extract text from a scanned contract?

Stop opening Adobe Acrobat and waiting 30 seconds for it to load:

npx pdf-toolkit-pro merge doc1.pdf doc2.pdf doc3.pdf -o combined.pdf
npx pdf-toolkit-pro split thick.pdf --pages 1-50
npx pdf-toolkit-pro extract text scanned.pdf -o extracted.txt
npx pdf-toolkit-pro info report.pdf

Features

Merge: Combine multiple PDFs into one
Split: Extract specific pages or ranges
Extract Text: Pull text content (works with OCR-scanned docs too)
Compress: Reduce file size
Metadata: View and edit PDF metadata

npm install -g pdf-toolkit-pro

npm package
GitHub repo---

More Resources

🛠️ My tools & open-source projects: GitHub
📝 Blog & updates: TucaoWall
☁️ Deploy your own cloud server and get $25 credit: DigitalOcean
🐙 CLI Toolkit Pro (bundle of all my CLI tools): npm
💼 Hire me on Freelancer: a0982

PDF Operations Without Opening Adobe Acrobat

Bobo — Tue, 09 Jun 2026 16:48:44 +0000

PDFs Don't Need to Be Painful

Need to merge 5 PDFs into one? Split a 200-page document? Extract text from a scanned contract?

Stop opening Adobe Acrobat and waiting 30 seconds for it to load:

npx pdf-toolkit-pro merge doc1.pdf doc2.pdf doc3.pdf -o combined.pdf
npx pdf-toolkit-pro split thick.pdf --pages 1-50
npx pdf-toolkit-pro extract text scanned.pdf -o extracted.txt
npx pdf-toolkit-pro info report.pdf

Features

Merge: Combine multiple PDFs into one
Split: Extract specific pages or ranges
Extract Text: Pull text content (works with OCR-scanned docs too)
Compress: Reduce file size
Metadata: View and edit PDF metadata

npm install -g pdf-toolkit-pro

npm package
GitHub repo---

More Resources

🛠️ My tools & open-source projects: GitHub
📝 Blog & updates: TucaoWall
☁️ Deploy your own cloud server and get $25 credit: DigitalOcean
🐙 CLI Toolkit Pro (bundle of all my CLI tools): npm
💼 Hire me on Freelancer: a0982

File Operations at Scale: file-batch-toolkit

Bobo — Mon, 08 Jun 2026 17:13:28 +0000

When "Just Drag It" Doesn't Scale

You download a folder of 200 files named "IMG_20260401_001.jpg" through "IMG_20260401_200.jpg". You need them renamed to "product-001.jpg" through "product-200.jpg".

Do you do it manually? Write a script?

One command:

npx file-batch-toolkit rename ./photos/ --pattern "product-{n}" --start 1
npx file-batch-toolkit organize ./downloads/ --by date
npx file-batch-toolkit deduplicate ./backups/ --hash sha256
npx file-batch-toolkit stats ./projects/ --size --count

Why You Need This

Task	Manual	file-batch-toolkit
Rename 500 files	30 min (F2 spam)	2 seconds
Deduplicate backup folder	"I'll do it later"	3 seconds
Organize by type	20 min	1 second
File statistics	10 min manually	Instant

npm install -g file-batch-toolkit

npm package
GitHub repo---

More Resources

🛠️ My tools & open-source projects: GitHub
📝 Blog & updates: TucaoWall
☁️ Deploy your own cloud server and get $25 credit: DigitalOcean
🐙 CLI Toolkit Pro (bundle of all my CLI tools): npm
💼 Hire me on Freelancer: a0982

DEV Community: Bobo

Validate JSON Like a Pro: Catch Syntax Errors Before They Break Your App

Validate JSON Like a Pro: Catch Syntax Errors Before They Break Your App

Install json-tidy

Validate Single File

Validate Multiple Files

Integrate into Git Hooks

Integrate into CI/CD

Common JSON Errors json-tidy Catches

Install

json-tidy: Stop Manually Formatting JSON Files

JSON Shouldn't Be a Chore

Features

Format & Beautify

Validate

Minify

Convert

Installation

More Resources

How to Convert Excel Files to CSV and JSON Programmatically

How to Convert Excel Files to CSV and JSON Programmatically

Method 1: CLI (Fastest)

Method 2: REST API

Method 3: Programmatic

One-Liner Conversion

Supported Formats

Install

csv-toolkit: The CSV/Excel Swiss Army Knife You Didn't Know You Needed

Why Another CSV Tool?

Quick Start

What It Does

Merge

Clean

Analyze

Convert

Why Use It?

Excel Support

Installation

Links

More Resources

Introducing CLI Toolkit Pro: 8 CLI Tools in One Package

One CLI to Rule Them All

What's Inside

Installation

More Resources

Turn Your CSV Files Into a REST API in 2 Minutes

CSV as a Service

API Endpoints

More Resources

text-processor: The Find-and-Replace Tool That Handles 1000 Files at Once

text-processor: The Find-and-Replace Tool That Handles 1000 Files at Once

Install

Bulk Find and Replace

Extract Lines Matching a Pattern

Count Words and Lines

Format Text

Real-World Example: Log Analysis

Install

Source Code

Introducing CLI Toolkit Pro: 8 CLI Tools in One Package

One CLI to Rule Them All

What's Inside

Installation

More Resources

PDF Operations Without Opening Adobe Acrobat

PDFs Don't Need to Be Painful

Features

More Resources

PDF Operations Without Opening Adobe Acrobat

PDFs Don't Need to Be Painful

Features

More Resources

PDF Operations Without Opening Adobe Acrobat

PDFs Don't Need to Be Painful

Features

More Resources

File Operations at Scale: file-batch-toolkit

When "Just Drag It" Doesn't Scale

Why You Need This

More Resources