Skip to main content

April 2025 Updates

Read Excel as stored or formatted, Advanced scheduling, Gen AI tool big boost, BigQuery pushdown and Google Sheets long names

Updated over a month 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:

Read Data as Stored & Data as Formatted

Ever imported an Excel file only to realize that your numbers got misread, your dates transformed, or your formatting got stripped? Or maybe you needed the raw structure—merged cells, custom formats and all—exactly as it was in the source, but the tool made assumptions and cleaned it up for you?

We get it. Whether you're debugging a messy export or running a polished analysis, how your data is read in can make or break your workflow.

That’s why we’ve introduced Read Data as Stored and Read Data as Formatted—two powerful options that let you take control over how Excel (and similar) files are interpreted on upload.

  • Read Data as Stored: Use this when fidelity matters. Data is brought in exactly as it exists in the original file—formatting quirks, raw values, structure and all. Ideal for debugging, audits, or data engineering work where transformation happens later.

  • Read Data as Formatted: Perfect for analysis-ready workflows. Numbers, dates, currencies, and other formatting are applied during ingestion so the dataset is immediately ready for calculation or visualization.

These options give you flexibility to handle data your way—whether you’re diving deep into the raw details or jumping straight into insight.

Search and Replace Tool

Tired of scrolling through rows just to make the same update over and over?

If you've ever used Find & Replace in Excel or Alteryx, you already know how powerful it is to make bulk updates in seconds instead of hours. Now, that same capability is baked right into Savant.

The new Search and Replace Tool gives you a fast, flexible way to clean up your data—no formulas, no manual work. Whether you're standardizing categories, correcting typos, or reformatting values across a dataset, this tool lets you:

  • Search for values in any column, using rules like “contains” or “matches”

  • Replace or append new values dynamically

  • Apply bulk updates in a single click

It’s perfect for data cleanup, taxonomy adjustments, or prepping reports—anything where consistency matters. Just drop it into your workflow and go.

No more hunting. No more patchwork edits. Just clean data, faster.

Smarter Scheduling for Smarter Automation

If you've ever set up a recurring meeting in Outlook, you'll feel right at home with our new Scheduler Screen.

We’ve supercharged job automation in Savant by introducing advanced scheduling options designed for the real-world complexity analysts face. Whether you’re syncing data every weekday at 9am, running hourly updates during business hours, or coordinating jobs across global teams—our new scheduling capabilities have you covered.

With the upgraded Scheduler Screen, you can now:

  • 🕒 Build custom schedules using intuitive selectors for daily, weekly, and hourly intervals—including advanced patterns like “every 3 hours during working hours” or “only on the last weekday of the month.”

  • 📆 Mirror calendar logic you’re used to in tools like Outlook or Google Calendar—down to start/end times, recurrence rules, and exceptions.

  • 🧠 View and manage everything in one place, from runtime metadata to all active schedules, so nothing falls through the cracks.

Automation just got a whole lot more flexible—and powerful. No code. No cron expressions. Just a clean, visual way to keep your workflows running like clockwork.

Gen AI Tool Just Got a Big Boost – Now with 65K+ Character Support

Big ideas need room to breathe.

We’ve lifted the limits on what you can do with the GenAI Tool—literally. With our latest update, you can now process inputs up to 65,535 characters, giving you the freedom to work with longer documents, richer context, and more complex datasets.

Whether you’re analyzing lengthy transcripts, summarizing detailed reports, or generating expansive content, this upgrade opens the door to deeper insights and more powerful GenAI-driven workflows.

More characters. More depth. More impact.

BigQuery Pushdown, Now Even Smarter

We’ve leveled up DB Pushdown for BigQuery, enabling even more complex queries to run directly in BigQuery—right where your data lives.

By offloading processing to BigQuery, you’ll see faster execution, better scalability, and reduced strain on your local resources. Whether you're working with massive datasets or intricate logic, your workflows just got leaner, cleaner, and lightning fast.

Less waiting. More doing. All in BigQuery.

Long Sheet Names? No Problem.

Say goodbye to name limits.

Savant now supports Google Sheets tab names longer than 100 characters, giving you the freedom to be as descriptive as you need. Whether you're working with deeply nested datasets, detailed workflows, or team-specific naming conventions, you can now keep everything clearly labeled—no abbreviations required.

More characters. More clarity. More control.

Did this answer your question?