Skip to main content
All CollectionsWhat's New
June 2024 Updates
June 2024 Updates

Format tool, Upload 50MB files, Zipped files, PUT/PATCH/DELETE, Spreadsheet update and Excel Macros

Updated over 5 months ago

Savants are always improving and their tools should too. That's why we're constantly releasing new features and enhancements every week. Here are the highlights from this month:

The New and Dynamic Format Tool

We’re excited to introduce our newest tool: the Format Tool. Designed to streamline your data transformation processes, the Format Tool offers a range of powerful features to enhance your data management capabilities:

  1. ✏️ Dynamic Field Renaming

    • Easily rename fields with a straightforward interface, whether for standardization or specific naming conventions.

  2. 🔣 Data Type Conversion

    • Automatically convert data types to ensure consistency and accuracy across your datasets.

  3. 🙈 Show/Hide Fields

    • Manage the visibility of your data fields with simple controls to show or hide fields as needed.

  4. 🔁 Replace Fields Name from Row

    • Replace existing headers with values from any data row and skip all records that header row.

  5. 🎡 Bulk Field Operations

    • Apply changes across multiple fields simultaneously to save time and improve efficiency.

  6. 🔢 Rule Ordering

    • Set the order of operations for each rule across renaming, type changes, and visibility.

  7. ✌️ User-friendly Interface

    • An intuitive design makes the Format Tool accessible to both new and experienced users.

  8. 🧵 Seamless Integration

    • Integrate the Format Tool with your existing data workflows and systems without hassle.

At Savant, we aim to provide tools that simplify and enhance your data transformation processes. The Format Tool is a robust solution that offers flexibility and ease of use for all your data needs.

Upload 50MB Files

Trying to quickly upload large data files to Savant for analysis? Now you can upload files up to 50MB directly through your browser. This is a 5x increase over previous limits!

Advanced Zip File Features

We’re pleased to announce the addition of advanced zip file features to our platform, designed to simplify your file management tasks.

Key Features:

  1. 🤐 Unzip and Read Multiple Files

    • Easily unzip and read multiple compressed files from a folder, streamlining your data import process.

  2. 1️⃣ Read the Most Recent File

    • Quickly identify and read the most recent zipped file in a folder, ensuring you always work with the latest data.

  3. 🙏 Simplified Processing

    • Handle complex zip file processing rules without the need for complicated macros or batch scripts, making your workflow more efficient and user-friendly.

These new features enhance our platform’s capabilities, making zip file management simpler and more effective for all users.

PUTCH/PATCH/DELETE Repeat

We’re excited to announce that our Generic API tool now supports advanced API methods for PUT, PATCH, and DELETE.

Key Features:

  1. 🌐 Advanced API Methods

    • The Generic API tool now includes support for PUT, PATCH, and DELETE methods, expanding your options for interacting with APIs.

  2. 💼 Business Process Automation

    • These new methods enable complex business process automation, making it easier to manage and streamline your operations using Savant.

  3. 🤖 Comprehensive Automation

    • With the addition of these methods, the Generic API tool can now handle all types of advanced automation use-cases, providing a robust solution for your integration needs.

These enhancements make the Generic API tool a more powerful and versatile component of our platform, supporting a wide range of automation and integration scenarios.

Update Spreadsheets with Multi-Write

Ever need to write to multiple tables in the same Google Sheets or Excel spreadsheet? With our latest release, now you can write to the same sheet in multiple places with different datasets.

This feature is great for write multiple summary and fact tables to a single page, and preserving existing formats for pretty reports.

Now you can build your perfect, compound report in Google Sheets and Excel!

Read Excel Macro Files

Savant now supports reading Excel Macro files (.xlsm). This new capability allows users to seamlessly import and analyze data from .xlsm files, streamlining workflows and enhancing data integration flexibility.

Whether you're leveraging complex macros or managing large datasets within Excel, our platform ensures a smooth transition, preserving all embedded functionalities and enabling comprehensive data analysis within the Savant environment.

Did this answer your question?