Database & SQL
Convert strict EJSON between Canonical and Relaxed, with explicit type and precision notices.
Text is processed in this browser. No database connection or document upload.
One strict JSON value. Shell expressions, comments and duplicate keys are rejected.
Unwrapped integers infer Int32/Int64; decimal or exponent tokens infer Double. Ordinary strings remain strings.
Limits: 500,000 UTF-16 input units, depth 100, 50,000 nodes and 2,000,000 output characters.
Input or options changed. Convert before exporting.
A MongoDB EJSON converter helps when an exported document looks like JSON but contains values such as $oid, $date and $numberDecimal. Removing those keys changes what a MongoDB consumer can reconstruct.
Use the example to compare the two output modes. The source stays visible while the result changes; a large sequence number deliberately demonstrates the difference between keeping its digits and keeping its BSON type.
Review representation changes before taking a document into another system.
The MongoDB EJSON converter starts in Canonical mode. Relaxed Extended JSON simplifies finite numbers and eligible dates, while ObjectId and Decimal128 retain their type wrappers. The difference is visible alongside the unchanged source.
A Long such as 9007199254740993 is written from its exact integer token. Relaxed export keeps those digits, with a warning that consumers using JavaScript Number can still round the value.
Paste a document, an array or a single JSON value. Use $oid and $date wrappers instead of ObjectId() and ISODate() expressions.
Canonical Extended JSON retains explicit number types. Switch to Relaxed for readable numbers, then review the precision notices before copying.
Auto conversion waits 350 ms after the last edit. Disable it to expose the convert button, or run the current input with Ctrl/Cmd + Enter.
This Extended JSON converter validates ObjectId, Decimal128, Int32, Int64, Double, dates, Binary, UUID, regular expressions, Timestamp and MinKey/MaxKey. UUID input normalizes to the subtype-04 binary wrapper; regular-expression options are sorted.
Signed 64-bit millisecond strings remain exact in Canonical mode, including dates outside JavaScript’s Date range. Relaxed uses UTC ISO text only between 1970 and 9999; dates outside that interval retain the millisecond wrapper.
Bare integer tokens become Int32 or Int64 according to range; decimal and exponent forms become Double. Double uses binary64 and may round long decimal spellings. Strings that resemble IDs or dates are never guessed into BSON types.
Canonical prioritizes BSON type information by wrapping numbers. Relaxed uses bare finite numbers and readable dates where allowed. Both are valid JSON text; ObjectId, Decimal128 and several other types remain wrapped in both modes.
Only if it is already strict JSON/EJSON text. ObjectId("…"), ISODate("…") and NumberLong("…") are shell expressions and are rejected. Export or stringify the document as Extended JSON first; the tool does not execute pasted code.
Canonical stores the decimal digits inside the string-valued $numberLong wrapper so generic JSON parsers cannot round them prematurely. Relaxed here writes the complete integer token. A receiving application must still use a lossless number parser for unsafe integers.
A JSON number consumed as a JavaScript Number has binary64 precision, not Decimal128 precision. The $numberDecimal string preserves the decimal representation and type. It remains wrapped in Relaxed mode as well.
Only when its contents form one JSON value, such as a JSON array, within the displayed limits. Default line-separated mongoexport documents are not a single JSON value. Convert individual documents or prepare an array with the appropriate export option.
Found an unexpected value?
Return to the MongoDB EJSON converter, choose the target representation and check any precision notice before downloading the result.