---
title: "exceldecode"
slug: "exceldecode"
updated: 2024-11-07T13:15:19Z
published: 2024-11-07T13:15:19Z
canonical: "docs.datajet.app/exceldecode"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# exceldecode

Creates a mapping between a source value and a new output value by reading codes from excel

| Key | Value(s) | Description |
| --- | --- | --- |
| method | "buildBakedField" | Creates a mapping between a source value and a new output value by reading codes from excel |
| targetTable | "TableName" |  |
| p1 | "SourceFieldName" |  |
| overwrite | true/false |  |
| name | "DecodeName" |  |
| function | "exceldecode" |  |
| forceString | true/false |  |
| workbook | "WorkbookPathandFile" |  |
| worksheet | "WorksheetName" |  |
| codeColumn | "ColumnLetter" | The column to look in for the existing field value (input value). e.g., A |
| decodeColumn | "ColumnLetter" | The column to look in for the decode value (output value) e.g., B |
| wild | true/false |  |
| regex | true/false |  |
| row | RowNumber |  |

{Explanation}

```json
{
  "method": "BuildBakedField",
  "project": "SalesData1",
  "targetTable": "Sales",
  "p1": "Product",
  "overwrite": true,
  "name": "Segment Code",
  "function": "exceldecode",
  "forceString": false,
  "workbook": "%DATAPATH%05_LookupFiles/ClothingDecodes01.xlsx",
  "worksheet": "Article Scoring Table",
  "codeColumn": "A",
  "decodeColumn": "B",
  "wild": false,
  "regex": false,
  "row": 2
}
```

## Related

- [Step 4a - Prepare Data for Reporting - Decodes](/step-4a-prepare-data-for-reporting-decodes.md)
- [Decode Field - Custom](/decode-field-custom.md)
- [Decode Fields - Wild](/decode-fields-wild.md)
- [BulkDecode](/bulkdecode.md)
- [Database Build and Preparation](/getting-started-database-build-and-preparation.md)