---
title: "Import sheet from CSV / XLSX"
method: POST
path: "/sheets/import"
tags: ["imports"]
deprecated: true
---

# Import sheet from CSV / XLSX

`POST /sheets/import`

> **Deprecated.**

Imports CSV or XLSX data into a new sheet in the top-level "Sheets" folder.

Note the following:

* Both sheetName and the file name must use ASCII characters.

* The source data must be basic text. To include rich formula data, import
and create a sheet first, and then use Update Rows. To work with images, see
Cell Images.

* XLS is not supported. You must use XLSX.

* Hierarchical relationships between rows in an external file won't import.

**DEPRECATED** - The Sheets folder is being replaced by workspaces. To adapt to this change, please see [Migrate from using the Sheets folder](/api/smartsheet/guides/updating-code/migrate-from-using-the-sheets-folder).

## Query parameters

- `sheetName` string, required
- `headerRowIndex` number
- `primaryColumnIndex` number

## Headers

- `Content-Disposition` string
- `Content-Type` 'text/csv' | 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', required

## Response `200`

Result object containing a Sheet object for imported sheet.

- object
  - `message` 'PARTIAL_SUCCESS' | 'SUCCESS' — Message that indicates the outcome of the request. (One of `SUCCESS` or `PARTIAL_SUCCESS`.)
  - `resultCode` 0 | 3 — * '0' Success * '3' Partial Success of Bulk Operation
  - `result` SheetImported — Sheet imported from CSV / XLSX file.
    - `accessLevel` 'ADMIN' | 'COMMENTER' | 'EDITOR' | 'EDITOR_SHARE' | 'OWNER' | 'VIEWER'
    - `id` number — Sheet ID.
    - `name` string — Sheet name.
    - `type` string — Container type. Has 'sheet' value for the imported sheet.
    - `permalink` string — URL that represents a direct link to the sheet in Smartsheet.

## Other responses

- `default` — Generic Error Payload

---

[API](https://skmtc.net/smartsheet/apis/smartsheet-openapi-reference.md) · [All operations](https://skmtc.net/smartsheet/apis/smartsheet-openapi-reference/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/smartsheet/smartsheet-openapi-reference/versions/b4afda95fb51/schema)