Streamlining data organization_

So what is a Table?

Our Table is essentially a database. It’s more structured than an Excel spreadsheet. That makes Tables better for organizing the massive datasets needed for complex calculations. You can add data to the Table with an action flow, similar to the integrations we support for Hubspot and GoogleSheets. A Table is available on the workspace level. So you can use the data on multiple calculators within the workspace. We shouldn’t confuse Tables with Datasheets. The ability to write data and the availability outside of a calculator makes Tables different. Datasheets are only available within a calculator, while Tables function on the workspace level. You can query data from external sources and use this as input for calculators with Tables. That makes this feature useful when creating a price quote calculator with large datasets. Use Table data to populate calculator option questions. Pulling data from a Table with Options From Formulas lets you make highly customized calculators.

Dollar icon

Manage pricing models

Easily set up and manage complex pricing models in calculators. Tables help you efficiently handle complex pricing structures and diverse pricing scenarios.

Formula icon

Dynamic calculations

Using Tables with formulas allows you to create dynamic calculations. Set up calculations based on a user’s personal answer to questions.

Switches icon

Simplified data entry

Filter data in a Table or add the entire Table to a calculator. It makes it easier to pull large datasets and saves you time.

Streamlining data organization_

So what is a Table?

Our Table is essentially a database. It’s more structured than an Excel spreadsheet. That makes Tables better for organizing the massive datasets needed for complex calculations. You can add data to the Table with an action flow, similar to the integrations we support for Hubspot and GoogleSheets. A Table is available on the workspace level. So you can use the data on multiple calculators within the workspace. We shouldn’t confuse Tables with Datasheets. The ability to write data and the availability outside of a calculator makes Tables different. Datasheets are only available within a calculator, while Tables function on the workspace level. You can query data from external sources and use this as input for calculators with Tables. That makes this feature useful when creating a price quote calculator with large datasets. Use Table data to populate calculator option questions. Pulling data from a Table with Options From Formulas lets you make highly customized calculators.

Dollar icon

Manage pricing models

Easily set up and manage complex pricing models in calculators. Tables help you efficiently handle complex pricing structures and diverse pricing scenarios.

Formula icon

Dynamic calculations

Using Tables with formulas allows you to create dynamic calculations. Set up calculations based on a user’s personal answer to questions.

Switches icon

Simplified data entry

Filter data in a Table or add the entire Table to a calculator. It makes it easier to pull large datasets and saves you time.

Structure your data simply_

Organize Massive Datasets

Complex calculations get messy if data is disorganized. Our Table is better than an Excel spreadsheet for organization purposes. It functions more like a simple database than a spreadsheet. Our Table is more structured and better equipped to arrange your massive datasets.

Create tables

Store your data anywhere_

Use External Data Points as Input

With Table functions, you can use external data points as input to create interactive calculators. That allows you to make calculations with your custom data. You can store your data on whatever central system you want without duplicating it on ConvertCalculator.

Create price quote calculators based on a table

Mighty calculation power_

Make Complex Calculations Easier

Using Tables makes complex calculations easier. Organize massive datasets and pull data from external sources. Dealing with large amounts of data is hard. But Tables make it easier, helping you create complex calculators with less effort.

Use Google Sheets or Airtable for price quote calcualtors

Structure your data simply_

Organize Massive Datasets

Complex calculations get messy if data is disorganized. Our Table is better than an Excel spreadsheet for organization purposes. It functions more like a simple database than a spreadsheet. Our Table is more structured and better equipped to arrange your massive datasets.

Create tables

Store your data anywhere_

Use External Data Points as Input

With Table functions, you can use external data points as input to create interactive calculators. That allows you to make calculations with your custom data. You can store your data on whatever central system you want without duplicating it on ConvertCalculator.

Create price quote calculators based on a table

Mighty calculation power_

Make Complex Calculations Easier

Using Tables makes complex calculations easier. Organize massive datasets and pull data from external sources. Dealing with large amounts of data is hard. But Tables make it easier, helping you create complex calculators with less effort.

Use Google Sheets or Airtable for price quote calcualtors

Organise, simplify and customize_

Powerful tables that give you more options

Table is essentially a database, better organized and with more functionality than Excel, perfect for big datasets and complex calculations.

Dataflow icon

Organization

A structured format for organizing data makes it easier to manage and build complex calculators.

Database icon

Lookup, Reference, and Query

Query other tables, client data, and data on the server with VLOOKUP, INDEX, and TABLE functions.

Wrench icon

Customization

Use Table data to populate calculator option questions. That makes it easy to create extensive custom calculators.

Data icon

Accuracy

Use your external data without duplicating it in the ConvertCalculator environment. Less room for error increases accuracy.

Speed icon

Efficiency

Tables make it easier for you to handle massive datasets. That increases efficiency when building calculators.

Table icon

Simplification

Create complex calculators more easily. Organizing huge datasets and pulling data from external sources simplifies the process.

Organize, customize, create_

Need to simplify complex calculations?

Our Table makes your life easier when building calculators.

FAQ_

FAQ: Tables for datasets

Visit our docs if you want to learn more, or reach out to our support team. We’re very responsive.

How can I create a Table using external data?

Creating a Table using external data is fast and easy. On the ConvertCalculator dashboard, you’ll see Tables as your third option on the left side. Click here to start creating your Table.

To use external data, you have the option to use Google Sheets or Airtable. You connect Tables with Google or Airtable before selecting the data you want to use.

Linking to external data is convenient, even more so if you want to change a value after you build your calculator. Let’s say you want to change the price of a product. Simply change the data in the external source, and the calculator will update automatically when it connects to the server.

Can I use Tables when building a calculator with various option questions?

Yes, you can use Tables when building a calculator with various option questions. You can create dynamic option questions with Options From Formulas and pull the data from a Table.

That makes it easier to build complex calculators. You can pull data from different Table sources and display that in an option question. Based on the answer to that question, you can then populate other option questions with filtered data from a Table.

Say you’re building a complex product configurator for a bike. The Table function is extremely efficient. You can use the data to assign different numerical values to question options to calculate the final price.

For instance, different models:

  • Sport = 150

  • Road = 100

  • Off-Road = 125

And you can do that for any customization in the CPQ (Configure - Price - Quote) form. Tables make calculating complex prices much easier.

Can I use different formulas in the separate cells of a Table?

Currently, you can’t use different formulas in the separate cells of a Table. Our Tables are more like databases than spreadsheets.

They make it easier to query data and organize it. Spreadsheets are less structured and messier with large datasets.

But you don’t need to use different formulas in the separate cells of a Table to make complex calculations. With Options From Formulas, you can pull data from a Table for your calculations. You can set up and manage complex pricing models - like in the example above.