Convert TSV to BSON

Turn TSV files into BSON. One BSON document with the same keys in order; a top-level list is wrapped under the key items and any other value under value.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop TSV files on the dialor turn it to pick what to do

TSV rows as one BSON document.Keys keep their order, and values keep their types.

  1. What you get

    One BSON file holding a single document. The keys come out in the same order as in the source, so the document reads the way the data did.

    Integers, floats, booleans, null, text, nested objects and nested lists keep their types. They are not all turned into text.

  2. How values are wrapped

    BSON needs a document at the top. When the top level of the data is a list, it is wrapped under the key items. Any other value is wrapped under the key value.

  3. What changes

    Dates stay text. They are written as strings in the document.

    Integers beyond the signed 64-bit range become floats.

TSV and BSON.What each format is.

The formats

From · TSV

Tab-Separated Values

Tab-separated values.

Extensions
.tsv .tab
MIME type
text/tab-separated-values
Kind
Text and data
To · BSON

BSON

MongoDB's binary document encoding, JSON with dates and binary fields.

Extensions
.bson
MIME type
application/bson
Kind
Text and data

In your code.The same TSV to BSON conversion through the API, for your app or your agent.

terminal
$ cv convert sheet.tsv sheet.bson
$ cv convert sheet.tsv sheet.bson

Questions.What people ask about TSV to BSON.

01OF 04

No. The document has the same keys in the same order.

It is wrapped under the key items, so the document has a key to hold it.

No. Dates stay text.

Integers beyond the signed 64-bit range become floats. Integers inside that range stay integers.

More conversions.Other ways in and out of TSV and BSON.