Working with RapidStart CRM Data Using Excel Online

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.

ex1

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

ex2

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.

ex3

(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”

ex5

We have nine cases that meet our filters

ex6

After editing the Priority Field, we click Save.

ex8

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.

Subscribe to Our Blog

* indicates required

Check out some Apps From RapidStart CRM

checkoutrapidstart

checkoutrapidstart

checkoutproject

checkoutproject

checkoutfieldservice

checkoutfieldservice

Read our App Documentation

RapidStart CRM is built on Microsoft’s Dataverse, the foundation of the Power Platform and Dynamics 365. This means that RapidStart CRM Plus 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