WOLFRAM

Wolfram Language & System Documentation Center
Wolfram Language Home Page »

TSV (.tsv)

Updatedshow changeshide changes
  • Import and Export fully support the TSV format and provide various data conversion and formatting options.
  • Import automatically recognizes common number formats, including C and Fortran notations.
  • Numbers without decimal points are imported as integers.

Background & Context

    • MIME type: text/tab-separated-values
    • TSV tabular data format.
    • Stores records of numerical and textual information as lines, using tab characters to separate fields.
    • TSV is an acronym for Tab-Separated Values.
    • Plain text format.
    • Similar to CSV.

Import & Export

  • Import["file.tsv"] returns a list of lists containing strings and numbers, representing the rows and columns stored in the file.
  • Import["file.tsv",elem] imports the specified element from a TSV file.
  • Import["file.tsv",{elem,sub1,…}] imports subelements, specifically useful for partial data import.
  • The import format can be specified with Import["file","TSV"] or Import["file",{"TSV",elem,…}].
  • Export["file.tsv",expr] creates a TSV file from expr.
  • Supported expressions expr include:
  • {v1,v2,…}a single column of data
    {{v11,v12,…},{v21,v22,…},…}lists of rows of data
    arrayan array such as SparseArray, QuantityArray, etc.
    tseriesa TimeSeries, EventSeries or a TemporalData object
    Dataset[…]a dataset
    Tabular[…]a tabular object
  • See the following reference pages for full general information:
  • Import, Exportimport from or export to a file
    CloudImport, CloudExportimport from or export to a cloud object
    ImportString, ExportStringimport from or export to a string
    ImportByteArray, ExportByteArrayimport from or export to a byte array

Import Elements

  • General Import elements:
  • "Elements" list of elements and options available in this file
    "Rules"list of rules for all available elements
    "Summary"summary of the file
  • Data representation elements:
  • "Data"two-dimensional array
    "Grid"table data as a Grid object
    "RawData"two-dimensional array of strings
    "Dataset"table data as a Dataset
    "Tabular"table data as a Tabular object
  • Data descriptor elements:
  • "ColumnLabels"names of columns
    "ColumnTypes"association of column names and types
    "Schema"TabularSchema object
  • Import and Export use the "Data" element by default.
  • Subelements for partial data import for any element elem can take row and column specifications in the form {elem,rows,cols}, where rows and cols can be any of the following:
  • nnth row or column
    -ncounts from the end
    n;;mfrom n through m
    n;;m;;sfrom n through m with steps of s
    {n1,n2,…}specific rows or columns ni
  • Metadata elements:
  • "ColumnCount"number of columns
    "Dimensions"a list of number of rows and maximum number of columns
    "RowCount"number of rows

Options

  • Import and Export options:
  • "EmptyField"""how to represent empty fields
    "QuotingCharacter""\""character used to delimit non-numeric fields
  • Data fields containing commas and line separators are typically wrapped in double-quote characters. By default, Export uses double-quote characters as delimiters. Specify a different character using "QuotingCharacter".
  • Double-quote characters delimiting text fields are not imported by default.
  • Import options:
  • CharacterEncoding"UTF8ISOLatin1"raw character encoding used in the file
    "ColumnTypeDetectionDepth"Automaticnumber of rows used for header detection
    "CurrencyTokens"Nonecurrency units to be skipped when importing numerical values
    "DateStringFormat"Nonedate format, given as a DateString specification
    "FieldSeparator""\t"string token taken to separate columns
    "FillRows"Automaticwhether to fill rows to the max column length
    "HeaderLines"Automaticnumber of lines to assume as headers
    "IgnoreEmptyLines"Falsewhether to ignore empty lines
    MissingValuePatternAutomaticpatterns used to specify missing elements
    "NumberPoint""."decimal point character
    "Numeric"Automaticwhether to import data fields as numbers if possible
    "Schema"Automaticschema used to construct Tabular object
    "SkipInvalidLines"Falsewhether to skip invalid lines
    "SkipLines"Automaticnumber of lines to skip at the beginning of the file
  • By default, Import attempts to interpret the data as "UTF8" encoded text. If any sequence of bytes stored in the file cannot be represented in "UTF8", Import uses "ISOLatin1" instead.
  • With CharacterEncoding -> Automatic, Import will attempt to infer the character encoding of the file.
  • Possible settings for "HeaderLines" and "SkipLines" are:
  • Automatictry to automatically determine the number of rows to skip or use as header
    nn rows to skip or to use as Dataset headers
    {rows,cols}rows and columns to skip or to use as headers
  • Import converts table entries formatted as specified by "DateStringFormat" to a DateObject.
  • Export options:
  • AlignmentNonehow data is aligned within table columns
    CharacterEncoding"UTF8"raw character encoding used in the file
    "FillRows"Falsewhether to fill rows to the max column length
    "IncludeQuotingCharacter"Automaticwhether to add quotations around exported values
    "TableHeadings"Automaticheadings for table columns and rows
  • Possible settings for Alignment are None, Left, Center and Right.
  • "IncludeQuotingCharacter" can be set to the following values:
  • Nonedo not enclose any values in quotes
    Automaticonly enclose values in quotes when needed
    Allenclose all valid values in quotes
  • "TableHeadings" can be set to the following values:
  • Noneskip column labels
    Automaticexport column labels
    {"col1","col2",…}list of column labels
    {rhead,chead}specifies separate labels for the rows and columns
  • Export encodes line separator characters using the convention of the computer system on which the Wolfram Language is being run.

Examples

open allclose all

Basic Examples  (3)Summary of the most common use cases

Import a TSV file:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-4rgoij
Out[1]=1

Import summary of a TSV file:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-jp1ucp
Out[1]=1

Export an array of expressions to TSV:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-qqnuw0
Out[1]=1
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-v78f5r
Out[2]=2

Scope  (8)Survey of the scope of standard use cases

Import  (4)

Import metadata from a CSV file:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-z7rwrf
Out[1]=1
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-mmpg8v
Out[2]=2

Import a TSV file as a Tabular object with automatic header detection:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-e720ue
Out[1]=1

Import without headers, while skipping the first line:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-2bdvi2
Out[2]=2

Import a sample row of a TSV:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-vz47sn
Out[1]=1

Analyze a single column of a file; start by looking at column labels and their types:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-02bmbg
Out[1]=1

Get all values for one column:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-1hnew
Out[2]=2

Compute the mean:

In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-o0d2qx
Out[3]=3

Export  (4)

Export a Tabular object:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-n5ufob
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-fjoadx
Out[2]=2

Use "TableHeadings" option to remove header from a Tabular object:

In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-cjurjr
Out[3]=3

Export a TimeSeries:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-lrk4rv
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-dl3tiv
Out[2]=2
In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-h897pe
Out[3]=3

Export an EventSeries:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-cbmz1t
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-bwygpf
Out[2]=2
In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-drt0q9
Out[3]=3

Export a QuantityArray:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-demjmf
Out[1]=1
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-cmlb2n
Out[2]=2

Import Elements  (26)

"ColumnCount"  (1)

Get the number of columns from a TSV file:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-71egs6
Out[1]=1

"ColumnLabels"  (1)

Get the inferred column labels from a TSV file:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-kdf4vl
Out[1]=1

"ColumnTypes"  (1)

Get the inferred column types from a TSV file:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-iy2qvy
Out[1]=1

"Data"  (6)

Import a TSV file as a 2D list of values:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-nl71bm
Out[1]=1

This is also the default element:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-y6nmcj
Out[2]=2

Import a single row of a TSV file:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-0p4i6s
Out[1]=1

Import some specific rows of a TSV file:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-fkq1ys
Out[1]=1

Import the first 3 rows of a TSV file:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-48eob1
Out[1]=1

Import a single row and column from a TSV file:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-q0n2ra
Out[1]=1

Import a single column from a TSV file:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-4r9nt8
Out[1]=1

"Dataset"  (3)

Import a TSV file as a Dataset:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-sya0vk
Out[1]=1

Use "HeaderLines" to use the first row as column headers:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-0qu5sd
Out[1]=1

Use "SkipLines" to only import the data of interest:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-k2znlw
Out[1]=1

"Dimensions"  (1)

Get the dimensions from a TSV file:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-g7mqzj
Out[1]=1

If all rows in the file do not have the same number of columns, some rows may be considered as invalid:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-k0ybay
Out[2]=2

"Grid"  (1)

Import TSV data as a Grid:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-yegbef
Out[1]=1

"RawData"  (3)

Import TSV data as raw strings:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-4xnxtt

Compare to "Data":

In[5]:=5
✖
https://wolfram.com/xid/0ck8ux57-cqe8yc

By default for "RawData", "Numeric"->False is used:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-15pwn6

Use "Numeric"->True:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-ua4ubc

By default for "RawData", "FillRows"->True is used:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-eyizzh

Use "FillRows"->False:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-w97jdw

"RowCount"  (1)

Get the number of rows a TSV file:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-pq0zbb
Out[1]=1

"Schema"  (1)

Get the TabularSchema object:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-p1kaq0
Out[1]=1

"Summary"  (1)

Summary of a TSV file:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-g7ycb8
Out[1]=1

"Tabular"  (6)

Import a CSV file as a Tabular object:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-dwxov0
Out[1]=1

Use "HeaderLines" and "SkipLines" options to only import the data of interest:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-ft3nmo
Out[1]=1

Import a single row:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-bgmxp6
Out[1]=1
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-fbogf8
Out[2]=2

Import multiple rows:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-i5ff6q
Out[1]=1

Import the first 5 rows:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-g0ixb
Out[1]=1

Import a single element at a given row and column:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-bf2afv
Out[1]=1

Import a single column:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-l8plh
Out[2]=2
In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-jf5yfi

Import Options  (15)

CharacterEncoding  (1)

The character encoding can be set to any value from $CharacterEncodings:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-v2b17f
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-6qz5o6
Out[2]=2
In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-2rqfrh
Out[3]=3

"ColumnTypeDetectionDepth"  (1)

By default, only several dozen rows from the beginning of the file are used to detect column types:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-betoei
Out[1]=1

Use more rows to detect column types:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-chp1d0
Out[2]=2

"CurrencyTokens"  (1)

Currency tokens are not automatically skipped:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-16e3qb
Out[1]=1

Use the "CurrencyTokens" option to skip selected currency tokens:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-oi8irh
Out[2]=2

"DateStringFormat"  (1)

Convert dates to a DateObject using the date format specified:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-qtt0ch
Out[1]=1

By default, no conversion is happening:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-gd2biv
Out[2]=2

"EmptyField"  (1)

Specify a default value for empty fields in TSV data:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-zw2pqt
Out[1]=1

"FieldSeparator"  (1)

By default, "\t" is used as a field separator:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-e3y45w
Out[1]=1

Use "," as a field separator:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-bt306
Out[2]=2

"FillRows"  (1)

For the "Data" element, row lengths are automatically preserved:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-janz6s
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-qrqxda
Out[2]=2

Pad rows:

In[7]:=7
✖
https://wolfram.com/xid/0ck8ux57-mjb1ob
Out[7]=7

For the "RawData" element, a full array is imported by default:

In[9]:=9
✖
https://wolfram.com/xid/0ck8ux57-ee0i9w
Out[9]=9

"HeaderLines"  (1)

The header line is automatically detected by default:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-fpqrfl
Out[1]=1

Use "HeaderLines" option when automatic header detection is incorrect:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-cslkk
Out[2]=2
In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-ffcffz
Out[3]=3

Specify row headers:

In[4]:=4
✖
https://wolfram.com/xid/0ck8ux57-g5nren
Out[4]=4

Specify row and column headers:

In[5]:=5
✖
https://wolfram.com/xid/0ck8ux57-xnlg5z
Out[5]=5

"IgnoreEmptyLines"  (1)

Use "IgnoreEmptyLines" to remove lines with no data from the imported data:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-20tvba
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-0mba7z
Out[2]=2
In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-27gz8u
Out[3]=3

MissingValuePattern  (1)

By default, an automatic set of values is considered missing:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-cv59lu
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-cyi4u
Out[2]=2

Use MissingValuePatternNone to disable missing element detection:

In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-ep9kqm
Out[3]=3

Use string patterns to find missing elements:

In[4]:=4
✖
https://wolfram.com/xid/0ck8ux57-rzcm8
Out[4]=4

"Numeric"  (1)

Use "Numeric"->True to interpret numbers:

In[4]:=4
✖
https://wolfram.com/xid/0ck8ux57-l7d90a

By default, everything imports as strings:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-kko935

"NumberPoint"  (1)

By default, "." is used to specify decimal point character for floating-point data:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-b1f6a0
Out[1]=1
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-buv0yl
Out[2]=2

Use "NumberPoint" option to specify decimal point character for floating-point data:

In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-k1nx6
Out[3]=3
In[7]:=7
✖
https://wolfram.com/xid/0ck8ux57-k8y5ko
Out[7]=7

"QuotingCharacter"  (1)

The default quoting character is a double quote:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-ky18l
Out[1]=1

A different quoting character can be specified:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-hn606d
Out[2]=2

"Schema"  (1)

Import automatically infers column labels and types from data stored in a TSV file:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-pdcz1
Out[1]=1
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-eu5zdq
Out[2]=2

Use "Schema" option to specify column types:

In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-ciz14m
Out[3]=3
In[4]:=4
✖
https://wolfram.com/xid/0ck8ux57-okvxyo
Out[4]=4

"SkipLines"  (1)

TSV files may include a comment line:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-11s6fa
Out[2]=2

Skip the comment line:

In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-ifgthe
Out[3]=3

Skip the comment line and use the next line as a Tabular header:

In[4]:=4
✖
https://wolfram.com/xid/0ck8ux57-qg0yaa
Out[4]=4

Export Options  (7)

Alignment  (1)

By default, no additional characters are added for any alignment:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-b5pn1e
Out[1]=1

Left-align column values:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-062g9q
Out[2]=2

Center-align column values:

In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-t3aeaj
Out[3]=3

CharacterEncoding  (1)

The character encoding can be set to any value from $CharacterEncodings:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-q6fnby
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-kukx8w
Out[2]=2
In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-b5ifl
Out[3]=3

"EmptyField"  (1)

By default, empty elements are exported as empty strings:

In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-vz6rk
Out[3]=3

Specify a different value for empty elements:

In[4]:=4
✖
https://wolfram.com/xid/0ck8ux57-09aj7h
Out[4]=4

"FillRows"  (1)

Row lengths are preserved by default:

In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-6kptt7
Out[3]=3

Use "FillRows"->True to export full array:

In[4]:=4
✖
https://wolfram.com/xid/0ck8ux57-5nobx2
Out[4]=4

"IncludeQuotingCharacter"  (1)

By default, Export only exports quotation characters for values that need them:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-edbyd3
Out[1]=1

Use "IncludeQuotingCharacter"All to enclose all values in quotes:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-jl1ug5
Out[2]=2

Use "IncludeQuotingCharacter"None to export all values without quotes. Note that headers are always enclosed in quotes:

In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-e0ep1g
Out[3]=3

"QuotingCharacter"  (1)

The default quoting character used for non-numeric elements is a double quote:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-g8w4a5
Out[1]=1

Specify a different quoting character:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-ba1wm9
Out[2]=2

Use "QuotingCharacter"->"" to export all values without quotes. Note that headers are always enclosed in quotes:

In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-haqqdd
Out[3]=3

"TableHeadings"  (1)

By default, column headers are exported:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-gb6m8g
Out[1]=1

Use "TableHeadings"None to skip column headers:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-f9xvg7
Out[2]=2

Export data using custom column headers:

In[5]:=5
✖
https://wolfram.com/xid/0ck8ux57-895ej8
Out[5]=5

Export data using custom column and row headers:

In[6]:=6
✖
https://wolfram.com/xid/0ck8ux57-69ahdp
Out[6]=6

Applications  (1)Sample problems that can be solved with this function

Export a list of European countries and their populations to a TSV file:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-wlpbop
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-hdppu8
Out[2]=2
In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-ycufr4
Out[3]=3

Import the data back and convert to expressions:

In[7]:=7
✖
https://wolfram.com/xid/0ck8ux57-sf3ga8
Out[7]=7

Possible Issues  (12)Common pitfalls and unexpected behavior

If all rows in the file do not have the same number of columns, some rows may be considered as invalid:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-66wo5p
Out[1]=1

Entries of the format "nnnDnnn" or "nnnEnnn" are interpreted as numbers with scientific notation:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-coz9h9
Out[1]=1

Use the "Numeric" option to override this interpretation:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-ma29p
Out[2]=2

Numeric interpretation may result in a loss of precision:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-my6e32
Out[1]=1

Use the "Numeric" option to override this interpretation:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-38iqda
Out[2]=2

Starting from Version 14.2, currency tokens are not automatically skipped:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-kcplae
Out[1]=1

Use the "CurencyTokens" option to skip such tokens:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-rcjbb
Out[2]=2

Starting from Version 14.2, quoting characters are added when the column of integer values contains numbers greater than Developer`$MaxMachineInteger:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-chddnz
Out[1]=1

Use "IncludeQuotingCharacter"->None to get the previous result:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-fy84hr
Out[2]=2

Starting from Version 14.2, some strings are automatically considered missing:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-daqhd9
Out[1]=1

Use MissingValuePatternNone to override this interpretation:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-enhjv9
Out[2]=2

Starting from Version 14.2, real numbers with 0 fractional part are exported as integers:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-ilg5c5
Out[1]=1

Use "Backend"->"Table" to get the previous result:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-oa5c0u
Out[2]=2

Starting from Version 14.2, integers greater than Developer`$MaxMachineInteger are imported as real numbers:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-idfu07
Out[1]=1
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-4gqow
Out[2]=2

Use "Backend"->"Table" to get the previous result:

In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-d15g2n
Out[3]=3

Starting from Version 14.2, date and time columns of Tabular objects are exported using DateString:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-rapyb
Out[1]=1
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-ec3ic3
Out[2]=2
In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-fyjbmz
Out[3]=3

Use "Backend"->"Table" to get the previous result:

In[4]:=4
✖
https://wolfram.com/xid/0ck8ux57-jv3aky
Out[4]=4

Some TSV data generated from older versions of the Wolfram Language may have incorrectly delimited text fields and will not import as expected in Version 11.2 or higher:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-q239r3
Out[1]=1

Using "QuotingCharacter""" will give the previously expected result:

In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-zeueaf
Out[2]=2

The top-left corner of data is lost when importing a Dataset with row and column headers:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-i566gf
Out[1]=1

Dataset may look different depending on the dimensions of the data:

In[1]:=1
✖
https://wolfram.com/xid/0ck8ux57-zae5qn
Out[1]=1
In[2]:=2
✖
https://wolfram.com/xid/0ck8ux57-7m0b0l
Out[2]=2
In[3]:=3
✖
https://wolfram.com/xid/0ck8ux57-ekgmw
Out[3]=3
In[4]:=4
✖
https://wolfram.com/xid/0ck8ux57-fqkjge
Out[4]=4