How to Convert JSON to Excel - Nested JSON, NDJSON & GST

Short summary

JavaScript's Number.MAX_SAFE_INTEGER silently truncates large integers (64-bit IDs, GST invoice numbers) during JSON parsing. Most JSON-to-Excel converters fail to handle leading zeros, formula injection, and timezone shifts. Test converters with 3-point validation: preserve large IDs as text, keep leading zeros, maintain numeric values for math.

• •JavaScript's IEEE-754 precision (2^53−1) silently truncates large IDs and GST invoice numbers
• •Leading zeros vanish, formula injection becomes a security vector, dates shift timezones
• •Validate converters: preserve 19-digit IDs as text, protect leading zeros, keep clean numbers numeric

Generated with AI, which can make mistakes.