Wave

Making Your First Grid

Turn any Salesforce object into an editable spreadsheet in under 5 minutes. Bulk edit, filter, sort, and save — all without leaving Salesforce.
Product
Wave
use case

Here’s What You’re Building

Before we walk through the steps, here’s the end result — the grid you’ll have running in under 5 minutes.

What you'll have

A live, editable spreadsheet of your Salesforce Opportunities — with inline editing, conditional formatting that highlights problems instantly, filters to narrow to exactly the records you need, and a Save button that pushes every change back to Salesforce in one click. All running natively inside Salesforce, no extra windows needed.

What this replaces

Opening each Opportunity record one at a time, clicking Edit, changing a field, clicking Save, navigating back, and repeating 200 times. Or exporting to Excel, editing offline, and re-importing stale data. The grid does all of that in a single view.

Real-life example

Every Monday your Sales Ops team needs each rep’s pipeline broken out by month. Today that means exporting to Excel, building a pivot table, and manually updating Salesforce afterward. With a Matrix, you build that view once — Accounts on the Y-axis, Close Date (monthly) on the X-axis, Amount as the data — and from that point on it’s live, editable, and always current. That’s what this guide builds.

Want this? Follow the 6 steps below.

Time: ~5 minutes  |  Role: Any Wave User |  Platform: Wave Embedded in Salesforce

Prerequisites

  1. Valorx Wave embedded package installed in your Salesforce org
  1. A Designer or Admin role to create grids (Standard Users can view and interact with shared grids)
  1. A Salesforce object you want to work with (e.g. Opportunity, Account, Case, Contact — or any custom object)

Build Your First Grid

We’ll use Opportunities as the example — the most common first grid for sales teams.

Step 1: Open the Wave Dashboard in Salesforce

Navigate to the Valorx Wave app inside Salesforce. You can find it in the App Launcher (the waffle icon in the top-left) — search for “Valorx Wave” and click to open.

You’ll land on the Wave Dashboard tab. If this is your first time, you’ll see a “Create Your 1st Grid” prompt. Otherwise, click the Add New button in the top right, or navigate to the Grid Wizard tab.

Step 2: Select Your Object & Name the Grid

The Grid Wizard opens inside Salesforce. First, search for and select your Salesforce object — pick Opportunity for this example.

Then choose how to start:

Create from Scratch: Start with a blank grid and manually add the fields you want.

Select from an Existing List View: Pull in a Salesforce list view you’ve already built — fields and filters carry over automatically.

Give your grid a name (e.g. “Pipeline Review — CQ”) and optionally add a description. Click Next

Tip: Starting from a list view is the fastest way to get up and running — your existing field selections and filters come over in one click.

Step 3: Choose Your Fields

Select the fields that will appear as columns in your grid. Use the + button to add fields and drag-and-drop to reorder them. For our pipeline grid, pick:

Opportunity Name, Stage, Amount, Close Date, Owner, Account Name, Probability

You can also configure fields here — rename column headers, mark fields as required, set defaults for new records, or hide fields that should run in the background without appearing in the grid.

Click Next when you’re happy with the field selection.

Step 4: Add Filters (Optional but Powerful)

Filters narrow down which records appear in your grid. For a pipeline review, you might filter to:

Close Date = This Quarter and Stage ≠ Closed Won

Click Add a Filter for single conditions, or Add a Filter Group to combine multiple conditions with AND/OR logic. You can even use Cross Filters to filter parent records by related child data.

Tip: Starting from a list view is the fastest way to get up and running — your existing field selections and filters come over in one click.

Step 5: Set Display Option

Customize how your grid looks and behaves:

Rules (Conditional Formatting): Highlight records based on field values — e.g. red when Close Date is past due, green when Stage is “Closed Won.”

Sort: Set a default sort order (e.g. Close Date ascending) so records always appear in a useful order.

Layout: Freeze key columns (like Opportunity Name) so they stay visible when scrolling.

Related Lists: Add related records (like Contacts or Activities) as a panel alongside each row for full context.

Click Next when done.

Step 6: Save & Surf Your Grid

This is where you can enable all the different grid controls for your team. You can allow them to edit filters, add or remove fields, or changing display options.

Tip: Want to share this grid with your team? Open Manage Grid, toggle on Global Grid, and assign users. Since Wave Embedded lives inside Salesforce, anyone with the app installed can access shared grids immediately.

Click Save & Surf to save your grid configuration.  

You’re now looking at the exact outcome from the top of this guide — a live spreadsheet of your Salesforce data, fully embedded in your Salesforce environment.

Grids Your Team Can Build Today

The same 6 steps work for any Salesforce object. Here are four popular grids teams build first.

Use Case Object Key Fields Filter
Pipeline Cleanup Opportunity Stage, Close Date, Amount Close Date < Today
Contact Data Hygiene Contact Name, Email, Phone, Account Email = blank
Case Queue Processing Case Subject, Status, Priority, Owner Status ≠ Closed
Account Territory Assignment Account Name, Owner, Territory, Industry Territory = blank

Updating 200 Records, Two Ways

The difference between native Salesforce editing and a Wave Grid.

Without Wave Grid With Wave Grid
Open each record one at a time, edit, save, repeat 200x See all 200 records in one spreadsheet — click and type to edit
Use Data Loader for bulk updates (technical, admin-only) Mass Modifier: change a field across selected rows in one action
Export to Excel, edit, re-import — data goes stale Data is always live — no exports, no sync, no stale copies
No inline conditional highlights or related data Conditional formatting highlights problems instantly
Each rep builds their own workaround Build once, share with the team as a Global Grid

Ready to Build Your First Grid?

Install the Wave embedded package in your Salesforce org, pick any object, and have a working grid in under 5 minutes.