Working with RapidStart CRM Data Using Excel Online

by | Jun 1, 2022

To demonstrate how you can easily customize RapidStart CRM to meet your needs, we created this "Tips and Tricks" Series. In this series we will outline some simple-to-perform solutions to common things customers ask about RapidStart CRM. Enjoy!

Excel Online

Did you know that Excel online is directly integrated into RapidStart CRM? In this post, we’ll show you how to use this feature to manipulate data. We’ll start by opening a view in RapidStart CRM, for example, Cases.

(1) Select the “Export to Excel” dropdown
(2) Select “Open in Excel Online”

Here we can see the same view of records in Excel Online. We can use any of the features of Excel Online to manipulate this data, then save it back to RapidStart CRM.

This opens the same view you are looking at when launched. So, if you need a column that is not shown, add it to the view, or create a new view following the in-app documentation.

Let’s say, we want to deprioritize any High Priority cases where the status is “Waiting for Customer”. First, we will apply some filtering to this view.

(1) Select the dropdown arrow next to the column header
(2) Change the filter to “High”
We will also filter Case Status to “Waiting for Customer”

We have nine cases that meet our filters

After editing the Priority Field, we click Save.

The Import Data dialog appears, but this should only take a minute, so we can just close and refresh the screen to see the changes.

Summary

So, this very simple example could have been accomplished directly in the view by filtering and selecting edit. But there are more advanced things we could have done, like formulas, summing columns, or even adding rows directly to be imported. In many cases, this is a much quicker way to import data.

If you have any questions feel free to post them in the Free Support Forum.

RapidStart CRM is built on Microsoft’s Dataverse, the foundation of the Power Platform and Dynamics 365. This means that our free RapidStart CRM is just as customizable as any of Microsoft’s first-party applications, like Dynamics 365 Sales, for example. We designed RapidStart CRM as a basic Sales and Service app “accelerator”. While it is a fully functioning app, it is the starting point for much more for many. Get or Test Drive RapidStart CRM on Microsoft’s AppSource here.

General Posts

There is no App for That

When it comes to Business Applications, Microsoft has a lot of options for you. If you are running a sophisticated Sales organization, they have an app for that.

read more

Why we Chose to Forgo Leads

Even as a simple-to-use CRM solution, there was often still confusion about how to use Leads and Contacts together. So we decided to approach it differently with RapidStart CRM.

read more

Tips and Tricks

Import your Data into RapidStart CRM

Many new users of RapidStart CRM have existing data sources they would like to import to get started. While not particularly complicated, working with data can be quite tedious.

read more

RapidStart CRM Setup for Pay as You Go

Microsoft recently introduced a Pay as You Go plan for Power Apps. RapidStart CRM just so happens to be a “Power App” so you can take advantage of this model if it fits your needs.

read more

Partner Stuff

Oh come on, Share This!

This is good stuff!!!