JSONL to Excel Converter
Convert JSONL (JSON Lines) to Excel (.xlsx) format instantly. Automatically extracts columns from JSON keys. 100% client-side.
Input JSONL
Drop a .jsonl file here, or click to browse
Supports .jsonl, .ndjson, .json, .txt
Input JSONL
Drop a .jsonl file here, or click to browse
Supports .jsonl, .ndjson, .json, .txt
Output Excel
Paste or drop JSONL content to convert
How to Convert JSONL to Excel
JSONL to Excel conversion extracts all unique keys from your JSON objects and uses them as Excel column headers. Each JSON object becomes one row in the spreadsheet.
Nested objects are flattened using dot notation. For example, {"address":{"city":"NYC"}'} becomes a column named "address.city". Arrays are serialized as JSON strings in the Excel cell.
Our converter handles mixed schemas gracefully. If different JSONL lines have different keys, all unique keys are collected as columns, and missing values are left empty.
Excel 的硬性上限 —— 转换前先核对
Excel 不是数据库，它的文件格式有实打实的天花板（见微软官方规格与限制文档）。下面每一条都曾悄无声息地毁掉过别人的导出；转换前请逐条对照您的数据：
- 每个工作表 1,048,576 行
- .xlsx 的行数上限。记录数超过它的 JSONL 文件放不进一个工作表 —— 请先拆分（JSONL 拆分器的按行模式设 1,000,000 行一块，正好对应一个文件一个工作表）。
- 每个工作表 16,384 列
- 比想象中更容易触到：展平含有大量索引展开数组的 JSONL 时，每个数组槽位都可能生成一列。如果展平后的宽度爆炸，请先换一种数组处理策略再导出。
- 每个单元格 32,767 个字符
- 更长的字符串会在打开时被截断。常见肇事者是嵌入的大块内容（堆栈跟踪、HTML、base64 数据）—— 把它们留在 JSONL 源文件里，导出一个引用或截断的预览即可。
- 数字只有 15 位有效数字
- Excel 用 64 位浮点数存储数字：第 16 位起全部变成零。像 9007199254740993 这样的雪花 ID 会在毫无警告的情况下损坏。ID 列请按文本导出 —— 损坏的标识符是这类 bug 里代价最高的一种，因为 join 会静默地不再匹配。
- 打开时的自动类型转换
- 仅仅长得像日期的值会被改写：字符串 2024-03 打开后变成 2024 年 3 月，基因符号 MARCH1 曾在已发表的研究数据集里被改成日期，广为人知。对受影响的列设置文本格式是唯一可靠的防线。
在损坏发生前看到它
一条同时触发两个限制的记录
{"order_id": 9007199254740993, "batch": "2024-03", "total": 129.5}
如果不加处理直接导出，order_id 会因浮点舍入丢掉最后一位，batch 会变成日期。本工具在检测到这类风险模式时会把这两列都写成文本 —— 您在 Excel 里看到的数字就是数据里原本的数字。
What is JSONL to Excel Conversion?
JSONL to Excel conversion transforms newline-delimited JSON objects into a native Excel spreadsheet (.xlsx) that Microsoft Excel, Google Sheets, and LibreOffice Calc can open directly. Each JSON key becomes a column header, and each line becomes a row with proper cell formatting.
Unlike CSV, Excel files support multiple data types, cell formatting, and larger datasets without delimiter conflicts. This makes JSONL to Excel conversion ideal for data analysts and business users who need to work with structured data in spreadsheet applications.
Common Use Cases
Business Reporting
Convert JSONL data exports to Excel for creating pivot tables, charts, and business intelligence reports.
Database Export Analysis
Transform JSONL database exports into Excel for data exploration with sorting, filtering, and conditional formatting.
Stakeholder Data Sharing
Convert JSONL datasets to Excel for sharing with non-technical stakeholders who prefer native spreadsheet formats.
Financial Data Processing
Transform JSONL transaction logs and financial data into Excel for accounting, auditing, and compliance workflows.
ML Dataset Review
Convert machine learning training datasets from JSONL to Excel for manual review, annotation, and quality assurance.
API Log Analysis
Transform JSONL API logs into Excel spreadsheets for trend analysis, error rate tracking, and performance monitoring.
Common Errors & Solutions
Inconsistent Keys Across JSONL Lines
When JSONL records have different sets of keys, the Excel output will have columns for every unique key. Missing values in rows that lack a key are left as empty cells. This is expected behavior, not an error.
Deeply Nested Objects Produce Long Column Names
Objects nested several levels deep are flattened with dot notation, resulting in long column headers like "user.address.geo.lat". Consider using the Flatten JSON tool first if you need more control over the flattening depth.
Large Files May Take Longer
Excel file generation requires collecting all data in memory before creating the spreadsheet. Very large JSONL files (100MB+) may take several seconds to process. For extremely large datasets, consider using JSONL to CSV conversion instead.
Frequently Asked Questions
JSONL 转 Excel 转换器如何检测列？
Nested objects are flattened with dot notation. For example, {"user":{"name":"Alice"}'} becomes a column "user.name" with value "Alice". Arrays are kept as JSON strings in the cell.
嵌套 JSON 对象在 Excel 输出中会被展平吗？
All unique keys across all lines are collected as Excel columns. If a line is missing a key, the corresponding cell is left empty.
这个 JSONL 转 Excel 转换器会上传我的数据吗？
Yes. All conversion happens locally in your browser. No data is sent to any server. Your JSONL content never leaves your device.
可以用这个工具将 NDJSON 文件转换为 Excel 吗？
Not directly with this tool, but you can export your Excel file as CSV and then use our CSV to JSONL converter to transform it into JSONL format.
JSONL 转 Excel 单元格中数组如何呈现？
CSV is a plain text format that can have issues with commas in values and lacks cell formatting. Excel (.xlsx) is a binary format that natively handles special characters, supports multiple data types, and preserves column widths. Choose Excel when you need to work in spreadsheet applications.
如何将 Excel 转回 JSONL？
Yes. The generated .xlsx file is compatible with Microsoft Excel, Google Sheets, LibreOffice Calc, and other spreadsheet applications that support the Open XML format.
Excel 输出有行数限制吗？
There is no hard row limit in the converter. However, Excel itself has a maximum of 1,048,576 rows per sheet. For most JSONL files, this limit will not be an issue. The converter handles files with hundreds of thousands of lines.
Excel 文件是否包含自动筛选和列宽调整？
Manual import requires parsing JSON in Excel using Power Query or VBA scripts. Our converter handles all parsing, flattening, and column extraction automatically, producing a ready-to-use Excel file in seconds.