Google Sheets Toolkit

What is it?

The Google Sheets Toolkit & Library is a collection of powerful tools designed to make working with spreadsheets faster, cleaner, and easier — no coding required.

Whether you're tidying up data, converting sheets to JSON, or preparing reports, this toolkit gives you quick, reliable functions accessible in two ways:
✅ Sidebar UI — Run cleanup and formatting tools directly from a simple menu inside your spreadsheet.
✅ Library Mode — Reuse the same functions in your own Apps Script projects by adding the toolkit as a library.

Built with Google Apps Script, this toolkit automates the stuff you shouldn’t have to do manually — trimming whitespace, deleting unused rows, resizing columns, and much more

Toolkit Capabilities

✅ Clean up with confidence — trim whitespace, delete extra rows & columns, and format sheets with a single click
🔁 Reuse in your own projects — import this toolkit as a library and call any function programmatically
📊 Work with real data — apply tools to your existing Sheets or try the included test spreadsheet
🎛 Customize your experience — save your default Drive folder or sheet settings in your private configuration
🧪 Experiment safely — test any function without impacting your original data (undo supported!)
🤝 Share the toolkit, not your settings — each user’s configuration is stored privately via Apps Script
🧙‍♂️ No coding required (but totally welcome) — run everything through the sidebar UI or write your own code using the library

What's Included

Everything you need to streamline your spreadsheet workflows — no custom scripting required.

Included in the Toolkit:
🧩 A prebuilt Google Apps Script project with UI and backend logic
🖱️ A fully interactive sidebar to run tools with a few clicks
📁 Organized utility functions for cleaning, formatting, and transforming data
🧱 Reusable library functions to drop into your own Apps Script projects
📝 Well-commented scripts to help you understand and customize each tool

🧪Example tools you can try:

Delete extra rows and columns from any sheet
Format alternating row colors (with custom color options)
Convert a sheet or CSV file into JSON
Count total cells used in your spreadsheet
Trim whitespace and auto-resize columns
Highlight matching cells by keyword

Designed for:

Easy reuse in other Apps Script projects
Quick experimentation with your own Sheets
Learning by exploring clean, modular, and well-documented code

Getting Started with the Google Sheets Toolkit

This guide walks you through setting up the Google Sheets Toolkit so you can start cleaning, formatting, and transforming your spreadsheet data — right from your browser.

Everything runs securely in your own Google account. No special tools or coding experience required.

✅ Step 1: Copy the Toolkit Spreadsheet
Make your own editable copy to get started.
👉 Click Here to Make a Copy

✅ Step 2: Open the “Start Here” Page
Inside the spreadsheet, click the 🧙 Start Here tab. This page includes:

Instructions for authorizing the attached scripts
How to open the toolkit sidebar
Links to test tools and documentation

✅ Step 3: Authorize and Configure

Click 🧙‍♂️ WIZARDRY → Start Here - Authorize to grant script permissions.
Then click WIZARDRY → Open Toolkit Sidebar to open the UI.

From the Configuration panel, you can:
- (Optional) Save a default Google Drive folder ID for export tools
- Securely store your settings using User Properties — never stored in the sheet or shared with others

✅ Step 4: Try a Tool
Use one of the tools in the sidebar to see the toolkit in action:

Trim whitespace
Format alternating rows
Highlight matching cells

🔁 Want a safe space to test first?
👉 Click here to make a copy of our sample spreadsheet and try the tools on preloaded data.

Changes are safe to test — everything can be undone with Edit → Undo or Ctrl/Cmd + Z.

✅ Step 5: Use the Toolkit as a Library
Want to use these functions in your own Apps Script projects?

Open the Script Editor: Extensions → Apps Script
Copy the Project ID from Project Settings
Add it as a library in another project

Call functions like sheetToJSON() or sheetAltColors() anywhere you want

📚 Visit the Library Instructions tab in the spreadsheet for detailed steps and examples.

🔒 Your Security Matters

We take your privacy seriously. This toolkit was built with a “your account, your data” philosophy:

🔐 Your settings are stored only in your Google account using Apps Script’s built-in User Properties
📁 No data is ever sent to us or any third party — everything runs locally in your copy of the script
🔄 You can reset or remove your configuration at any time using the Config sidebar
🤝 When you share the spreadsheet, your saved settings do not carry over — others will need to enter their own

Resources & Support

Explore guides, documentation, and practical tips to help you get the most out of the Google Sheets Toolkit and Google Apps Script.

Topic	Description	Link
Google Apps Script Overview	Learn about the capabilities and features of Google Apps Script.	Visit Page
Google Apps Script Libraries Guide	Official documentation on adding and managing libraries in Apps Script.	Visit Page
Automate & extend Google Workspace with simple code.	Apps Script is a cloud-based JavaScript platform powered by Google Drive that lets you integrate with and automate tasks across Google products.	Visit Page

💬 Need Help?

Still stuck? Feel free to Contact Us - we’re here to help.