---
title: "Map sheet columns"
method: POST
path: "/v1/sheets/{sheet_id}/mapping"
tags: ["Sheets"]
---

# Map sheet columns

`POST /v1/sheets/{sheet_id}/mapping`

Map the sheet columns to template columns and trigger validation for the mapped columns.

## Path parameters

- `sheet_id` integer, required

## Query parameters

- `embed_id` integer

## Request body

- MapColumnsRequest
  - `overrides` ColumnOverride[] — These mappings will override mappings created automatically. Either column_id or column_name must be specified. If template_column_key is null, the sheet column will not be mapped.
    - `column_id` integer — The id of the sheet column.
    - `column_name` string — The label of the sheet column.
    - `template_column_key` string, nullable, required — The key of the template column.
  - `autofix` boolean — Whether to autofix errors after the mapping step. This is akin to clicking the "Fix all formatting errors" button.
  - `strategies` string[] — Which mapping strategies to use in which order. Values are `exact`, `hint` (Alternative column names for mapping), `fuzzy`, `historical_user`, and `historical_org`. If `historical_user` and `historical_org` should be used it's preferred to provide `historical` instead.

## Response `200`

Successful response. The primary way to verify the request's success or failure is the response status code.
In a future API version this endpoint may not return any response body at all.

- MapColumnsResponse
  - `success` boolean

## Other responses

- `400` — 400

---

[API](https://skmtc.net/oneschema/apis/templates.md) · [All operations](https://skmtc.net/oneschema/apis/templates/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/oneschema/templates/versions/40674aa6d4d9/schema)