Skip to main content

July 2025 Updates

Bigger Excel uploads, Empty field automation, Geo Distance calculations, Sprinklr reports and Advanced Shopify queries.

Updated over a week ago

From agentic AI to enterprise-wide automation, we're giving you the tools to govern, scale and innovate without compromise.

This month, we’re giving your workflow a powerful boost. Think smoother file handling, cleaner data prep, more geospatial insights and advanced reporting, all designed to cut friction and expand what’s possible.

We believe great tools should evolve just like the analysts who use them. That’s why we’re constantly shipping new features and enhancement upgrades week in, week out. July updates empower you to move faster, work smarter and deliver better results, giving you greater control over your data and more power in your processes.

Here’s what’s new this month:

Upload Bigger Excel Files

Work with files over 100MB without errors

Ever tried loading a large Excel file into your workflow, only to hit a wall with size limits or unreadable data? With the previous cap on the file size, Fast Excel Reader couldn’t always keep up, often failing to load files fully or cleanly.

Now, files can exceed 100MB with no more frustrating errors and no more interrupted flows. Files beyond that will still error out, but this expanded limit covers the vast majority of user needs.

A quiet change, but a big unlock for getting to insight faster.


Automate Rules for Empty Columns

Reformat, remove, or fill blank data in one step

When you’re cleaning data, nothing clogs a dataset like columns full of nothing, literally. Before, dropping columns with only null or blank values required clunky pivot-unpivot workarounds.

Now, there’s a smarter way. With the new "are empty" condition in the Format Tool, you can instantly identify and act on empty columns, no gymnastics required.

  • Works at the column level

  • Recognizes both nulls and blank strings

  • Supports drop, fill, and type change actions

Get cleaner data in fewer clicks. Empty shouldn’t mean extra work.

📚 Learn More


Calculate Geospatial Distance

Instantly find the exact distance between any two locations

Ever tried calculating the distance between two places and ended up with results that felt off? Traditional methods often miss the mark by ignoring the Earth’s curvature. Our new Geo Distance function uses sphere projection to account for both curvature and location angles, giving you accurate straight-line distances in seconds.

  • Just plug in: two sets of latitude/longitude coordinates

  • Get back: a distance in consistent units

  • Returns null or invalid input

Whether you’re mapping customer proximity or shipping routes, this tool gives you precision at speed, no GIS required.

📚 Learn More

View the full guide → Geo Distance Function Guide


Import Sprinklr Reports

Unify social metrics with your business analytics

Your reporting just got more social. With Sprinklr Reports support, you can pull engagement and performance metrics directly into your analytics workflows with no manual exports, no scattered datasets.

By integrating with Sprinklr’s Reporting API, you can query campaign performance, audience engagement, and sentiment tracking alongside your other business data.

  • Direct API integration for real-time reporting

  • Supports full custom query bodies for tailored analysis

  • Returns data in clean JSON for immediate use


Query More Shopify Data

Richer ecommerce insights for advanced, custom reporting

With Shopify deprecating its legacy endpoints, we’ve upgraded your access to Shopify data by migrating all 12 query sources to the Shopify GraphQL Admin API.

This ensures continued reliability while unlocking richer, more structured access to products, customers, and inventory. For analysts building specialized ecommerce reports, this means cleaner queries, future-proof integrations and the ability to scale insights as your store grows.

  • Full migration of existing queries for long-term stability

  • Support for SUM, GROUP BY, ORDER BY, SINCE, UNTIL, and more

  • Improved compatibility with Shopify’s evolving API model


Insight. Action. Impact.

From optimized workflows to precise analytics, these updates are designed to accelerate your journey from data to impact. Stay tuned for even more powerful tools and clearer pathways to achieving your best work.

Questions? Ideas? We’d love to hear from you.

Did this answer your question?