Data Tools

Available Data Tools

Gridscript provides a variety of built-in tools to manipulate and prepare your data without leaving the grid. Each tool can be opened from the toolbar, configured through a simple popup, and applied instantly to your dataset.

• Filter – Show only the rows that match specific conditions. Supports multiple conditions, logic (AND/OR), regex, and column-to-column comparisons.
• Sort – Reorder rows by one or more columns. Smartly detects numbers, dates, and text for correct sorting.
• Search & Replace – Find values across the dataset and replace them in bulk. Supports case sensitivity, regex, whole-cell matching, and column targeting.
• Limit – Restrict the dataset to the first N rows. Useful for sampling or focusing on a subset.
• Remove Column – Delete a column by index, cleaning up unnecessary fields.
• Remove Row – Delete a row by index, useful for removing headers, errors, or unwanted records.
• Join – Merge two columns into one, with a custom separator (e.g., combine First Name and Last Name).
• Split – Break a column into two new columns based on a separator (e.g., split City, Country into two fields).
• Sample – Extract a smaller dataset using random, systematic, or stratified sampling. Choose by row count or percentage.

Each tool has its own dedicated documentation page with step-by-step usage and examples. Use them together to clean, organize, and transform your datasets efficiently.