2. Process your data
💡 Once your data is in Tablize, you can use it to manipulate and process your data in various ways, such as performing calculations, summations, counting, data matching, and conditional data operations. Tablize provides a user-friendly formula operation panel to help you quickly clean and transform your data.
📖 This document will provide examples of basic data processing to inspire you and assist you in getting started with Tablize quickly.
Tablize has prepared sample data for you. You can click to download it here: Sample Data
Data Processing
In the order table, column DF6 represents the quantity of the products, and column DF7 represents the unit price of the products.
We can calculate the total price of the items by multiplying the values in column DF6 by the values in column DF7.
- You can add a new column, DF8, and name it "Total Price."
- In the DF8 column's formula bar, you can enter the formula DF6*DF7 to calculate the Total Price.
- You can also calculate any additional data you require based on your needs. For more guidance on data processing, please consult the Data Processing section or refer to the All formula catalog.
Exporting Data to Excel
After processing your data, you can continue to create Data Views, or you can export the data as an Excel file for future use.
Click on "Export" at the top right corner of the data table to export the Tablize table as an Excel file.
