Excel to key-value JSON
Turn two columns of an xlsx sheet into flat key-value JSON: pick the key and value column indexes, optionally skip the header row, and rows with an empty key are skipped and counted. Parsing runs in Rust-compiled WebAssembly.
Runs in your browserEvery computation happens in your browser — your data never leaves this device.
xlsx base64
Key-value JSON
A flat JSON object as text; numeric values stay numbers.
Loading the parser module…
Paste the xlsx base64 to start converting
Pairs: 0 · Skipped: 0
What this tool does
- Turn a two-column settings sheet into a JSON constant.
- Build a key map from an exported parameter table.
- Spot rows whose key is empty via the skipped count.
Example
Input
UEsDBBQAAAAIAAAAIQCWWBSuHgEAALACAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sjdJLasMwEAbgvU5hZt8ozqOUIiu0hJ6gPcDUnsTCeiEpdnL7UqeNK0OgWgn++T8tRmJ3NrroKUTlbAXlYgkF2do1yh4r+Hh/e3iCIia0DWpnqYILRdhJJgYXutgSpeJstI0VtCn5Z85j3ZLBuHCe7NnogwsGU1y4cOTRB8JmLBnNV8vlIzeoLLDi54zSc/iP5Q4HVdPe1SdDNl2xQBqTcja2ykeQN5aJ8c09JpRMBDcUoYISJBP19+2lhCJVEFMAKXrZ0UXwXgpey2v+muc96hP9TjDBgxsmdTWpq6xl0dCMzQcCGQzdPXc9ueushtq3OIPXY1LeszaTtcmsT0pzKh9Ig7uHbid0m3VmYB7GTnlPzRxlgv/dGL/9Ncm+AFBLAwQUAAAACAAAACEAfGJbUKoBAADdBQAAEwAAAFtDb250ZW50X1R5cGVzXS54bWy1lM1u2zAQhO95CoHXQKScAkURWMkhTU/9CZAU6HVNri3C5JLgMrb89oWo2HGB1HZQdw/SQZydb4cip7e9d9UKE9tArZjIRlRIOhhLi1b8fPpSfxIVZyADLhC2YoMsbm8upk+biFz13hG3oss5XivFukMPLENE6r2bh+QhswxpoSLoJSxQXTXNR6UDZaRc56GHGJtc92x2jdbrtVx/KMKrppmoX9++Ppbe4qIaa6uxxzW1pWEAjeKmqKefcQ7PLlf3fUYa5+69E9XdiDVM1gqI0VkN2QZSw1f1d/HM0gHxioz0XGOv0UnuELOcWYK0kR50CvcEM4dGerB0yCSh4yMuf8Zev0QuE7qyhjsb+XJ/lh8rTMkarB4g5e/gsRWqd2od0nIWwlIOa7eBv9R7AMJ8bjWaoJ89UpYcE4IpCfhtEsPU+0ivdQiuaFmV1+QtyjOz7jxPSS936HF8jmz/wlHanOLKeeOQ/++OFYuTYDpIaB5zsrQYmc753+z1Pgpjgn5IIbLSIeH7SbZHaFDXMYWIKdsTMtjZQoxn3hMcrgSD5g2cqSqX8utJ+g1QSwMEFAAAAAgAAAAhAMyQ6hjnAAAAWAIAAAsAAABfcmVscy8ucmVsc63Sz0oDMRDH8XufIsy9m20FEWnaSxF6E1kfYExm/7BJJiSjpm8viKgVLYLO+ceXz2E2uxq8eqJcJo4GVk0LiqJlN8XBwH13s7wCVQSjQ8+RDBypwG672NyRR5k4lnFKRdXgYzEwiqRrrYsdKWBpOFGswfecA0ppOA86oZ1xIL1u20udPzfgS1QdnIF8cGtQ3THR3+I6kKBDQW050zJlTpRlogKqwzyQGHBsbzOn8rpoavCgfxBd/F7EfT9Z2rN9DBTlOxhVoejInTdhSmdJq/8knS4+NNXrZ87zA/P8jtEnf7BdqLd7AVBLAwQUAAAACAAAACEAY3OPKC0BAADYAgAAEAAAAGRvY1Byb3BzL2FwcC54bWydUl1LwzAUfd+vCHnfso0hMtIOQUR8cbCpzzG9XYNpEnKvpfPXS9utW6eimMdzk/N1I1d1aVkFEY13CZ9NppyB0z4zbpfwp+3d+JozJOUyZb2DhO8B+SodyXX0ASIZQFaX1mHCC6KwFAJ1AaXCiQ/g6tLmPpaKcOLjTvg8NxpuvX4vwZGYT6dXAmoCl0E2Dj0hH7Gz07IvK/qvQOZ14xWft/sAyNOWXN6EYI1WZLxLNwUAPWykOAe7a/egmibWykTsoBauaFmBJh8Zmg9I+JyzV4XQKCS8UtEoRwelwZtuMhwchzYgxfTFxzds/KAUPTgkEj8x/SphFumsfW4Wf+Hs0DbnoQ7xtQ+5NWQBH/O1inTELvuZnffTZjruoc/YL2GY+hsPF4JSnL7iyfsnUEsDBBQAAAAIAAAAIQA8yE301gAAAIgBAAARAAAAZG9jUHJvcHMvY29yZS54bWx9kEtLAzEUhff9FSH7yc1UEBk67c6VgqCC25Bcp8G8yL06038vHWk2LZ7teXxwdoclBvGDlXxOo+yVlgKTzc6naZTvb4/dgxTEJjkTcsJRnpDkYb/Z2TLYXPGl5oKVPZJYYkg02DLKI3MZAMgeMRpSuWBaYvjMNRomlesExdgvMyFstb6HiGycYQPnwa60RbkR1/qjONso5buGddNZwIARExP0qgfZsow10s3C6sC/oOj5VPBm+2I21EK+Bed5VvPdGt1q3cPH89Prekjn0/lQixL2DfwLUEsDBBQAAAAIAAAAIQAkoEte4gEAAOAFAAANAAAAeGwvc3R5bGVzLnhtbLVUy27bMBC85ysI3mNZQlq0gZQcUhjooUGAuEWulLSyCSy5ArkypH59oZf1sAO0aOvTcHc4sw9T8WNtUJzAeU02keFmKwXYjHJtD4n8vt/dfpLCs7K5QrKQyAa8fHy4iT03CK9HABa1QesTeWQu74PAZ0cwym+oBFsbLMgZxX5D7hD40oHKfXvJYBBttx8Do7SVN2L269TuT/w7glQUOoMvlFUGLPeKOWUvjkr/Y9+U4OVDJx4XZNmLjCrLiQyH6DkzHbuQ/ylOChMZRjJYpTJCcoKPYKDVWaetMtDffVKoU6cvGIUyGpuecynf9TooGG3JzRlxMNXaYz92pxHP3UWL7jTiyqNUzODsTiOKAbejSqQlCyu/xe0/Ejs41YTRh/f0ejzWn5LLwV3fT59b2SIUvJ6d04fjRZCpXIdSYiazjuZaHcgqXNQ79x5PY80ZIL62j+CtuF54XQhbmZ3hr3kit1K0CxuhRhxgL9ofBu84mGvP7GZO0d85iboYgCpLbJ4rk4LbdS9r9bdeiod3/1M9iv6dej/Et8X8upFeX9Y5LdonnMjnVg9nXmmlkbV9b1GjTV5PO5p4rFKEpftWihwKVSHvz8lETvgb5Loyn8+sF30iHlgT7ll3rVEcTJ/kqbFfUEsDBBQAAAAIAAAAIQBBeUFiiAAAAKcAAAAUAAAAeGwvc2hhcmVkU3RyaW5ncy54bWw1xzEOwjAMAMCdV1jeaQIDQqhpByReAA+IWtNGSuwSu6j8ngVuu7bfSoY3VU3CAQ+NRyAeZEw8BXzcb/szglrkMWZhCvghxb7bwU+rarCVzBpwNlsuzukwU4nayEK8lfyUWqJpI3VyulSKo85EVrI7en9yJSZGGGRlC+gRVk6vla7/d61Tte4LUEsDBBQAAAAIAAAAIQAWRkQ71gAAAE8BAAAPAAAAeGwvd29ya2Jvb2sueG1sjY7BTsMwEETv+YrV3omTghBUcXpBSBUXDsDdxJvGqr0beQ2Ev0c0pWdOo9XsvJlut6QIn5Q1CFts6waBeBAf+GDx9eXx6g5Bi2PvojBZ/CbFXV91X5KP7yJHWFJktTiVMm+N0WGi5LSWmXhJcZScXNFa8sHonMl5nYhKimbTNLcmucC4Erb5PwwZxzDQgwwfibiskEzRlSCsU5gV+woA4DLvOYN3hdr75sbi6KISmvPLaYn2qwK7RBaf3hBO995bbBHyNniLee+vLzFzzlWd+StZnV/3B1BLAwQUAAAACAAAACEAusLlXH0AAACRAAAAEAAAAHhsL2NhbGNDaGFpbi54bWw9zEEOwiAQAMC7ryB7F6oHYwy0BxNfoA/Y0LWQsAthiam/9+Y8YPyyczEf6pqrBDjZCQxJrGuWLcDr+ThewehAWbFUoQBfUljmg49Y4j1hFrNzEQ2Qxmg35zQmYlRbG8nO5V0741Bb++a0dcJVE9Hg4s7TdHGMWWD27r/NP1BLAwQUAAAACAAAACEAgug+Z/AAAADOAgAAGgAAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzrZLPSsRADMbvPsWQu512FRHZcS8i7FXrAwxt2hl2/jGJ2r69sOtuq1Tw0FxCvsOXH1+y3Q3eiQ/MZGNQUBUlCAxNbG3oFbzVz9f3IIh1aLWLARWMSLB7vNq+oNNsYyBjE4nBu0AKDHN6kJIag15TEROGwbsuZq+Ziph7mXRz0D3KTVneyTz3gF+mYt8qyPu2AlGPCf9jHrvONvgUm3ePgRd2SDboEUStc4+s4DiexKoYvAP5B8RmTQji0SFNFKf5vF981yLHzZocnzEfyCDyhHKRSB7bOZVFmNtVQzE6Y/vK2YZ+ns1cvpxI/vi+KbMvUEsDBBQAAAAIAAAAIQCttKvn0wYAAGo2AAATAAAAeGwvdGhlbWUvdGhlbWUxLnhtbO1bT2/bNhS/91MQvLf+nyZB1CJ2knZr0gaJ26HHZ4mW2FCkQNJJfBva44ABw7phlwG77TBsK9ACu3SfpluHrQP6FQZativJksy0mZs2ySGAKb7fe3z/+WSvXT8OGTokUlHBHVy7UsWIcFd4lPsOvtvduryMkdLAPWCCEwcPicLXr11ag1UdkJCg45BxtQoODrSOVisV5QYkBHVFRIQfh6wvZAhaXRHSr3gSjij3Q1apV6tLlRAox4hDSBx8p9+nLkFdA4mvXUIIoQmHTUZCwrWKV8dPXCb3DSOSoh9TJvZ5B7X02nhdDVWHSXQIzMFHlHviqEuONUYMlO4w6eDq6A9XMoiVHMg1WGXalk2CxdboL4/FDNzoJPV8FtLvTXnUtporVzfypa7nSG0Bubm52dms5Us5CwmuS3iRMpKwza3lWjtX0lyIKbSFxJ1qq9osgS6SujEfeqXdbrdWiqEbBdDN+dDL1aXmer0YulkA3bLQdXu901kqhm4VQC/Nh966urLULIHOQKzBasAoP5gPbKIvPzhyANZgtS/YTTvk5Wq1upwb2bMYZnWaalIJqC+4tspAITwQcktwnSsZA0050sOI9MElDu5A2JMUstKNdxNIbC3Y46r5e4zwSLmSRtrBn0bAcYLm9fOfXz9/il4/f/Li4bMXD3978ejRi4e/2iDdBO4nkV79+NW/33+O/nn6w6vH31gCqCTAn7988cfvX1tS6iTly2+f/PXsycvvvvz7p8c29OsSekn6Lg2JQrfJEdoTIXArEUhPviNENwCagoBAhGBDuamDFOXtITArwjZJ2+yepNyzorwxeJA6734gB5raUN4KwhTljhCsLaSdjm4Z8ZI6GnDfUl45SBLuARxaidvJeOXmIApIWBikadqApI66y4Br8AknGpln4oAQG5z7lKbsu0NdKZToa3SfojZQO8V3aU/no9ykITAYWp2pG0DKAjv3UFswKwE2yGGaFLgPzIopYSnr3YCBhtDu1BCyJOk26MDqoPtD6aYMr7QE7hMm0KZHlLICuSOHqSPfAkYtPXaHDcM0qdT0wIp0G4RIkm6Ig04AYWR3bsqDJPEn6kAIBmhXaDu5RTqnmM+CUeD2nnqPEv2OyfQu9YN8ZzdPBtIqZxCRznFD1gcyw960CQV13nQAlJ+oA2C0J4uUdNEBLKoDWJfULjNl67414Tmt9hsw4LuEBxfFvkhjF8X+otif52JvnUEXXeJnC3k8NpiMAtITgtBuQNCnjO3rISPbKr9DUIJRb4syNvt0smPEZzrhiIIOyz97pRRtDVZ9CaOHSAr9GdXBfgARcXAtI3aSQuXKndqBIqEcXC0AmXeQcqoxpaZcx0StvMFtET/QO8KL6Rq5E99cFU6kLDl2xZzbSi0NI/BiVNO4+mGpphbzXYhuaq231E1rQbqJnxUGm7lKUI7AvLapLdVjzSHlAiOeCeCCdDAJ+I81G4xdyNKuAXjkbegS/lBrfPyx0lqwTj+MGKueLMZGrUNh7TeseGlbwDg6cvBKq97CyIXIwX0GGiM3jDwHK9OUAfO5g11dZN/5vcXb+0za8is2yTUbSNV5RBYGn9PxjNlGUukNUEHMeLS/yJaMlxij3moah3gf1qichfM3lmvn7fzxWmEMk36fuLo0jhNbCgWM98wrrWKgidwPvCPUYwO5B56Dm3GK8qjSDq5PPkgHG08dfUqXdpsCkn1NO7fqjAmBRQGME/qybT6PmZXngOm5i32gRIFvHhfYYLE2apwZG1nl7AsbXdgo7Xou4aThlQaBCyGRgEzadbCQOhC+hCig7pYUXM93byk0YqBNKCBmvrZmYoQcFrRgSV+NOZcKx6gf6D3qI0l9B+tAErKrxxH5LrLVxv3iHAkn7EvqWZmGjQWiOervkUPCuqZgL5kgxyiYtC5lVTQXtTR5Zh7m1ceebwrzxfjr9O5mzbN+x8rcW5uLu7Y2TzLiSVxeVj4sjf7/k4CEcuKe8uTKqbdaZ+VKH4EOkPnnYJdKl2Vn9Jnt5s7eFXvE1Wg6CkHawZdNT2uS/XSx5+BavFiSVw3j8zmaK1XNuZxGJ+LKaoqYF1eLUs7C4qqVE1at044q86SoFxkN6iYv8+Jls5Tz4wRzv+s9IK7eIH0YsMxvFlS0QfozHZCKdmX2XSOs9oQ3zFtnKu6lZp+owssr43ukj6h3XJoeMl47/hZ+8RhkL3uWhBmn/BqnxW+MWnI5n/KsnxbPKW7+OQV/w3P0ZtiaLys5Z4w665wZ88YdecqfRpZ+7x5WX7CHVd+Dh9XOvIfp41PxsIQ/jeZsObnNaOdYS+hMfiWxrXTl2qVpgnwD+B9QSwECLgMUAAAACAAAACEAllgUrh4BAACwAgAAGAAAAAAAAAAAAAAApIEAAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sUEsBAi4DFAAAAAgAAAAhAHxiW1CqAQAA3QUAABMAAAAAAAAAAAAAAKSBVAEAAFtDb250ZW50X1R5cGVzXS54bWxQSwECLgMUAAAACAAAACEAzJDqGOcAAABYAgAACwAAAAAAAAAAAAAApIEvAwAAX3JlbHMvLnJlbHNQSwECLgMUAAAACAAAACEAY3OPKC0BAADYAgAAEAAAAAAAAAAAAAAApIE/BAAAZG9jUHJvcHMvYXBwLnhtbFBLAQIuAxQAAAAIAAAAIQA8yE301gAAAIgBAAARAAAAAAAAAAAAAACkgZoFAABkb2NQcm9wcy9jb3JlLnhtbFBLAQIuAxQAAAAIAAAAIQAkoEte4gEAAOAFAAANAAAAAAAAAAAAAACkgZ8GAAB4bC9zdHlsZXMueG1sUEsBAi4DFAAAAAgAAAAhAEF5QWKIAAAApwAAABQAAAAAAAAAAAAAAKSBrAgAAHhsL3NoYXJlZFN0cmluZ3MueG1sUEsBAi4DFAAAAAgAAAAhABZGRDvWAAAATwEAAA8AAAAAAAAAAAAAAKSBZgkAAHhsL3dvcmtib29rLnhtbFBLAQIuAxQAAAAIAAAAIQC6wuVcfQAAAJEAAAAQAAAAAAAAAAAAAACkgWkKAAB4bC9jYWxjQ2hhaW4ueG1sUEsBAi4DFAAAAAgAAAAhAILoPmfwAAAAzgIAABoAAAAAAAAAAAAAAKSBFAsAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzUEsBAi4DFAAAAAgAAAAhAK20q+fTBgAAajYAABMAAAAAAAAAAAAAAKSBPAwAAHhsL3RoZW1lL3RoZW1lMS54bWxQSwUGAAAAAAsACwC+AgAAQBMAAAAA
Output
{"alpha":1.0,"beta":"two","name":"remark"}The output is a flat JSON object: keys are always strings while values keep their native type from the sheet (numbers stay numbers).
Frequently asked questions
What about duplicate keys?
Later rows overwrite earlier ones, and the pair count reports the final de-duplicated keys.
What about rows with an empty key?
They are skipped and counted in the skipped statistic; the header row is not counted.
Are column indexes 0-based?
They are 1-based, matching Excel column numbers; anything below 1 is clamped to 1.
Keywords：excel转键值对excel2kv两列转json键值对wasm