Here is a free Google Sheets add-on “Google Sheet Data” to export Google sheet data as XML or JSON file, which is not possible normally. You can export all the sheets, active sheet data, or select sheets to convert as a single JSON or XML file. Before exporting the data, you can also visualize or preview the data as per the need. Those who have to regularly turn Google Sheets to XML files, perhaps this is the faster solution for this task because you don’t have to manually create an XML file and pick values from sheet data.
So, if you are looking for a Google Sheets to JSON converter or Google Sheets to XML converter, this add-on can fulfill that need.
In the screenshot below, you can see the preview of a sample Google Sheet converted to an XML file. Your original file is not edited and remains as it is. It generates a copy of your original file as an XML file and saves it in your Google Drive in the same location.
How To Export Data of a Google Sheet As XML or JSON File
Step 1: Go to this link and install this Google Sheets add-on. Just make sure you are already logged in to your Google account. Otherwise, it will first prompt you to log in and then you can install it.
Step 2: When the add-on is installed, open a Google Sheet that you want to convert into the XML file. After that,
go to Add-ons menu → Export Sheet Data → Open Sidebar.
Step 3: Its sidebar has a couple of options that you can select such as:
- Select output format: JSON or XML. Based on the selection, this add-on will convert Google Sheets to JSON or Google Sheets to XML.
- Set whether you want to convert all sheets, active or custom sheets.
- Set the formatting options. These options depend on the selected format. You can enable/disable any formatting option. You should also preview the output to check if formatting is looking good or you have to disable some options.
Finally, you can Export the data. A copy of the original file is stored in the same location but in XML/JSON format. You can open the output and then download it to use or send to some other user.
There might be other ways to turn a Google sheet to an XML or JSON file, but believe me, this is such an easy way to bulk convert all the sheets to JSON or XML. If you need to turn a sheet data to JSON or XML regularly, the you should definitely try this add-on.