Not all information has the same structure.
Compare these two representations of music information.
Title: Northern Lights
Artist: Example Band
Album: Open Roads
Genre: Rock
Year: 2024
I heard Northern Lights by Example Band yesterday.
It is from Open Roads, and I would probably describe it as rock.
Both contain useful information.
The first follows a predictable field structure.
The second is natural prose.
This difference is the foundation of structured and unstructured data.
Structured data follows a defined arrangement.
For a music library, each song might use the same fields:
| Title | Artist | Album | Genre | Year |
|---|---|---|---|---|
| Northern Lights | Example Band | Open Roads | Rock | 2024 |
| Side Street | Dana Lee | City Lines | Jazz | 2022 |
Each column has a consistent purpose.
Each row follows the same general structure.
This makes the data easier for software and people to process systematically.
Examples of unstructured data include:
A written review might say:
Northern Lights has a strong opening and a slower middle section. I would play it again.
The information is meaningful, but it is not already separated into consistent columns such as:
Title
Artist
Rating
Comment
Software may need additional processing before the content can be summarized in the same way as a structured table.
A spreadsheet row is useful when you need predictable fields.
A paragraph is useful when a person needs to explain a complex idea.
A photograph can communicate information that would be awkward to reduce to a few cells.
The question is not:
Which form is always better?
The better question is:
Which form fits the task?
Suppose you have 100 songs.
If every song is described in a different paragraph, answering:
Which songs are in the Rock genre?
can be difficult.
If each record has a consistent Genre field, the data can be filtered much more easily.
Structure supports operations such as:
Those spreadsheet operations appear later in the module.
A simple structured music table may have columns:
Title
Artist
Album
Genre
Year
Each song record uses those same categories.
The values change.
The field meanings remain consistent.
That predictable pattern is what makes the dataset structured.
Imagine a spreadsheet with a column called:
Review
One cell might contain a long paragraph.
The spreadsheet itself is organized into rows and columns, but the review text inside that cell is free-form.
Real datasets can therefore mix structured and less-structured information.
The distinction is about how the information is represented and how predictable its internal organization is.
Data does not mean “numbers in a spreadsheet.”
A photo is digital data.
An email message is data.
A PDF document is data.
A video file is data.
Those forms simply do not fit naturally into the same row-and-column field structure as a music table.
Suppose you have:
I love Northern Lights by Example Band. It came out in 2024 and I consider it rock.
To make that structured, someone has to decide which fields matter.
For example:
Title = Northern Lights
Artist = Example Band
Year = 2024
Genre = Rock
That transformation is another form of abstraction.
You decide which parts of the original information belong in the structured dataset.
The upcoming spreadsheet activities focus on data that can be organized into consistent rows and columns.
That does not make unstructured information unimportant.
It gives you a manageable environment for learning how organized data can be entered, imported, compared, and later summarized.
Structured data
Unstructured data
The next activity introduces spreadsheets as one common tool for working with structured data.