Supported Files

What kinds of files can you upload to bit.io?

File types

At bit.io, we currently support the following file types:

  • .csv
  • .json
  • .xls, .xlsx
  • .zip

CSVs

CSVs must be comma-delimited, with " as the quote character, if a quote character is used.

Google Sheets-exported CSVs and Excel-exported CSVs are supported.

JSON

bit.io will import JSON in the shape of a list of objects. Each object in the outer list represents a row. Each key in the object is a column header, and each value is a record in the created table. If a column header is missing in a row/object, a null value will be inserted at that column in that row.

[   
  { "column1": "value", "column2": 0, "column3": [ "val1", "val2" ] },
  { "column1": "value", "column2": 3, "column3": [ "val3", "val4" ] },
  { "column2": 4, "column3": [ "val5", "val6" ] }
]

will produce this table:

column1 (TEXT)

column2 (BIGINT)

column3 (JSON)

value

0

[ "val1", "val2" ]

value

3

[ "val3", "val4" ]

NULL

4

[ "val5", "val6" ]

If the outermost JSON container is an object ({}), not a list ([]), bit.io will infer that the table has one row, and the keys in this object are column names. For example,

{
  "name1": {"col1": 0, "col2": 1},
  "name2": {"col1": 1, "col2": 1},
  "name3": {"col1": 2, "col2": 1},
  "name4": {"col1": 3, "col2": 1}
}

will produce this table:

name1 (JSON)

name2 (JSON)

name3 (JSON)

name4 (JSON)

{"col1": 0, "col2": 1}

{"col1": 1, "col2": 1}

{"col1": 2, "col2": 1}

{"col1": 3, "col2": 1}

Excel

bit.io supports both .xls and .xlsx files.

Multi-sheet excel files are supported. One table will be created for every sheet.

ZIP

bit.io supports .zip files containing any of the aforementioned file types.

One table will be created for each supported file contained in the .zip. If a .zip file contains an excel file with multiple sheets, a table will be created for each sheet in the excel file.

.zip files containing other .zip files are not allowed.

Encoding

bit.io supports ASCII and UTF-8 encoded CSV files.

Maximum file size

Files uploaded through the REST API and the web console can be up to 1 GB in size.

Files uploaded via an email endpoint have a maximum size of 25 MB.


Did this page help you?