The Smart JSON Bridge for Developers
Convert complex, nested JSON to clean Excel/CSV spreadsheets instantly.
Auto-Unescape • Smart Flattening • Privacy-First • 100% Client-Side
Dealing with messy API responses? Complex nested JSON from databases? Double-encoded strings that break everything?
JsonExport solves this:
- Automatically detects and unescapes double/triple-encoded JSON
- Flattens deeply nested structures into spreadsheet-friendly rows
- Optimized for API responses and large files (100MB+)
- 100% client-side - your data never leaves your browser
Automatically handles double or triple-encoded JSON strings without manual intervention.
// Input: "{\"name\":\"John\"}"
// Output: {name: "John"}Converts nested structures to spreadsheet-friendly format using dot notation.
// Input: {user: {address: {city: "NYC"}}}
// Output: {"user.address.city": "NYC"}Custom-built editor optimized for quick conversions with error highlighting and line numbers.
Edit data directly in Flat, Table, or Nested views with full undo/redo support.
Download as CSV, Excel (XLSX), HTML, or all formats in a single ZIP file.
Reorder, hide, and manage columns via intuitive drag & drop interface.
All processing happens in your browser. Zero network calls. No data upload.
- UTM source-aware landing banner for campaign traffic (
utm_source=producthunt,g2,capterra, etc.) - Social proof badges in footer with safe fallback when listing URLs are not configured
- Conversion telemetry events for parse/export plus growth interactions (campaign detect, badge clicks, affiliate toast shown/clicked)
|
|
|
- Converting Stripe API responses to Excel for analysis
- Flattening Shopify webhook data to CSV
- Transforming MongoDB exports to spreadsheets
- Parsing double-encoded JSON strings from legacy systems
- Handling deeply nested objects from REST APIs
- Processing API responses and large JSON exports (100MB+)
- Database export analysis and reporting
- JSON to Excel converter with intelligent auto-unescape
- API response visualization in table format
No installation needed. Works 100% in your browser.
# Clone the repository
git clone https://github.com/theGoodB0rg/json_hub.git
cd json_hub
# Install dependencies
npm install
# Start development server
npm run dev
# Open http://localhost:3000Optional growth link configuration for local testing:
NEXT_PUBLIC_PRODUCT_HUNT_URL=https://www.producthunt.com/products/your-product-slug
NEXT_PUBLIC_G2_URL=https://www.g2.com/products/your-product/reviews
NEXT_PUBLIC_CAPTERRA_URL=https://www.capterra.com/p/your-product-id/- Input JSON: Paste JSON or upload a file (drag & drop supported)
- Auto-Parse: Automatically detects and unescapes encoded strings
- Smart Flatten: Converts nested structures to tabular format
- Edit & Review: Inline editing in your preferred view (Flat/Table/Nested)
- Export: Download as CSV, Excel, HTML, or all in a ZIP
| Category | Technology |
|---|---|
| Framework | Next.js 14 (App Router, Static Export) |
| Language | TypeScript |
| Styling | Tailwind CSS + Shadcn/UI |
| State | Zustand + Zundo (Temporal) |
| Editor | Custom Lightweight |
| Table | TanStack Table v8 + @dnd-kit |
| Export | SheetJS (xlsx), JSZip |
| Testing | Jest + Playwright |
json_hub/
├── app/ # Next.js app directory
│ ├── layout.tsx # Root layout with SEO
│ └── page.tsx # Main converter page
├── components/ # React components
│ ├── JsonEditor/ # Monaco editor wrapper
│ ├── DataGrid/ # Table preview with editing
│ └── ExportMenu/ # Export controls
├── lib/
│ ├── parsers/ # Core parsing logic
│ │ ├── smartParse.ts # JSON validator with auto-unescape
│ │ └── flattener.ts # Nested object flattener
│ ├── converters/ # Export converters
│ │ ├── jsonToCsv.ts
│ │ ├── jsonToXlsx.ts
│ │ ├── jsonToHtml.ts
│ │ └── zipExporter.ts
│ └── store/ # Zustand state management
└── types/ # TypeScript type definitions
# Run unit tests
npm test
# Run tests in watch mode
npm test -- --watch
# Run E2E tests
npm run test:e2e
# Build for production
npm run build- smartParse: 20/20 tests (100%)
- flattener: 21/21 tests (100%)
- converters: 11/12 tests (92%)
- Overall: 52/53 tests (98%)
This repository uses GitHub Actions for automatic deployment:
- Push to
mainbranch - GitHub Actions builds and deploys automatically
- Live at jsonexport.com
Connect your fork to Vercel for instant deployments with preview URLs.
| Feature | JsonExport | Online Converters | Excel Manual |
|---|---|---|---|
| Auto-Unescape | ✓ Automatic | ✗ Manual | ✗ Not possible |
| Privacy | ✓ Client-side | ✓ Local | |
| File Size | ✓ 100MB+ (Streaming) | ✗ Usually 5MB | ✓ Unlimited |
| Inline Editing | ✓ All views | ✗ No editing | ✓ Yes |
| Undo/Redo | ✓ Full history | ✗ None | |
| Cost | ✓ Free | 💰 Often paid | ✓ Free |
Contributions are welcome! Please see CONTRIBUTING.md for guidelines.
- Fork the repository
- Create your feature branch (
git checkout -b feature/AmazingFeature) - Commit your changes (
git commit -m 'Add AmazingFeature') - Push to the branch (
git push origin feature/AmazingFeature) - Open a Pull Request
All processing happens client-side. Your data never leaves your browser. See SECURITY.md for our security policy.
This project is licensed under the MIT License - see the LICENSE file for details.
Built with amazing open-source tools:
- Monaco Editor by Microsoft
- TanStack Table by Tanner Linsley
- TanStack Virtual for virtualization
- @streamparser/json for streaming large files
- SheetJS for Excel export
- Shadcn/UI for beautiful components
json to excel • json to csv • json converter • flatten json • nested json to table • json parser • unescape json • json flattener • api response to spreadsheet • mongodb export to excel • stripe json converter • shopify json to csv
🌐 Live Demo • 📖 Documentation • 🐛 Report Bug • 💡 Request Feature
⭐ Star this repository to support the project!
Made with ❤️ for developers dealing with messy JSON