At one of our clients the Customer Success Managers (CSMs) were spending hours each week manually assembling Salesforce reports into Excel files for their clients. This reporting was far from simple. It included multiple tabs, conditional formatting, charts, graphs, and highlighted data. As the company’s customer base grew, so did the requests for new data views and more detail. What started as a manageable task quickly became an overwhelming and time-consuming process for the team.
Salesforce offers great built-in reporting tools, but it doesn’t support exporting highly customized Excel files with complex formatting and charts. Additionally, your customers may not have direct access to Salesforce reports. That limitation meant our client’s CSMs had to do everything by hand – pulling data from various reports, copying and pasting it into the right tabs, adjusting formatting, and re-creating charts for each client. It was clear that this manual approach wasn’t scalable. That’s where our team came in.
Project Scope
Our goal was to automate the creation of these Excel workbooks – without losing any of the rich formatting or visual clarity that the team and their customers had come to expect. To do this, we built a custom solution using Python and the XlsxWriter library. Python gave us flexibility in pulling and processing Salesforce data, while XlsxWriter allowed us to create Excel files with multiple tabs, custom formatting, embedded charts, and even trend lines.
We started by working closely with the client to define exactly how each tab should be structured, what data needed to be included, and how charts and highlights should appear. Then we developed scripts to fetch the latest Salesforce data, organize it into meaningful tables, and apply consistent styling and layouts across all customer reports. We also made improvements to some of the chart formatting—making trends easier to spot and visual insights clearer.
The final result was a streamlined, repeatable process that generates polished Excel reports automatically. Whether they need to run one report or a hundred, the client can now do so with just a few clicks.
Business Impact
The time savings alone were significant. What used to take hours each week can now be done in minutes. That freed up the CSM team to spend more time engaging with customers and less time wrangling spreadsheets. But what made the biggest difference was the scalability. The automated process meant that reports could now be created for all customers – not just those who specifically requested them.
That shift opened up a new level of transparency and value for the client’s customers. With regular, data-rich reports delivered on a consistent schedule, customers gained deeper insight into their own performance. They could spot trends earlier, identify opportunities for growth, and see the direct impact of the services provided.
Internally, the CSMs found themselves having better, more data-informed conversations with clients. They no longer had to choose between quality and speed when it came to reporting. And because the Excel files matched what customers were already used to seeing, there was no learning curve – just better results delivered more efficiently.
This project is a great example of how automation can support customer relationships while reducing internal strain. By combining Salesforce data with custom reporting workflows, we helped the client scale their operations without sacrificing quality. Interested in bringing large-scale automation to your company? Click below to reach out.