IN2CSV(1)                           csvkit                           IN2CSV(1)

<?><?><?> (NAME)
       in2csv - <?><?><?><?><?> <?><?><?><?><?><?><?><?> <?><?><?><?><?>
       <?><?><?><?><?><?><?><?> <?><?><?><?><?> <?><?> CSV

<?><?><?><?><?><?><?> (DESCRIPTION)
       <?><?><?><?><?><?><?><?> <?><?><?><?><?><?><?> <?><?><?><?><?><?><?><?>
       <?><?><?><?><?> <?><?> <?><?> CSV <?><?><?><?><?> <?><?><?><?><?><?>.

       <?><?><?><?><?> <?><?><?><?><?><?><?><?><?><?> <?><?> <?><?><?>
       <?><?><?><?> (fixed width) <?><?><?><?><?><?> <?><?><?><?><?> <?><?>
       <?><?><?><?> <?><?><?><?><?><?><?> (schema) <?><?> <?><?><?><?><?> "-s"
       <?><?><?>. <?><?><?><?> <?><?><?><?><?><?><?> <?><?><?><?>
       <?><?><?><?><?><?> <?><?><?> <?><?> <?><?><?><?><?> <?><?><?><?>:

          column,start,length
          name,0,30
          birthday,30,10
          age,40,3

       <?><?><?> <?><?><?><?><?><?> <?><?><?><?><?><?> <?><?><?><?>
       <?><?><?><?><?> <?><?><?><?><?><?><?> <?><?><?><?><?><?><?><?><?>
       <?><?> <?><?> <?><?><?><?><?><?> <?><?><?><?><?>:

          usage: in2csv [-h] [-d DELIMITER] [-t] [-q QUOTECHAR] [-u {0,1,2,3}] [-b]
                        [-p ESCAPECHAR] [-z FIELD_SIZE_LIMIT] [-e ENCODING] [-L LOCALE]
                        [-S] [--blanks] [--null-value NULL_VALUES [NULL_VALUES ...]]
                        [--date-format DATE_FORMAT] [--datetime-format DATETIME_FORMAT]
                        [-H] [-K SKIP_LINES] [-v] [-l] [--zero] [-V]
                        [-f {csv,dbf,fixed,geojson,json,ndjson,xls,xlsx}] [-s SCHEMA]
                        [-k KEY] [-n] [--sheet SHEET] [--write-sheets WRITE_SHEETS]
                        [--use-sheet-names] [--reset-dimensions]
                        [--encoding-xls ENCODING_XLS] [-y SNIFF_LIMIT] [-I]
                        [FILE]

          Convert common, but less awesome, tabular data formats to CSV.

          positional arguments:
            FILE                  The CSV file to operate on. If omitted, will accept
                                  input as piped data via STDIN.

          optional arguments:
            -h, --help            show this help message and exit
            -f {csv,dbf,fixed,geojson,json,ndjson,xls,xlsx}, --format {csv,dbf,fixed,geojson,json,ndjson,xls,xlsx}
                                  The format of the input file. If not specified will be
                                  inferred from the file type.
            -s SCHEMA, --schema SCHEMA
                                  Specify a CSV-formatted schema file for converting
                                  fixed-width files. See web documentation.
            -k KEY, --key KEY     Specify a top-level key to look within for a list of
                                  objects to be converted when processing JSON.
            -n, --names           Display sheet names from the input Excel file.
            --sheet SHEET         The name of the Excel sheet to operate on.
            --write-sheets WRITE_SHEETS
                                  The names of the Excel sheets to write to files, or
                                  "-" to write all sheets.
            --use-sheet-names     Use the sheet names as file names when --write-sheets
                                  is set.
            --reset-dimensions    Ignore the sheet dimensions provided by the XLSX file.
            --encoding-xls ENCODING_XLS
                                  Specify the encoding of the input XLS file.
            -y SNIFF_LIMIT, --snifflimit SNIFF_LIMIT
                                  Limit CSV dialect sniffing to the specified number of
                                  bytes. Specify "0" to disable sniffing entirely, or
                                  "-1" to sniff the entire file.
            -I, --no-inference    Disable type inference (and --locale, --date-format,
                                  --datetime-format, --no-leading-zeroes) when parsing
                                  CSV input.

           Some command-line flags only pertain to specific input formats.

       <?><?><?><?><?><?> <?><?><?><?><?><?>:
       <?><?><?><?><?><?><?><?><?><?><?> <?><?><?><?><?> <?><?><?><?>
       <?><?><?><?> <?><?><?><?><?><?><?>.

       <?><?><?><?>:
          <?><?><?><?> "ndjson" <?><?> <?><?><?><?><?> "JSON <?><?>
          <?><?><?><?><?><?><?><?> <?><?> <?><?><?><?>" (newline delimited
          JSON) <?><?><?> <?><?> <?><?> <?><?><?><?><?><?> <?><?> API<?><?><?>
          <?><?><?><?><?><?> <?><?><?><?><?><?><?> <?><?><?><?><?><?>.

       <?><?><?><?>:
          <?><?><?> <?><?> <?><?><?><?> XLS <?><?><?><?><?> <?><?><?><?><?><?>
          <?><?> <?><?><?><?> <?><?><?><?><?><?> <?><?><?><?><?> <?><?> <?><?>
          <?><?><?><?> XLSX <?><?> <?><?><?> <?><?><?><?><?> <?><?><?><?>
          <?><?><?> <?><?> <?><?><?><?><?> CSV <?><?><?><?><?>
          <?><?><?><?><?><?>. <?><?><?><?> <?><?><?><?><?> XLSX <?><?><?>
          <?><?><?><?> <?><?><?> <?><?><?><?> <?><?><?><?> <?><?><?> XLS
          <?><?><?><?><?>. <?><?><?><?><?><?> <?><?> <?><?> <?><?>
          <?><?><?><?> XLS <?><?><?><?><?> <?><?><?><?><?> <?><?><?><?> <?><?>
          <?><?><?> <?><?><?><?><?><?><?> <?><?> CSV <?><?><?><?><?>
          <?><?><?><?><?> <?><?><?><?><?><?> <?><?><?><?> <?><?> <?><?><?><?>
          <?><?> <?><?> <?><?><?><?> XLSX <?><?><?><?> <?><?><?><?><?><?>
          <?><?><?>.

       <?><?><?><?>:
          <?><?><?> <?><?><?><?><?> <?><?> <?><?><?><?> HTML<?>
          <?><?><?><?><?> messytables <?><?> <?><?> <?><?><?> <?><?><?><?>
          <?><?><?><?>.

<?><?><?><?><?><?><?> (EXAMPLES)
       <?><?><?><?><?> <?><?><?><?> <?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?> <?><?><?><?><?><?><?> <?><?><?><?> <?><?>
       <?><?><?> <?><?><?><?> <?><?> CSV <?> <?><?> <?><?><?><?><?><?><?>
       latin-1 <?><?> utf8:

          in2csv -e iso-8859-1 -f fixed -s examples/realdata/census_2000/census2000_geo_schema.csv examples/realdata/census_2000/usgeo_excerpt.upl

       <?><?><?><?>:
          <?><?><?><?><?><?><?><?><?> <?><?> <?><?><?><?><?><?><?><?><?><?><?>
          <?><?> <?><?><?> <?><?><?><?> <?><?> <?><?><?><?><?> ffs
          <?><?><?><?><?><?><?> <?><?><?><?><?><?>:

          https://github.com/wireservice/ffs

       <?><?><?><?><?> <?><?> <?><?><?><?> <?><?><?><?> .xls:

          in2csv examples/test.xls

       <?><?><?><?><?><?><?><?><?><?><?><?><?> <?><?><?><?><?><?><?><?><?>
       <?><?> <?><?><?><?> CSV (<?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?> <?><?><?><?> <?> <?><?><?><?>):

          in2csv examples/realdata/FY09_EDU_Recipients_by_State.csv

       <?><?><?><?><?><?> issue<?><?><?> <?><?><?> csvkit <?><?>
       <?><?><?><?><?><?><?><?> <?><?><?><?><?><?><?><?> <?><?><?><?><?>
       <?><?><?><?> JSON <?><?> CSV <?> <?><?><?><?><?> <?><?> <?><?> <?><?>
       <?><?><?><?>:

          curl https://api.github.com/repos/wireservice/csvkit/issues?state=open | in2csv -f json -v

       <?><?><?><?><?> <?><?> <?><?><?><?> DBase DBF <?><?> <?><?><?><?><?>
       CSV <?><?>:

          in2csv examples/testdbf.dbf

       <?><?><?> <?><?><?><?><?> <?><?> <?><?><?><?><?><?><?><?><?>
       <?><?><?><?> <?><?><?><?> <?><?><?> <?><?><?><?><?><?>
       <?><?><?><?><?><?>. <?><?><?><?> <?><?><?><?><?><?><?> <?><?> <?><?><?>
       <?><?><?><?><?> <?><?><?><?> <?><?><?><?>:

          in2csv --no-header-row examples/test.xlsx | tail -n +2

<?><?><?><?><?><?><?><?> (TROUBLESHOOTING)
       <?><?><?> <?><?><?><?><?> <?><?><?><?><?> <?><?><?><?> <?><?><?><?><?>
       <?><?> <?><?><?><?> CSV <?><?> <?><?><?><?> <?><?><?><?><?>
       <?><?><?><?><?> <?><?><?><?> <?><?><?> <?><?> <?><?><?>:

          ValueError: Row 0 has 11 values, but Table only has 1 columns.

       <?><?><?><?> <?><?><?> <?><?><?><?> <?><?><?><?><?> <?><?><?><?><?>
       <?><?><?><?><?><?><?> <?><?><?><?><?><?><?> <?><?><?> <?><?> <?><?><?>
       <?><?><?><?><?><?> <?> <?><?><?><?><?><?><?> <?><?><?><?> <?><?><?><?>.
       <?><?><?><?><?><?><?><?><?> <?><?> <?><?><?><?><?><?><?> <?><?>
       --skip-lines (-K) <?><?><?> <?><?><?><?><?><?><?> <?><?>
       <?><?><?><?><?><?> <?><?><?><?><?><?>:

          in2csv --skip-lines 3 examples/test_skip_lines.csv

       <?><?><?> <?><?> <?><?><?><?> XLSX <?><?><?><?><?><?> <?><?>
       <?><?><?><?><?><?><?><?> <?><?><?><?><?> <?><?><?> <?><?><?><?><?>
       <?><?><?><?> <?><?><?><?> <?><?><?> <?><?><?><?><?><?><?><?><?> <?><?>
       <?><?><?><?> <?><?> <?><?><?><?><?> <?><?><?><?> <?><?><?><?><?>
       <?><?><?><?><?><?> <?><?> <?><?><?><?><?><?> <?><?><?><?><?>
       <?><?><?><?> <?><?><?><?>. <?><?><?><?><?><?> <?><?> <?><?><?><?><?>
       --reset-dimensions <?><?><?><?><?><?> <?><?><?><?>.

<?><?><?><?><?><?><?> (AUTHOR)
       Christopher Groskopf <?> <?><?><?><?><?><?><?><?><?><?><?><?><?><?>

<?><?> <?><?><?> (COPYRIGHT)
       2016, Christopher Groskopf and James McKinney

2.2.0                           August 16, 2024                      IN2CSV(1)