---
name: "rows"
section: "1"
platform: "linux"
package: "rows"
version: "0.5.0~dev0~1~1d5a326-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/rows"
---

# rows(1)

common, beautiful interface to tabular data, no matter the format

## NAME

**rows** - common, beautiful interface to tabular data, no matter the format

## SYNOPSIS

```
rows [OPTIONS] COMMAND [ARGS] ...
```

## DESCRIPTION

**No matter in which format your tabular data is: rows will import it,** **automatically detect types and give you high-level Python objects so you can** **start working with the data instead of trying to parse it.** **It is also locale-and-unicode aware.**

## OPTIONS

**--help Show this message and exit**

## COMMANDS

```
 convert - Convert table on `source` URI to...
 join    - Join tables from `source` URIs using `key(s)`...
 sort    - Sort from `source` by `key(s)` and save into...
 sum     - Sum tables from `source` URIs and save into...
  SYNOPSIS
  rows convert [OPTIONS] SOURCE DESTINATION
  DESCRIPTION
    Convert table on `source` URI to `destination`
  OPTIONS
    --input-encoding TEXT
    --output-encoding TEXT
    --input-locale TEXT
    --output-locale TEXT
    --help Show this message and exit.
  SYNOPSIS
  rows join [OPTIONS] KEYS SOURCES ... DESTINATION
  DESCRIPTION
    Join tables from `source` URIs using `key(s)` to group rows and save into destination`
  OPTIONS
    --input-encoding TEXT
    --output-encoding TEXT
    --input-locale TEXT
    --output-locale TEXT
    --help Show this message and exit.
  SYNOPSIS
  rows sort [OPTIONS] KEY SOURCE DESTINATION
  DESCRIPTION
    Sort from `source` by `key(s)` and save into `destination`
  OPTIONS
    --input-encoding TEXT
    --output-encoding TEXT
    --input-locale TEXT
    --output-locale TEXT
    --help Show this message and exit.
  SYNOPSIS
  rows sum [OPTIONS] SOURCES ... DESTINATION
  DESCRIPTION
    Sum tables from `source` URIs and save into `destination`
  OPTIONS
    --input-encoding TEXT
    --output-encoding TEXT
    --input-locale TEXT
    --output-locale TEXT
    --help Show this message and exit.
```

## EXAMPLES

- •

  **To export csv from site and converting locales from pt\_BR to en both UTF-8**

```
    rows convert --input-locale pt_BR.UTF-8 --output-locale en.UTF-8 "<URL>" data.csv
```

- •

  **To export xls from site and no changes locales**

```
    rows convert "<URL>" data.xls
```

- •

  **To convert csv to xls**

```
    rows convert file.csv file.xls
```

## REPORTING BUGS

**To report a bug please visit rows' issue tracking system at** **\<https://github.com/turicas/rows/issues\>.**

## AUTHOR

**Written by Álvaro Justen \<alvarojusten@gmail.com\>.**

**This manual page was written by Paulo Roberto Alves de Oliveira (aka kretcheu)** **\<kretcheu@gmail.com\> for the Debian project (but may be used by others).**

## COPYRIGHT

**Copyright © 2014-2015 Álvaro Justen.** **License GPLv3+: GNU GPL version 3 or later \<http://gnu.org/licenses/gpl.html\>.** **This is free software: you are free to change and redistribute it. There is NO** **WARRANTY, to the extent permitted by law.**