ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Hello!
2
3
I created this spreadsheet over a few months between December 2022 into 2023. I'll be keeping it updated as Taylor releases new music. Some things to keep in mind:
4
5
- I grouped similar types of words and motifs together. Some lines appear in several places for this reason.
- I didn't consider what we think we know of Taylor's personal life to pull this together.
- I tried to take the lyrics literally to collect the data. As a result, some data points contextually won't make sense since they're a detail instead of the motif/metaphor for the particular work.
- Lines that are similar, but had a different preceding or succeeding line "counted" several times. Choruses counted once.
- I omitted the non-album songs. Maybe one day I'll do it, but I'm not holding my breath.
6
7
I'm only one person, so this list isn't perfect or even complete(!), but I tried to be as comprehensive as possible. If there's anything I missed or is duplicated, please tell me so I can correct it. Obviously, this took a lot of work, so please give me credit if you use it for anything. :)
8
Blog: https://maxxr.squarespace.com/blog/tag/Taylor%20Swift
9
10
22 April 2024: Added individual links to available charts in the Table of contents
11
7 September 2023: Created Tableau data viz for all this data - https://public.tableau.com/app/profile/maxx.ramos/viz/TaylorSwiftlyrictrendsovertime/Dashboard43
12
All the data visualizations are here, I forgot when I did it...
https://public.tableau.com/app/profile/maxx.ramos/vizzes
13
14
Changelog:
15
15 October 2025: Updated with the last 6 songs of The Life of Showgirl
16
14 October 2025: Updated with the first 6 songs of The Life of a Showgirl
17
14 May 2024: Updated and cleaned up most of the data and Tableau charts
18
13 May 2024: Added Robin, The Manuscript
19
9 May 2024: Added The Bolter
20
7 May2024: Added Cassandra
21
2 May 2024: Added thanK you aIMee, I Look In People's Windows, The Prophecy
22
1 May 2024: Added I Hate It Here
23
30 April 2024: Added imgonnagetyouback, The Albatross, Chloe or Sam or Sophia or Marcus, How Did It End?, So High School
24
28 April 2024: Added Clara Bow, The Black Dog
25
25 April 2024: Added I Can Fix Him (No Really I Can), loml, The Smallest Man Who Ever Lived, The Alchemy
26
23 April 2024: Added But Daddy I Love Him, Fresh Out The Slammer, Florida!!!, Guilty As Sin?, Who's Afraid Of Little Old Me?
27
22 April 2024: Updated table of contents with links to Tableau charts of usage over time
28
22 April 2024: Added My Boy Only Breaks His Favorite Toys, Down Bad, So Long London
29
22 April 2024: Changed "Highs and heights" to "Highs and lows", updated categories to High, Low, Transitions; added subcategories
30
21 April 2024: Updated name drops to count the unique instances of names mentioned per each era
31
21 April 2024: Added Fortnight and The Tortured Poets Department from The Tortured Poets Department
32
21 February 2024: Added missing mention of "hall/hallway" in exile
33
21 February 2024: Split Wounds and Weapons into separate sheets
34
9 January 2024: Updated Apparel and appearances and Fairytales and Kingdoms to include more crown mentions
35
9 January 2024: Updated Body parts to include more feet mentions
36
27 Nov 2023: Updated topics in C-F with the same data as the Tableau data viz. Topics are all updated with info from 1989 From the Vault tracks. Please let me know if I'm missing anything.
37
26 Nov 2023: Updated topics in G-Z with the same data as the Tableau data viz
38
25 Nov 2023: Updated topics in A-B with the same data as the Tableau data viz
39
?? October 2023: Removed "Fate and omens" and merged it with "Accidents and planning"
40
21 September 2023: Added Total count to each item in the table of contents (excludes Related lines)
41
7 September 2023: Normalizing data to create graphs. :)
42
10 August 2023: Experimented with Pivot Table to display data, appended numbers to Album era for tables. (Evermore is listed at 2021 for this experimentation)
43
27 July 2023: Added Foolish One to all relevant pages
44
26 July 2023: Added Castles Crumbling to all relevant pages
45
26 July 2023: Added I Can See You to all relevant pages
46
26 July 2023: Added When Emma Falls in love to all relevant pages
47
26 July 2023: Added Electric Touch to all the relevant pages
48
26 July 2023: Added trying, headlights and stars alight to Paired lines
49
25 July 2023: Designated (From the Vault) songs to see if their additions changed theme occurence across eras.
50
6 July 2023: I turned on commenting so you can leave comments if I missed anything!
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100