> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.datachamp.io/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Excel Formulas


## ${color}[#1a63ba](Using Excel Formulas in Your Export)

With DataChamp, you can add custom columns with Excel formulas to your Excel exports.


**1. Select File Type**
First, click on “File Type” and choose “Excel”.
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/file-type-excel_hmjazh.png)
**2. Add a Custom Column**
You can now add a custom column.
In the Value field, enter an Excel formula, e.g. consecutive numbering: `=ROW()-1`
||| The formula must always start with an “=” sign.

![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/add-custom-c_13lnxb8.png)
|| The consecutive number was only an example — you can  add the ‘Consecutive number’ field via browsing or the search function as well.

**3. Adjust Export Mode (optional)**
The Export Mode can also be modified.
For more information, please refer to the related help article about [Export Mode](/en/article/export-mode-35l3c/).
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/export-mode-fill_1j04x1z.png)
**4. Check the Preview**
Click “Preview” to review the results.

Note:
If the calculated value of the Excel formula is not displayed in the Preview:
1. Click “Save”
2. Then click “Run”
3. Download the report
In the downloaded Excel file, the formula results will be displayed correctly.

![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/scr-20260203-isrq_qgix9w.png)