LogoLogo
FeaturesHelp & ResourcesShowcasePricingLogin
Learn Section
Learn Section
  • Introduction
  • Getting Started
    • Finding your way around
    • Core concepts
      • Data Binding
      • Data Insertion
      • Dynamic Visibility
    • Creating and managing projects
      • Creating a Project
      • Saving a Project
      • Opening a Project
      • Version History
    • Templates
  • Components
    • Overview
    • Layout & Positioning
    • Charts
      • Line Chart
      • Column Chart
      • Bar Chart
      • Pie Chart
      • Combination Chart
      • Area Chart
      • Spline Chart
      • Step Chart
    • DataViz
      • Gauge
      • Word Cloud
      • Chord Diagram
      • Sankey Diagram
      • Schedule (Gantt)
      • Metric Tile
      • Progress Bar
      • Trend Icon
      • Mapbox
      • Loading Animation
    • Tables
      • Scorecard
      • Data Table
    • Controls
      • Push Button
      • Dropdown
      • Multi Select Dropdown
      • Listbox
      • Label Based Menu
      • Checkbox
      • Radio Button
      • Slider
      • Value Input
      • Print Button
      • URL Button
      • Screenshot
      • Hotspot
      • Date Picker
      • Toggle Switch
      • Scenario
    • Text
      • Text Label
      • Text Input
      • Text Area
    • Shapes
      • Rectangle
      • Ellipse
      • Line
    • Media
      • Image
      • Icon
    • Containers
      • Container
      • Web View
      • Repeat Container
      • Row Layout
      • Column Layout
  • Functions
    • Overview
    • Data Mover
    • External Parameters
    • Export to Excel
    • Export to PDF
    • Timer
    • Tableau Parameters
    • Browser Info
    • TextJoin
    • Unique List
  • Connections
    • Overview
    • Excel One Drive
      • Excel One Drive Read
      • Excel One Drive Writeback
    • Google Sheets
      • Google Sheets Read
      • Google Sheets Writeback
    • Ninox Connections
    • Smartsheets
    • CSV Connector
    • SAP Webi Connector
    • XDC Connections
    • Database Connections
    • Zapier Trigger
  • Spreadsheet
    • Overview
    • Spreadsheet functionality
    • Supported Spreadsheet Functions
    • Spreadsheet performance
  • Best practices for the Squirrel spreadsheet
  • Publishing & Sharing
    • Overview
    • Project Settings
    • Publishing to Squirrel Cloud
    • Publishing Locally
    • Using the Project Manager
    • Adding projects to PowerPoint
    • Adding projects to Tableau
    • Progressive Web Apps (PWA)
  • SETTINGS
    • Image Library
    • Custom Fonts
  • Account Management
    • Manage your account Profile
    • Understanding your Squirrel plan usage
    • Changing your Plan
    • Billing
    • How do I delete my account?
  • Frequent Questions
    • What data do you keep and for how long?
  • How-Tos
    • Overview
    • Add-ons
      • Add-on Documentation
      • Window Size – Add responsive behavior to your components
      • Window Size - Getting responsive behavior in the canvas
    • Adding your own Google Fonts
    • Chart title and Checkbox label text case formatting
    • Deleting functions and connections
    • Find & Replace Fonts
    • Getting a Mapbox API access token
    • Renaming a component, function or connection
    • Seeing Data from a Connector at Design time
    • Troubleshooting Projects in the Console
    • Using colors and color values
  • Tutorials
    • Cascading Dropdowns
    • Create a temperature conversion app
    • Create a revenue growth app from an existing spreadsheet
    • Whack-A-Squirrel Game
    • Filtered Rows Insertion: Building a Filtered Selection
Powered by GitBook
LogoLogo

Explore

  • Home
  • Features
  • Pricing
  • Download Squirrel

Help

  • Learn
  • Community
  • Support
  • FAQ's

Updates

  • Blog
  • Events
  • Release Notes

Company

  • Contact Us
  • Privacy Policy
  • Terms of Use

Copyright © 2019 - 2024 InfoSol Ltd. All rights reserved.

On this page
  • Best practices for setting up your spreadsheet
  • Using Color Fill on Cells
  • Create a Key
  • Organize the Spreadsheet by Tabs
  • Grouping and Labeling Data Inside the Squirrel File

Was this helpful?

Best practices for the Squirrel spreadsheet

This article describes our recommended best practices to utilise the Squirrel Spreadsheet to its full potential and keep your data organised

PreviousSpreadsheet performanceNextOverview

Last updated 2 months ago

Was this helpful?

Best practices for setting up your spreadsheet

When creating your Squirrel project, it’s natural to focus on the canvas and visual design—after all, you want your project to look great! However, it's equally important to keep the underlying spreadsheet well-organized. A cluttered, chaotic spreadsheet can quickly become a nightmare to troubleshoot and even harder to hand off to someone else.

To ensure your project remains easy to manage and understand, here are some key tips for maintaining a clean and efficient spreadsheet:

Using Color Fill on Cells

We highly recommend color-filling cells that involve interactivity or data insertion. These cells often appear ‘empty’ in the spreadsheet, making it easy to accidentally add data that could later be overwritten by new insertions. A simple color fill helps prevent this confusion and keeps your spreadsheet organized.

Create a Key

If there’s a chance you’ll need to hand off your project to someone else, creating a key is essential. A well-designed key will explain the meaning behind each color fill and highlight how to identify formulas. This will undoubtedly save the next user a lot of time and frustration, making the spreadsheet much easier to navigate.

Organize the Spreadsheet by Tabs

It’s tempting to quickly place information in the first available spot in your spreadsheet, but this can lead to a messy mix of component styling, controls, and data. Before you know it, you might struggle to determine if your label-based menu controls are affecting your total cost values. To avoid this, we recommend organizing your Squirrel project by creating separate tabs for styling, functions/controls, and data. If your project involves a large amount of data, feel free to add more tabs as needed. This simple structure keeps everything clear and easy to manage.

Styling Tab

The styling tab is just what it sounds like—a dedicated space to store all your color settings for components. By binding all your colors to this single location, any changes you make can be updated easily in one place. This not only simplifies updates but also ensures consistency across your project. Additionally, having all your colors centralized makes it easier to use them in formulas.

Control Tab

The control tab is where all the interactivity in your project resides. Any element that responds to changes on the canvas should be placed here, keeping your project’s interactive components organized.

Data Tab

The data tab is where all the information you want to display in your Squirrel project is stored. If you have a large amount of data, consider organizing it across multiple data tabs to maintain clarity and manageability.

Grouping and Labeling Data Inside the Squirrel File

Lastly, we recommend grouping and labeling your data within your Squirrel spreadsheet for better organization. For instance, if you have a label-based menu in your control section, keep all related labels and interactivity together, clearly identifying it as the label-based menu control. To enhance clarity, add a title or description above or beside each section of data. Grouping can be accomplished by leaving a row or column gap around the data, but using a border around each section makes it more visually prominent and easier to navigate.