NPTG & NaPTAN CSV Formats 2.x

In addition to exchange as XML documents conforming to the NaPTAN & NPTG XML schemas, data may also be exchanged in a simple flat file representation, with a file for each table using Common Separated Variables (CSV)  format for each the values of each row. CSV files can be imported directly into spreadsheet programs such as Microsoft Excel and many databases.

  1. NPTG CSV Schema 2.x (Export only from central database)
  2. NPTG Discovery CSV Schema 2.x (No Export / Import at present)
  3. NaPTAN CSV Schema 2.x (Export and Import of most data)

For old NaPTAN & NPTG version 1.x CSV schemas and for migration information see here.

For further details see NaPTAN & NPTG Schema Guide.

NPTG CSV Schema 2.x

The following diagram shows the 2.x CSV representation of the NPTG schema.

NPTG Discovery CSV Schema 2.0

The following diagram shows the 2.0 CSV representation of the NPTG Discovery schema.

NaPTAN CSV Schema 2.x

The following diagram shows the 2.x CSV representation of the NaPTAN schema.