We are excited to announce that the Excel to JSON plugin has been upgraded to version 2.4.0! This update brings two significant features designed to provide you with greater flexibility and more powerful data processing capabilities.
Key Updates:
1. Users can choose headers from rows or columns
In previous versions, the plugin typically defaulted to using the first row as headers. Now, we’ve introduced a more flexible option, allowing you to freely select first row or first column in your data source to serve as the keys (headers) for your JSON data. This means you can more precisely control the data conversion process, easily extracting the information you need regardless of your Excel file’s structure.
2. Users can choose to preserve a single object JSON as an array or object
When Excel data contained only a single record, older versions might have automatically converted it into a standalone JSON object. In the new version, you have the option to force this single-record data into an array containing a single object, or to keep it as an independent JSON object. This feature provides great convenience for maintaining data structure consistency, especially when integrating with other systems.
We believe these new features will significantly enhance your productivity and data processing experience. Update to version 2.4.0 now to experience a more powerful and flexible Excel to JSON conversion!