> For the complete documentation index, see [llms.txt](https://cgps.gitbook.io/data-flo/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://cgps.gitbook.io/data-flo/reference-guide/import-from-spreadsheet-file.md).

# import-from-spreadsheet-file

## Description

<mark style="color:purple;">`import-from-spreadsheet-file`</mark> *adaptor imports data from a spreadsheet file in one of the following file formats*: `.xlsx`, `.xls`, `.xlsm`, `.xlsb`, `.ods`, `.fods`, `.sylk`, `.html`, `.dif`, `.dbf`, `.rtf`, `.prn`, and `.eth`.

## Inputs

**`file`**\
Type: `file`\
Required: Yes\
The spreadsheet file in one of the following file formats: `.xlsx`, `.xls`, `.xlsm`, `.xlsb`, `.ods`, `.fods`, `.sylk`, `.html`, `.dif`, `.dbf`, `.prn`, and `.eth`.

**`sheet name`**\
Type: `text`\
Required: No\
The name of the sheet (tab) from which to import the data. If unspecified, the first sheet will be used.

**`range`**\
Type: `text`\
Required: No\
A valid range of cells (e.g. `A1:L512`) that contain data. If unspecified, the whole sheet will be included.

## Outputs

**`data`**\
Type: `datatable`\
A datatable containing the imported data.

## Examples

### Example 1: Default behaviour.

#### Inputs:

`file:` data.xlsx

`sheet name:` *null (empty)*

`range:` *null (empty)*

#### Outputs:

`data`:

| id       | latitude    | longitude    |
| -------- | ----------- | ------------ |
| Sample A | 4.642276772 | -8.17536836  |
| Sample B | 5.063345736 | -9.051186684 |
| Sample C | 5.063345736 | -9.051186684 |
| Sample D | 4.638091468 | -8.17536836  |

-> Imported the spreadsheet file `data.xlsx` into Data-flo.

### Example 2: Import data from spreadsheet within specific range.

#### Inputs:

`url:` data.xlsx

`sheet name:` *null (empty)*

`range:` A1:C4

#### Outputs:

`data`:

| id       | latitude    | longitude    |
| -------- | ----------- | ------------ |
| Sample A | 4.642276772 | -8.17536836  |
| Sample B | 5.063345736 | -9.051186684 |
| Sample C | 5.063345736 | -9.051186684 |

-> Imported the spreadsheet within the range `A1:C4`.