When most people think of data, they picture a spreadsheet — rows and columns, neatly organized. That's structured data. But a huge amount of the world's data doesn't look like that at all.
Structured Data
Structured data is organized into a defined format — typically rows and columns in a table. Each column has a specific type (name, date, number), and every row follows the same pattern.
Examples of structured data:
- A spreadsheet of customer orders with columns for order ID, date, amount, and postal code
- A database table of municipal property assessments
- A CSV file of weather station readings
Structured data is easy to search, sort, filter, and analyze with standard tools. It's the most common format for business and government data.
Structured data is often stored as CSV, Excel files, or in relational databases. The schema — the definition of columns and data types — is what makes it structured.
Unstructured Data
Unstructured data has no predefined format. It can't be easily organized into rows and columns. Most of the data generated in the world today is unstructured.
Examples of unstructured data:
- Email messages and chat logs
- Social media posts
- PDF documents and Word files
- Photos, videos, and audio recordings
- Handwritten notes
Unstructured data is harder to analyze with traditional tools. It often requires natural language processing, image recognition, or manual review to extract useful information.
Semi-Structured Data
Semi-structured data falls in between. It has some organizational structure — like tags or markers — but doesn't fit neatly into a table. JSON and XML are common semi-structured formats.
For example, a JSON file describing a business might have consistent fields like name and address, but the "hours" field might contain a nested object with different keys for different days. The structure is flexible rather than rigid.
Why the Distinction Matters
Knowing what type of data you're working with helps you choose the right tools and approach. Structured data can be analyzed in a spreadsheet or database. Unstructured data may need specialized software. Semi-structured data often needs to be transformed before analysis.
When you're evaluating a dataset — whether from a government portal or a business system — one of the first questions to ask is: how is this data structured?
Learn how data moves through its entire life in The Data Lifecycle.