Import a file, automatically detecting and interpreting dates and cities:

Columns shown in bold correspond to semantic objects in the Wolfram Language:

Import a file with the specified column types:

Import only some columns of a file, in the specified format, using column numbers:

Import only some columns of a file, in the specified format, using column names:

Import only some columns, specifying None for columns that should be dropped:

Import a file as a list of rows:

Import a file as a list of columns:

Import a file using a given character encoding:

Import a file using the given delimiter:

Specify that the first line of the file to import is a header:

Specify that the first and fifth lines of a file should be skipped:

Return missing values with the form "Unknown" in the special form Missing["UnknownData"]:

SemanticImport uses many of the same options as SemanticImportString. See SemanticImportString for more examples.

Import a table containing the flight cost from London to many countries as a Dataset object:

Get the geographic position of London:

Get the maximum price of a flight:

Make a map showing the least expensive flight routes in blue and the most expensive ones in orange:

Import the data for a timeline of personal emails:

Get the values that are in the "family" category:

Plot email count per month:

Import the first and third columns from a table of salaries for college faculty members:

Plot the result:

Import a dataset consisting of dates and numeric values as a Dataset object:

Obtain the data as a list of rows:

Specify that dates should be interpreted as strings:

Import a dataset containing a list of famous buildings and their properties as a Dataset object. Cities and countries are automatically detected as Entity objects:

Import only the Name, Country, and Height columns of the famous building dataset:

Automatic selection chooses from a less rich set of types than Interpreter:

Specify explicit types to import Entity objects rather than strings:

An Automatic type specifies an automatically selected number of columns:

An {Automatic} type specifies a single column of automatically selected type:

Automatic in a type list applies to the corresponding column sequentially:

The default Automatic selection of header lines can be incorrect, depending on whether data is organized in rows or columns:

Specify the number of header lines explicitly to import the data correctly: