JsonToolsNppPlugin

Miscellaneous tools for working with JSON in Notepad++. Includes a general-purpose tree view with powerful search capabilities.

If you have any issues, see if updating to the latest release helps, and then feel free to raise an issue on GitHub. Please be sure to include diagnostic information about your system, Notepad++ version, and plugin version (go to ?->Debug Info... from the Notepad++ main menu).

Features

1. Pretty-print JSON so that it's spread out over multiple lines.
2. Compress JSON so that it has little or no unnecessary whitespace.
3. Open a drop-down tree view of the document. Selecting a node in the tree navigates to the corresponding line in the document.
4. Able to parse documents that have many different syntax errors, including but not limited to:
   • The full JSON5 specification
   • Python-style comments
   • Missing commas and colons
   • Unterminated strings, arrays, and objects
5. Get the path to the current position
6. Query and edit JSON with:
   • a find/replace form
   • an array sorting form
   • the RemesPath query language.
7. A regex search form for viewing and editing CSV files, or doing find/replace operations that involve math.
8. Parse JSON Lines documents.
9. A form for gettting JSON from APIs or many different local files.
10. JSON schema validation, including automatic validation based on filenames.
11. Generation of random JSON
12. Generation of JSON schema from JSON
13. Automatic error checking after editing
14. Select all JSON in a non-JSON file
15. Quickly convert between JSON strings and raw text

Read the docs.

View past changes.

Downloads and Installation

Go to the Releases page to see past releases.

Download latest 32-bit version

You can unzip the 32-bit download to .\Program Files (x86)\Notepad++\plugins\JsonTools\JsonTools.dll.

Download latest 64-bit version

You can unzip the 64-bit download to C:\Program Files\Notepad++\plugins\JsonTools\JsonTools.dll.

Alternatively, you can follow these installation instructions to install the latest version of the plugin from Notepad++.

Downloading unreleased versions

You can also download recently committed but unreleased versions of JsonTools by downloading the appropriate GitHub artifact in the following way:

1. Go to the commit history of JsonTools.
2. Most commits will have a green checkmark and the text 4/4 next to their commit message. Click on it.
3. A dropdown menu showing the CI tasks will appear. Click on one of the Details links. Here's an example of a page that this leads to..
4. Click the Summary link near the top-left corner of the page. Here's an example of the page this leads to.
5. If you chose a commit that was made in the last 90 days, at the bottom of this page you will find links to download plugin_dll_x64 (a zip archive containing 64-bit JsonTools.dll) or plugin_dll_x86 (a zip archive containing 32-bit JsonTools.dll). Download the appropriate binary for your current Notepad++ installation.

If you also want to download the most recent translation to another language, you will need to also download the most up-to-date translation file for that language from the translation folder of this repo. To do that:

1. Click on one of the files in the list.
2. Click the download icon near the top of the page.
3. Put the downloaded raw {yourLanguage}.json5 file into the translation folder of your JsonTools plugin directory, as discussed in the documentation on translating JsonTools.

System Requirements

Every version of the plugin works on Notepad++ 8.4.1 onward, although some versions of Notepad++ have problems.

Versions of the plugin from 4.10.0.3 onward are compatible with older Notepad++ (tested for 7.3.3, may be compatible with even older).

Every version up to and including 3.7.2.1 should work natively on Windows 8 or later (note: this is untested), or you must install .NET Framework 4.0. Every version beginning with 4.0.0 works on Windows 10 May 2019 update or later, or you must install .NET Framework 4.8.

Problematic Notepad++ versions

This is not a complete list of known issues with JsonTools. For that, see the issue tracker and the Changelog. This is a list of issues that emerged in recent versions of Notepad++.

• Ctrl+C and Ctrl+X do not work inside of forms for all versions of JsonTools earlier than v7.0.0 on the following Notepad++ versions:
  • Notepad++ 8.6 and 8.6.1
  • Notepad++ 8.6.2 onward, when the new Notepad++ setting Enable Copy/Cut Line without selection is turned off.
• Using the Notepad++ find/replace form can cause problems with remembered selections, and may cause issues with RemesPath queries,under the following circumstances:
  • Notepad++ 8.6.3 and 8.6.4, for all versions of JsonTools.
  • Notepad++ 8.6.5, for JsonTools earlier than v7.1.0.

Alternative tools

Notepad++

This plugin may consume huge amounts of memory when working with really huge JSON files (say 50+ megabytes). As of version 0.3.0, my HugeFiles plugin can break a JSON file up into chunks such that every chunk is syntactically valid JSON. This way you don't need to read the entire file into the text editor, and you can look at one chunk at a time. You can also use this plugin to perform simple find/replace operations on the entire file (maybe eventually allowing control over which sections of the file to edit). Finally, the plugin allows a very large JSON file to be broken up into separate syntactically valid JSON files, which may be easier to use.

JSMinNPP is a reasonable alternative, although as of v5.0.0, JsonTools has comparable performance and parsing ability.

While not a JSON plugin per se, PythonScript enables Notepad++ users to customize the editor with Python scripts. Since Python has an excellent native JSON library, you could easily use this plugin to create custom scripts for working with JSON.

Because Python has good 3rd-party packages for working with YAML and TOML (two good alternatives to JSON), PythonScript could potentially be used to allow this package to work with YAML and TOML.

VSCode

Visual Studio Code has native support for JSON with comments. Just go down to where the language is listed in the right side of the taskbar, and select JSON with Comments from the drop-down menu that appears at the top of the screen.

VSCode also has a built-in JSON tree viewer and some support for searching for keys and indices in JSON.

VSCode has many useful tools for working with JSON Schema. VSCode's JSON Schema validation is much more robust than what this plugin currently offers. You can also configure the editor to automatically use a certain JSON schema to validate JSON with a certain file path. For example, you could configure the editor to always parse files with names like *tweet*.json with the schema tweet_schema.json. Note: as of version 4.11, a similar feature exists in this plugin.

The JSON Tools plugin provides the same pretty-print and minify functionalities as this plugin.

Finally, the Encode/Decode plugin allows fast interconversion of YAML and JSON, among other things.

Emacs

Consult this list. One Emacs plugin, JSON mode, inspired the Path to current line feature of this plugin.

Python

Python's standard library JSON module is excellent, albeit limited to syntactically correct JSON according to the original JSON standard.

Python's package ecosystem is incredibly rich, so I can't possibly list all the useful tools here. Three that I've enjoyed working with are:

1. Pandas. The Python tool for working with pretty much any kind of data. 'Nuff said.
2. GenSON. A really user-friendly tool for JSON schema generation. Includes a CLI tool for JSON schema generation and a programmatic API. Has some tools for, e.g., merging two schemas, but I haven't used those tools as much.
3. DeepDiff. This is super cool! It allows fast (and I mean REALLY FAST) comparison of two JSON documents to find how they differ. For instance, DeepDiff would correctly show that

   {"a": [1, 2, {"b": [3, 4]}]}

   and

   {"a": [1, 2, {"b": [4, 4]}]}

   differ in that the first element of root['a'][2]['b'] was changed from 3 to 4.

Websites

This website offers (limited) JSON->CSV conversion, pretty-printing (appears to use the same algorithm as me), minifying, JSON->XML conversion, and a pretty good tree viewer.

I expect you could find plenty of other good websites if you did some research.

Translating JsonTools to another language

If you are interested in helping users of JsonTools who don't speak English, JsonTools can be translated to other languages beginning in v8.0.

JsonTools infers your preferred language and attempts to translate in the following way:

1. JsonTools looks up your current culture (which can be checked using the get-culture command in Powershell).
2. Next, we find the EnglishName property of the current culture (which can be found by the $foo = get-culture; $foo.EnglishName command in Powershell), take the first word, and convert it to lowercase. Call this lowerEnglishCulture.
   • Example: the EnglishName of the en-us culture is English (United States), so lowerEnglishCulture is english
   • Example: the EnglishName of the it-it culture is Italian (Italy), so lowerEnglishCulture is italian
3. JsonTools then does one of the following:
   • If lowerEnglishName is english, it does nothing (because JsonTools is naturally in English)
   • Otherwise, it looks in the translation subdirectory of the JsonTools plugin folder (where JsonTools.dll lives) for a file named {lowerEnglishName}.json5
   • NOTE: because the translation files are in a subdirectory of the plugin folder, translation does not work for versions of Notepad++ older than version 8, since those older versions do not have separate folders for each plugin.
4. If JsonTools found translation\{lowerEnglishName}.json5, it attempts to parse the file. If parsing fails, a message box will appear warning the user of this.
   • If no translation file was found, or if parsing failed, the default English will be used.
5. If parsing was successful, JsonTools will use the translation file as described below.

To be clear, JsonTools may not be in the same language of the Notepad++ UI, and I do not plan to change that.

To translate JsonTools to another language, just look at english.json5 in the translations directory of this repo and follow the instructions in that file.

Currently JsonTools has been translated into the following languages:

• English (obviously)
• Italian

The following aspects of JsonTools can be translated:

• Forms (including all controls and items in drop-down menus)
• Items in the JsonTools sub-menu of the Notepad++ Plugins menu
• The descriptions of settings in the JsonTools.ini config file
• The descriptions of settings in the settings form (only for versions since v8.1)

The following aspects of JsonTools will not be translated:

• This documentation
• Message boxes (includes warnings, errors, requests for confirmation)
• Generic modal dialogs (for example, file-opening dialogs, directory selection dialogs)

Acknowledgments

• Kasper B. Graverson for creating the plugin pack that this is based on.
• Bas de Reuver for making the excellent CSVLint plugin that I've consulted extensively in writing the code.
• jokedst for making the CsvQuery plugin to which I owe the original ideas behind my settings form and my adaptive styling of forms.
• Everyone who took the time to raise issues and help improve the plugin, especially vinsworldcom.
• And of course, Don Ho for creating Notepad++!

Note on how JsonTools sorts strings

JsonTools sorts strings more or less the same way as other Windows applications like Microsoft Word, while Notepad++ sorts strings based on Unicode code points. This is more intuitive in some cases, and less intuitive in others.

The list below shows which things in JsonTools are case-sensitive and which are case-insensitive.

Case-sensitive sorters:

• sorted and sort_by RemesPath functions
• sort form using Sort method = Default.
• anything else in RemesPath that sorts things, unless specifically noted otherwise.

Case-insensitive sorters:

• sorting of object keys when the sort_keys global setting is true
• sorting of object keys when the sort_keys argument to the stringify RemesPath function is true
• sort form using Sort method = As strings (ignoring case)

Consider this input: ["1","-2","3","o","P","ö","p"]

JsonTools case-sensitive order:

["1","-2","3","o","ö","p","P"]

JsonTools case-insensitive order:

["1","-2","3","o","ö","P","p"] (the order of the P and the p is unstable)

Notepad++ case-sensitive order:

["-2","1","3","P","o","p","ö"]

Notepad++ case-insensitive order:

["-2","1","3","o","P","p","ö"] (the order of the P and the p is unstable)

A summary of some major differences between Notepad++ and JsonTools in string sorting:

1. The sort form ignores the leading minus sign when ordering the numbers; Notepad++ does not.
2. The sort form orders ö between o and p (because culturally that makes sense), but Notepad++ puts ö last, because it compares the strings by Unicode code points, and non-ASCII characters like ö come after all ASCII characters.
3. In case-sensitive sorts, JsonTools puts upper-case letters after lower-case letters, but Notepad++ does the opposite.
4. In all sorts, JsonTools respects alphabetical order (e.g., P comes after o whether case-sensitive or not), but Notepad++ puts all upper-case letters before all lower-case letters when in case-sensitive mode.

There are many, many rules for string comparison (and I know very few of them), and I cannot possibly cover them all here. But hopefully this warning will help you not get caught off guard.