# allyhub sheet import

> Makes a sheet of an Excel, CSV or TSV file: its sheets, tables, formulas, names and looks as a sheet file and CSV files, listed in allyhub.yaml, said what could not be carried over, each formula computed here and compared with the value the file holds; never over a file that is there

Source: https://allyhub.com/docs/reference/cli/sheet-import · AllyHub 0.10.0
Index of all docs: https://allyhub.com/llms.txt

## Usage

```bash
allyhub sheet import [file] [options]
```

## Arguments

| Argument | Type | What it is |
| --- | --- | --- |
| `<file>` | string | The file to make a sheet of: .xlsx, .xlsm, .csv or .tsv |

## Options

| Option | Type | Default | What it does |
| --- | --- | --- | --- |
| `--to` | string |  | The sheet's file, from the project's root (default &lt;the file's name&gt;.yaml); its tables' CSV files go beside it, under names no file there has |
| `--max-unzipped` | number | `1536` | MB the file may unzip to, a file past it refused |
| `--tolerance` | number | `1e-9` | How far apart a computed number and the file's may be, as a share of the larger, and count as the same; 0 lists every difference |
| `--all` | boolean | `false` | Every difference, not the first 50 |

## Global options

`--dir <value>`: the project's folder; default the one around where it is run. `--json`: print the result as JSON.

## Examples

```bash
allyhub sheet import ~/Downloads/forecast.xlsx --to finance/forecast.yaml
allyhub sheet import ~/Downloads/leads.csv --to research/leads.yaml
```

## Exit codes

`0` when it succeeds; the others are listed in [Exit codes](https://allyhub.com/docs/reference/cli/exit-codes.md).

## In the work

**sheets**: Making a sheet

[`sheet capabilities`](https://allyhub.com/docs/reference/cli/sheet-capabilities.md) → `sheet import` → [`sheet calc`](https://allyhub.com/docs/reference/cli/sheet-calc.md) → [`sheet trace`](https://allyhub.com/docs/reference/cli/sheet-trace.md) → [`sheet diff`](https://allyhub.com/docs/reference/cli/sheet-diff.md) → [`inspect sheet`](https://allyhub.com/docs/reference/cli/inspect-sheet.md) → [`sheet`](https://allyhub.com/docs/reference/cli/sheet.md) → [`frames`](https://allyhub.com/docs/reference/cli/frames.md) → [`check`](https://allyhub.com/docs/reference/cli/check.md) → [`dev`](https://allyhub.com/docs/reference/cli/dev.md) → [`render`](https://allyhub.com/docs/reference/cli/render.md)
