Find & Highlight Data in Google Sheets Using Sutra Tools

1. Click on “Find & Highlight Data” from the Sutra Tools panel.

2. A pop-up will open.
   In the “Find” field, enter the value or keyword you want to search for.

3. Choose where to search:

   • From the Search dropdown, select one of:

     • Selection – to search within a selected range

     • Current Sheet

     • All Sheets

4. Select a Highlight Color to mark the matching cells.

5. Optional: Check advanced filters like:

   • Clear existing formatting

   • Ignore case

   • Match entire cell content

   • Search by Regex

6. Click “Find & Highlight”.

7. All matching cells will be instantly highlighted in the selected color.

Split Data Into Multiple Sheets in Google Sheets Using Sutra Tools

1. Click on “Split Data Into Multiple Sheets”.

2. A pop-up will open.
   In the “Select table” field, choose the range of your table (e.g., A1).

3. Under Split Criteria, select:

   • For every new value/group in column → Choose the column from the dropdown (e.g., Department or City).

   • Or, For every so many rows (if splitting by row count).

4. Optional settings:

   • Copy first row as header in each worksheet.

   • Keep source formatting.

5. Under Name of New Worksheets, choose how to name:

   • Sequential numbering

   • Use row number

   • Use value of a column (with optional prefix/suffix)

6. Click on “Split Data”.

7. New sheets will be created—one per group—with corresponding data automatically filled in.

Export Data to JSON in Google Sheets Using Sutra Tools

1. Click on “Export to JSON”.

2. A pop-up will open.

   • Select the Sheet you want to export.

   • Choose the number of Header Rows (usually 1).

3. Click “Export”.

4. A structured JSON file will be instantly generated and downloaded.

Export Data to XML in Google Sheets Using Sutra Tools

1. Click on “Export to XML”.

2. A pop-up will open (similar to JSON).

   • Select the Sheet and define the Header Row.

3. Click “Export”.

4. A valid XML file will be generated for further sharing or integration.