The deals table view

Here is where you manage all the deal cards on your board in a classic table view. You can import or export and search by any field or combine filters to create more reports. But the deals table is so much more. Keep reading to learn about all the hidden features included in this view.



You can import your deals from a CSV or Excel file. For each imported row you will create a new deal card on your board and add a new contact to your database that will be available on any other board of your Crmble Team. Before you start importing, please take a look at your source file and make sure you have a deal and contact field available in Crmble to map with each column available in your source file. Before you start the field mapping (as shown in the screenshot example below), please prepare your source file following some simple rules to avoid issues.

  1. Make sure there are no blank rows in your source file
  2. Avoid mapping alphabetical characters with currency or numeric fields or vice versa.
  3. Convert all your source date fields to this format: YYYY-MM-DD HH:HH

Export all deals

With the Export to CSV or Excel function, you can export all your Crmble Deals by selecting the upper right checkbox.

Add Your Heading Text Here

You can also apply some search or filter options to export custom reports as shown in the screenshot. That simple!

Customize the table the way you want and save your configuration

By clicking on the burger menu icon that shows up when you hover over any header, you’ll see some useful options that will apply to the whole table.

The options are divided into three tabs (left to right):

Column options

  • Pin columns to the left or right of the table
  • Autosize all or just one column to see the full content
  • Reset columns
Filter options
  • Combine and apply different filters to a column
Columns visibility
  • Check or uncheck columns to customize the table view

Feel free to move columns around to change their order of appearance. If you would like to keep this configuration next time you access the table section, just click the “save view” option.

Search your Crmble fields

Trello board search comes in handy when you need to find a card by its title, description or activity,  but when you want to search your Crmble fields, the Deals table is the way to go.

Use the field header of any given Crmble fields column to find a card. Use the Trello link to open the card of your search result.

Generate custom reports using the advanced filter options

You can generate some advanced reports using the filter options with conditional logic.

Let’s say you want just to export your Facebook or Instagram leads. Just click on the burger menu of your “Source” column and create your filter and Oilá!

Now you can select all the resulting deals by clicking the upper left general checkbox and  export them to a CSV or Excel file to share your report or work on it on your Spreadsheet tool of choice.

Sums à la carte

In the deals table view, you can also sum any currency or numeric type of field.

In the example below we have filtered by “Walk in” deals. By clicking and dragging you can select different deal values to get sum, average, count, minimum and maximum value. Clever, eh?

Pin columns

Pinning columns makes navigating your Crmble deals so much easier. Sometimes you need to compare specific columns and normally this can only be achieved by moving around columns, scrolling and searching the ones you need. Pinning is a much faster way to do this. Just find the columns you want, click on the header drop-down menu, select Pin Columns, and select the right or left pin option. Done!


Combinations are unlimited as you can have one column pinned on the left and another two on the right for instance. Feel free to drag and move pinned and as well as unpinned columns till you find the exact way you want your data to be shown.

Autosize columns

Adjust column width to its content. Right click anywhere on the table to “Autosize All Columns” or use the column drop down menu of any specific column to adjust its size.