Understanding data formats
Datasets on data.gov.scot are available in one or more formats. This page explains the most common formats and when to use them.
CSV (Comma-Separated Values)
CSV is the most common format on this site. It stores data in rows and columns, similar to a spreadsheet. You can open it in most spreadsheet tools, for example Microsoft Excel or Google Sheets.
Use CSV if you are not sure which format to choose.
XLSX (Excel spreadsheet)
XLSX is an Excel spreadsheet format that is similar to CSV but can include:
multiple tabs
pre-applied formatting
You can open it in Microsoft Excel or Google Sheets.
JSON (JavaScript Object Notation)
JSON is a structured format used when working with data using code. Developers and analysts use JSON to build apps or analyse data using software.
XML (Extensible Markup Language)
XML is a structured format for sharing data between systems. It’s commonly used by developers working with software or automated processes.
RDF and TTL (linked data formats)
RDF (Resource Description Framework) and TTL (Terse RDF Triple language, commonly known as ‘Turtle’) are formats used to describe data with embedded relationships. They allow datasets to be linked to other datasets across the internet.
You’ll usually only need these formats if you work with linked data or semantic web tools.
API access
Some datasets are available through an API (Application Programming Interface).
This allows software to get data directly from the site without downloading a file. This option is for technical users, such as developers.
If you are not sure which format to use
CSV is suitable for most users and tasks. If you need help, contact the Open Data team.