---
title: "CreateExportTemplate"
slug: "createexporttemplate"
updated: 2023-08-10T08:20:09Z
published: 2023-08-10T08:20:09Z
canonical: "docs.datajet.app/createexporttemplate"
---

> ## 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.

# CreateExportTemplate

Creates an export template for use with ExportIntoWorkbook and ExportIntoTable.

| Key | Value | Description |
| --- | --- | --- |
| method | "CreateExportTemplate" | Creates an export template for use with ExportIntoWorkbook |
| name | "TemplateName" | Name of template. This is the name that will be used to identify the template in methods that make use of it. |
| filename | "PathAndFilename.xlsx" | Full path and filename to the excel spreadsheet that contains template formatting. |
| worksheet | "WorksheetName" | Worksheet name containing template data |
| headerRow | RowNum | Row Containing header data |
| project | "ProjectName" | Current project name. |

When Exporting data from a table to a workbook, it is possible to use a workbook that has a template applied. The template determines the formatting of the generated workbook.

Before a template can be applied in [ExportIntoWorkbook](/v1/docs/exportintoworkbook), it must first be created using CreateExportTemplate

```json
{
  "method": "CreateExportTemplate",
  "name": "Export Template 1",
  "fromWorkbook": {
    "filename": "%DATAPATH%/a.xlsx",
    "worksheet": "Index",
    "headerRow": 2
  },
  "project": "MyProject"
}
```

ExportTemplates can also be used to determine which fields to export when using [ExportIntoTable](/v1/docs/exportintotable). ExportIntoTable will extract field names from the ExportTemplate, and export only those fields into the new table.