Excel-to-JSON

Advanced Features - Unlocking Power of Excel to JSON Pro

Welcome to part 7 of our Excel to JSON series! We’ve covered the basics of Excel to JSON, including the various tools, supported formats, and conversion modes. Today, we’re exploring advanced Pro features that can take your Excel to JSON conversions to the next level.

excel-to-json-toolkit

What Are Pro Features?

Excel to JSON offers a robust free tier that handles most basic conversion needs. However, power users and professionals often need more advanced capabilities. That’s where Pro features come in.

Pro features are designed for users who:

  • Process complex Excel data structures
  • Need fine-grained control over JSON output
  • Require custom data type handling
  • Want to optimize their conversion workflows
  • Prefer an ad-free experience

Pro Feature Overview

Here’s a comprehensive list of all Pro features available across Excel to JSON tools:

1. First Column as Header

Description: Use the first column as headers instead of the first row.

Use Case: When your Excel data is organized with attributes as rows rather than columns.

Example:

Excel:

Attribute John Doe Jane Smith
Name John Jane
Age 25 30
Company WTSolutions Microsoft

JSON (First Row as Header):

1
2
3
4
5
6
7
8
9
10
11
12
[
  {
    "Attribute": "Name",
    "John Doe": "John",
    "Jane Smith": "Jane"
  },
  {
    "Attribute": "Age",
    "John Doe": 25,
    "Jane Smith": 30
  }
]

JSON (First Column as Header - Pro Feature):

1
2
3
4
5
{
  "Name": "John",
  "Age": 25,
  "Company": "WTSolutions"
}

2. Nested Delimiter Customization

Description: Choose from four delimiter options for nested JSON keys.

Options:

  • Dot (.) - Default: student.name
  • Underscore (_): student_name
  • Double Underscore (__): student__name
  • Forward Slash (/): student/name

Use Case: Match your team’s naming conventions or system requirements.

3. Empty Cell Handling

Description: Control how empty cells in Excel are handled in JSON output.

Options:

  • Empty String: Converts to "" (default)
  • JSON Null: Converts to null
  • Exclude: Removes empty cells from JSON

Example:

Excel:

Name Age
John 25
Jane

Empty String:

1
2
3
4
5
6
7
8
9
10
[
  {
    "Name": "John",
    "Age": 25
  },
  {
    "Name": "Jane",
    "Age": ""
  }
]

JSON Null:

1
2
3
4
5
6
7
8
9
10
[
  {
    "Name": "John",
    "Age": 25
  },
  {
    "Name": "Jane",
    "Age": null
  }
]

Exclude:

1
2
3
4
5
6
7
8
9
[
  {
    "Name": "John",
    "Age": 25
  },
  {
    "Name": "Jane"
  }
]

4. Boolean Format

Description: Choose how boolean values (TRUE/FALSE) are converted to JSON.

Options:

  • JSON true/false: Converts to true or false (default)
  • String “true”/“false”: Converts to "true" or "false"
  • Number 1/0: Converts to 1 or 0

Example:

Excel:

Name IsStudent
John Doe TRUE
Jane Smith FALSE

JSON true/false:

1
2
3
4
5
6
7
8
9
10
[
  {
    "Name": "John Doe",
    "IsStudent": true
  },
  {
    "Name": "Jane Smith",
    "IsStudent": false
  }
]

String “true”/“false”:

1
2
3
4
5
6
7
8
9
10
[
  {
    "Name": "John Doe",
    "IsStudent": "true"
  },
  {
    "Name": "Jane Smith",
    "IsStudent": "false"
  }
]

Number 1/0:

1
2
3
4
5
6
7
8
9
10
[
  {
    "Name": "John Doe",
    "IsStudent": 1
  },
  {
    "Name": "Jane Smith",
    "IsStudent": 0
  }
]

5. Date Format

Description: Control how date values in Excel are converted to JSON.

Options:

  • Number of Days from 1900-01-01: Converts to days since 1900-01-01
  • String, ISO 8601: Converts to ISO 8601 formatted string

Use Case: When you need dates in a specific format for APIs or databases.

Example:

Excel:

Name Birthday
John Doe 1995-05-15

Number of Days:

1
2
3
4
{
  "Name": "John Doe",
  "Birthday": 34834
}

ISO 8601 String:

1
2
3
4
{
  "Name": "John Doe",
  "Birthday": "1995-05-15T00:00:00.000Z"
}

Note: To use ISO 8601 format, add $date$ suffix to your column header:

Birthday$date$
1995-05-15

6. JSON Output Format

Description: Choose the overall structure of the JSON output.

Options:

  • Array of Object: Default - array of objects [{...}, {...}]
  • 2D Array: Two-dimensional array [[headers], [row1], [row2]]

Use Case: When your target system expects a specific JSON structure.

Example:

Excel:

Name Age Company
John 25 WTSolutions

Array of Object:

1
2
3
4
5
6
7
[
  {
    "Name": "John",
    "Age": 25,
    "Company": "WTSolutions"
  }
]

2D Array:

1
2
3
4
[
  ["Name", "Age", "Company"],
  ["John", 25, "WTSolutions"]
]

7. Single Object JSON Format

Description: Control how single-row Excel data is converted.

Options:

  • Array: Keep as array of one object [{...}] (default)
  • Object: Convert to single object {...}

Use Case: When you have only one data row and want a single JSON object.

Example:

Excel:

Name Age
John 25

Array:

1
2
3
4
5
6
[
  {
    "Name": "John",
    "Age": 25
  }
]

Object:

1
2
3
4
{
  "Name": "John",
  "Age": 25
}

8. Custom Filename

Description: Specify a custom filename for your JSON output file.

Use Case: When you need to follow specific naming conventions for your organization.

Requirements:

  • Maximum length: 200 characters (excluding extension)
  • File extension will be automatically set to .json
  • Cannot start or end with dots (.) or spaces
  • Cannot use Windows reserved names (e.g., CON, PRN, AUX, etc.)
  • Cannot contain characters: < > : \ / | ? *

Examples:

  • Valid: data.json, my_data.json, export_2024.json
  • Invalid: .data.json, con.json, my:data.json

9. No Ads

Description: Enjoy a distraction-free experience without advertisements.

Benefits:

  • Professional environment for client presentations
  • Faster workflow without waiting for ads
  • Better focus on your data
  • Cleaner interface

Pro Code Explained

What is a Pro Code?

Your Pro Code is simply the email address you used during the checkout process when you subscribed to Excel to JSON. This code:

  • Unlocks all Pro features
  • Works across all Excel to JSON tools
  • Is valid for both Excel to JSON and JSON to Excel products
  • Can be used on up to 10 devices

Where to Enter Your Pro Code

You’ll enter your Pro Code in the conversion settings when using:

  • Web App
  • Excel Add-in
  • WPS Add-in
  • API (in the options parameter)

Pricing and Subscription

Subscription Options

Excel to JSON offers flexible subscription plans:

Billing Cycle Price (USD) Value
Monthly $2.66/month Flexibility
Quarterly $3.66/quarter 15% savings
Half-Yearly $4.99/half-year 25% savings
Yearly $5.99/year Best value

7-Day Free Trial

All plans include a 7-day free trial:

  • Full access to all Pro features
  • No credit card required to start
  • Cancel anytime before day 7 at no charge

What’s Included

Each Pro Code gives you:

  • Access to Pro features on 10 devices
  • Both Excel to JSON and JSON to Excel tools
  • All platforms: Web App, Excel Add-in, WPS Add-in, API, MCP

Payment Methods

Accepted through Paddle:

  • Credit/Debit Cards (Visa, Mastercard, Amex, etc.)
  • PayPal
  • Apple Pay (Apple devices)
  • Google Pay (Android devices)
  • Various local payment methods

Feature Comparison

Free vs Pro Features

Feature Free Pro
Basic Excel to JSON conversion ✅ ✅
Flat JSON Mode ✅ ✅
Nested JSON Mode ✅ ✅
Copy and paste Excel data ✅ ✅
Load Excel files ✅ ✅
First row as header ✅ ✅
First column as header ❌ ✅
Custom nested delimiters ❌ ✅
Empty cell handling (null/exclude) ❌ ✅
Boolean format (string/number) ❌ ✅
Date format (ISO 8601) ❌ ✅
JSON output format (2D Array) ❌ ✅
Single object JSON format ❌ ✅
Custom filename ❌ ✅
No ads ❌ ✅

Getting Started with Pro Features

Step 1: Start Your Free Trial

  1. Visit pricing page
  2. Choose your preferred billing cycle
  3. Start your 7-day free trial
  4. Receive your Pro Code (your email)

Step 2: Enter Your Pro Code

  1. Open Excel to JSON (Web App, Excel Add-in, or WPS Add-in)
  2. Locate Pro Code field in conversion settings
  3. Enter your email address as Pro Code
  4. Pro features are now unlocked

Step 3: Explore Pro Features

Try out advanced features:

  • Use first column as header for transposed data
  • Experiment with different delimiters
  • Set boolean format to match your API requirements
  • Use date format for ISO 8601 compatibility
  • Choose JSON output format for your target system
  • Customize filenames for organization

Pro Tips for Power Users

Tip 1: Create Conversion Templates

Save your preferred settings as templates:

  • Document your standard delimiter choice
  • Note your typical boolean format
  • Create workflows for common conversion scenarios
  • Standardize filename conventions

Tip 2: Automate with Pro Features

For recurring tasks:

  • Organize files in consistent folders
  • Use custom filenames for versioning
  • Set appropriate empty cell handling
  • Choose JSON format that matches your systems

Tip 3: Leverage Conversion Reports

Use conversion results for:

  • Quality control
  • Error tracking
  • Process documentation
  • Compliance requirements

Tip 4: Optimize for Your Workflow

Customize settings based on your needs:

  • Choose delimiters that match your team’s conventions
  • Set boolean format to match your API requirements
  • Use date format for database compatibility
  • Select JSON output format for your target system

ROI Calculation

Let’s calculate the return on investment for Pro features:

Time Savings Scenario

Without Pro:

  • Manually formatting JSON: 10 minutes per conversion
  • Fixing data type issues: 5 minutes per conversion
  • 10 conversions per day
  • Total: 150 minutes (2.5 hours) per day

With Pro:

  • One-click conversion with Pro settings: 1 minute per conversion
  • No data type issues: 0 minutes
  • 10 conversions per day
  • Total: 10 minutes per day

Daily Time Saved: 140 minutes (2.3 hours)
Monthly Time Saved: 69 hours
Yearly Time Saved: 828 hours

At a typical hourly rate of $50/hour:
Yearly Value: $41,400
Yearly Cost: $5.99 (Pro subscription)
ROI: 691,152%

Next Steps

Now that you understand the power of Pro features, you’re ready to explore programmatic access. In our next post, we’ll cover the Excel to JSON API, which allows developers to integrate Excel to JSON functionality into their applications and workflows.

Ready to unlock Pro features? Start your 7-day free trial today and experience the full power of Excel to JSON!

微信二维码
Share