Google Sheet Data is a platform that allows you to export data from Google Sheets into a single XML or JSON file. This way, you can perform the task automatically, something that is not possible without the tool. The extension also gives you a preview of the data before exporting it (view or listen).

Google Sheet Data: Export Spreadsheet Data as XML and JSON
Export in a single file

Once you have downloaded the program from its official page, you will see that a Google Sheet page automatically opens and asks for permission to install as an add-on (you need to be logged in to Google).

Google Sheet Data: Export Spreadsheet Data as XML and JSON
It installs very easily

Now you have the extension in the top menu under Add-ons. Once you have all the data inserted in your spreadsheet, just go to Add-ons, choose Export Sheet Data, and the platform interface will open on the right side.

Google Sheet Data: Export Spreadsheet Data as XML and JSON
Very simple to understand interface

From the interface, you can select the format between XML or JSON and also choose whether you want to convert all the spreadsheets, the active ones, or customize the conversion. All that remains is to preview the export and export it.

Google Sheet Data: Export Spreadsheet Data as XML and JSON
Visualization in the format

The environment truly offers a simple and fast way to convert Google Sheets data to XML or JSON, whether from some cells or in batch. Google Sheet Data is a free extension for the Google Chrome browser; to install it you need to log in to Google.

Official site: