怎么查看你在Spotify的收听数据

想知道自己在Spotify听得最多的歌曲、艺术家和播客是什么吗?虽然Spotify每年12月都会推出Spotify Wrapped年终回顾清单,但是其余时间都无法查看收听数据。别担心,你还可以用其它方式来查看这些数据,下面会介绍其中4种简单的方法!

方法 1 的 4:

Spotistats

  1. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/8\/8a\/See-Your-Listening-Time-on-Spotify-Step-1-Version-4.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-1-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/8\/8a\/See-Your-Listening-Time-on-Spotify-Step-1-Version-4.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-1-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 1 从App Store或Play商店下载Spotistats应用。它即将改名为Stats.FM,全年提供跟Spotify Wrapped相似的数据。虽然查看这些收听数据不是免费的,好在只要付一次费用,之后随时都能查看数据。
    • 在手机或平板电脑的应用商店搜索 “Spotistats for Spotify”,或是直接浏览 https://spotistats.app 网站,点按Google PlayApp Store的链接 。
    • 想要查看自己的收听数据,需要向Spotify提出请求,最长可能需要等待长达30天,但是通常用不了那么久。
  2. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/8\/88\/See-Your-Listening-Time-on-Spotify-Step-2-Version-4.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-2-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/8\/88\/See-Your-Listening-Time-on-Spotify-Step-2-Version-4.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-2-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 2 请求查看你的Spotify收听数据。想要知道自己的收听数据,你需要通过电子邮件向Spotify请求查看JSON格式的扩展串流数据。[1] 这个收听数据跟Spotify网站上看到的有所不同。下面是具体操作:
    • 打开网页浏览器,前往 https://support.stats.fm/docs/import/streaming-history 。
    • 点击绿色的自动登录Spotify按钮,然后在出现提示时点击允许
    • 点击电子邮件模板下方的复制到剪贴板
    • 新建一封给[email protected]的邮件。想要迅速得到回应,记得用绑定了Spotify账号的电子邮件地址发邮件。
    • 将刚才复制的内容粘贴到电子邮件,然后发送。
    • 你可能需要几天才能从Spotify发来的电子邮件看到这些数据。从技术上来说,这个过程可能需要长达30天,不过一般一周内就能得到回复。[2]
  3. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/5\/53\/See-Your-Listening-Time-on-Spotify-Step-3-Version-4.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-3-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/5\/53\/See-Your-Listening-Time-on-Spotify-Step-3-Version-4.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-3-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 3 打开Spotistats。你可以在应用程序列表中找到它。不需要等到Spotify回复你,随时都能打开这个应用程序来设置账号。
    • 你可能需要授权应用打开Spotify的登录页面,才能继续下一步。
  4. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/1\/19\/See-Your-Listening-Time-on-Spotify-Step-4-Version-4.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-4-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/1\/19\/See-Your-Listening-Time-on-Spotify-Step-4-Version-4.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-4-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 4 登录你的Spotify账号。输入跟Spotify账号相同的登录信息。这款应用无法看到你的密码,或更改你的付款偏好设置。
    • 登录后需要点按同意,授权应用查看你的数据。
    • 如果日后不想继续使用这款应用,可以前往 https://spotify.com/account ,撤销有关应用的Spotify账号访问权限。
  5. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/03\/See-Your-Listening-Time-on-Spotify-Step-5-Version-4.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-5-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/03\/See-Your-Listening-Time-on-Spotify-Step-5-Version-4.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-5-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 5 启用"同步串流历史",确保Spotistats显示当天最新的准确数据。[3] 你应该在向Spotify请求查看数据之后,但导入数据之前启用这项功能。启动方法如下:
    • 点按Spotistats右上角的齿轮图标。
    • 点按算法、倒入和串流同步
    • 点按"'同步串流历史底下的禁用
    • 点按启用
    • 点按返回按钮,回到Spotistats主页。
  6. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/7\/7f\/See-Your-Listening-Time-on-Spotify-Step-6-Version-4.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-6-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/7\/7f\/See-Your-Listening-Time-on-Spotify-Step-6-Version-4.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-6-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 6 购买Spotistats Plus。付了一次性费用后,就能在收到Spotify的回复后导入收听数据,终生追踪自己的收听数据。购买方法如下:
    • 点按Stats图标,它是底部第三个图标。
    • 点按获取Spotistats Plus
    • 通过iPhone或iPad上的App Store,或是安卓设备上的Play商店进行一次性支付。
  7. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/a\/a4\/See-Your-Listening-Time-on-Spotify-Step-7-Version-4.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-7-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/a\/a4\/See-Your-Listening-Time-on-Spotify-Step-7-Version-4.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-7-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 7 从Spotify下载数据。一旦Spotify回复你数据已经准备好了,你会被导向含有“下载”链接的页面。点按或点击下载,下载含有你所需数据的ZIP文件。
    • 一旦Spotify处理了你的请求,会给你发送一封含有确认链接的电子邮件。点击邮件里的确认,然后在之后出现的网页上再次点击确认,以验证你的请求。
    • 你需要的是名称带有endsong.json字眼的文件,它们就在你下载的ZIP文件里。你可以在Windows、macOS灯任何平台上轻松地解压缩文件,获取里面所有 endsong.json文件。
  8. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/3\/32\/See-Your-Listening-Time-on-Spotify-Step-8-Version-4.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-8-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/3\/32\/See-Your-Listening-Time-on-Spotify-Step-8-Version-4.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-8-Version-4.jpg","smallWidth":460,"smallHeight":349,"bigWidth":728,"bigHeight":552,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 8 上传endsong.json文件到Spotistats。解压缩文件后,就能轻松地将全部含有endsong.json的文件上传到Spotistats。
    • 打开网页浏览器,前往 https://stats.fm/import 。
    • 出现提示时,登录Spotify,点按同意,继续下一步。
    • 点击导入新文件
    • 选中并上传第一个endsong.json文件。
    • 上传完毕后,接着上传下一个文件。每个文件都必须单独上传。
    • 所有文件上传完毕后,Spotistats会处理你的数据,过滤掉重复的串流数据和进行计算。整个过程耗时数分钟到数小时不等,具体取决于你的数据大小。
  9. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/6\/6e\/See-Your-Listening-Time-on-Spotify-Step-9-Version-4.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-9-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/6\/6e\/See-Your-Listening-Time-on-Spotify-Step-9-Version-4.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-9-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 9 点按Spotistats的Stats图标。成功导入文件后,你就能看到准确的Spotify收听数据了。
方法 2 的 4:

Last.FM

  1. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/5\/5a\/See-Your-Listening-Time-on-Spotify-Step-10-Version-4.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-10-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/5\/5a\/See-Your-Listening-Time-on-Spotify-Step-10-Version-4.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-10-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 1 打开网页浏览器,前往 https://www.last.fm 。创建一个免费的Last.FM账号,追踪自己在Spotify的收听习惯,包括通过收听次数累计下来的收听总时长。
    • Last.FM只会追踪你在注册账号并允许追踪后的收听数据。虽然查不了之前的收听数据,但是可以轻松地追踪将来的数据。
    • 你可以设置Last.FM追踪桌面电脑、手机或平板电脑上的Spotify活动数据。
  2. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/b\/b5\/See-Your-Listening-Time-on-Spotify-Step-18.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-18.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/b\/b5\/See-Your-Listening-Time-on-Spotify-Step-18.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-18.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 2 创建一个账号。如果你还没有Last.FM账号,点击屏幕左上角的注册链接创建一个。
  3. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/3\/36\/See-Your-Listening-Time-on-Spotify-Step-19.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-19.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/3\/36\/See-Your-Listening-Time-on-Spotify-Step-19.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-19.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 3 前往 https://www.last.fm/about/trackmymusic 。这个页面上会有许多追踪听歌习惯的选项。不需要下载Last.FM应用也能追踪收听习惯,所以不用点击或点按链接。
  4. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/8\/86\/See-Your-Listening-Time-on-Spotify-Step-20.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-20.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/8\/86\/See-Your-Listening-Time-on-Spotify-Step-20.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-20.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 4 往下滚动,点按“Spotify”底下的连接这里列出了Last.FM查看Spotify账号所需的权限信息。Last.FM运行了超过10年,你可以相信他们不会对你的账号做任何更改。
  5. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/1\/1c\/See-Your-Listening-Time-on-Spotify-Step-21.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-21.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/1\/1c\/See-Your-Listening-Time-on-Spotify-Step-21.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-21.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 5 点按同意,继续下一个步骤。这会将Last.FM绑定到Spotify。你在Spotify上听的每一首歌曲都会被Last.FM追踪,根据你的收听习惯提供全面的数据。
    • 你随时都能断开Last.FM和Spotify的连接。在Last.FM网站,将鼠标悬停在你的头像上。如果使用手机或平板电脑,那就点按菜单。点击设置,选择应用程序,然后点击断开连接
  6. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/c\/c2\/See-Your-Listening-Time-on-Spotify-Step-22.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-22.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/c\/c2\/See-Your-Listening-Time-on-Spotify-Step-22.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-22.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 6 点按你的头像来查看收听数据。刚创建的Last.FM账号没有太多数据,但只要你继续收听Spotify,就能得到各种收听数据,包括最常听的艺术家、专辑和歌曲。
  7. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/b\/bb\/See-Your-Listening-Time-on-Spotify-Step-23.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-23.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/b\/bb\/See-Your-Listening-Time-on-Spotify-Step-23.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-23.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 7 按时间过滤收听数据。Last.FM允许你查看过去7天过去30天过去90天过去180天过去365天全部时间的收听数据。你也可以点击或点按任何统计数据旁边的齿轮图标,更改默认的统计周期,在个人档案上自动显示所选时间段的数据。
方法 3 的 4:

Spotify Wrapped

  1. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/9\/97\/See-Your-Listening-Time-on-Spotify-Step-1-Version-2.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-1-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/9\/97\/See-Your-Listening-Time-on-Spotify-Step-1-Version-2.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 1 在安卓设备、iPhone或iPad上打开网页浏览器,前往 http://spotify.com/wrapped 。每年12月,Spotify都会推出年终回顾清单Spotify Wrapped,将你过去一年的收听数据可视化。[4] 这个网站会显示你的Spotify Wrapped年终回顾清单。
    • 你需要在12月查看年终回顾清单,才能获取自己的收听数据。其余时候只会看到一张列出了你最常听的艺术家和歌曲的播放清单。
  2. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/a\/a5\/See-Your-Listening-Time-on-Spotify-Step-4-Version-2.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-4-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/a\/a5\/See-Your-Listening-Time-on-Spotify-Step-4-Version-2.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-4-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 2 查看你的2021年度回顾清单。Spotify Wrapped会显示你在本年度1月1日到11月1日期间最常听的歌曲、艺术家、音乐流派和收听时长。
    • 如果想要跳过特定部分,可以点按或划过屏幕。
  3. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/8\/8a\/See-Your-Listening-Time-on-Spotify-Step-5-Version-2.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-5-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/8\/8a\/See-Your-Listening-Time-on-Spotify-Step-5-Version-2.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-5-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 3 分享你的Spotify年终回顾数据。只要点按屏幕底部的分享,就能在Instagram、Facebook、推特等社交媒体、短信或其它平台上,跟朋友分享任何一页的Spotify年终回顾数据。
方法 4 的 4:

1-Year Spotify Dashboard

  1. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/1\/19\/See-Your-Listening-Time-on-Spotify-Step-20-Version-2.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-20-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/1\/19\/See-Your-Listening-Time-on-Spotify-Step-20-Version-2.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-20-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 1 向Spotify请求查看你的收听数据。你可以用The Next Web网友创建的Google Design Studio模板“1-Year Spotify Dashboard”,查看过去一年的收听总时长。[5] 首先,你需要向Spotify请求查看数据。请求过程很简单,但需要等待几天才能通过电子邮件收到数据。下面是请求方法:
    • 打开网页浏览器,前往 https://www.spotify.com/ca-en/account/privacy 。
    • 往下滚动,点击请求
    • Spotify声称请求过程可能长达30天,但是我们的测试者只等了3天就收到了数据。
  2. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/9\/90\/See-Your-Listening-Time-on-Spotify-Step-21-Version-2.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-21-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/9\/90\/See-Your-Listening-Time-on-Spotify-Step-21-Version-2.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-21-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 2 解压缩刚下载的文件。收到了Spotify的数据后,将ZIP文件下载到电脑,然后解压缩文件,将名为“MyData”的文件提取到默认的“下载”文件夹。
  3. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/9\/93\/See-Your-Listening-Time-on-Spotify-Step-22-Version-2.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-22-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/9\/93\/See-Your-Listening-Time-on-Spotify-Step-22-Version-2.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-22-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 3 打开“MyData”文件夹。里面会有许多扩展名为.JSON的文件,其中一个或多个文件以 StreamingHistory(串流历史)作为名称开头。
    • 如果你过去一年听少过1万首歌曲,但就只有一份“StreamingHistory”文件。听超过1万首歌曲,就会有多份以0、1、2等数字结尾的文件。
  4. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/2\/29\/See-Your-Listening-Time-on-Spotify-Step-23-Version-2.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-23-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/2\/29\/See-Your-Listening-Time-on-Spotify-Step-23-Version-2.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-23-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 4 将“StreamingHistory”文件转换成CSV格式。你可以使用网上的JSON至CSV转换器进行这些操作,具体方法如下:
    • 在网页浏览器打开 https://csvjson.com/json2csv 。
    • 点击选择文件,然后选择第一份“StreamingHistory”文件,比如StreamingHistory0.json
    • 点击转换
    • 点击下载,选择“MyData”文件夹作为保存位置,然后将文件保存为StreamingHistory0.csv
    • 如果有多份文件,需要一一转换。再次点击选择文件,选中下一份“StreamingHistory”文件,然后转换并下载文件。把它命名为StreamingHistory1.csvStreamingHistory2.csv等,以此类推。
  5. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/0e\/See-Your-Listening-Time-on-Spotify-Step-24.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-24.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/0e\/See-Your-Listening-Time-on-Spotify-Step-24.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-24.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 5 新建一份名为Spotify数据的“Google表格”文件。即使你之前从未用过“Google表格”,也能轻松地创建新表格:
    • 前往 https://drive.google.com 。
    • 点击+ 新建
    • 点击Google表格
    • 在表格左上角,输入Spotify数据作为文件名。
  6. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/8\/87\/See-Your-Listening-Time-on-Spotify-Step-25.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-25.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/8\/87\/See-Your-Listening-Time-on-Spotify-Step-25.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-25.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 6 将收听数据导入“Google表格”文件。如果有多份数据,需要用特殊方法导入它们。具体操作如下:
    • 点击文件,选择导入
    • 点击上传选项卡,然后选择从你的设备选择文件
    • 选中第一份CSV格式的“StreamingHistory”文件,然后点击打开
    • 导入位置菜单中,选择替代当前表格,然后点击导入数据。如果已经没有其它CSV格式的“StreamingHistory”文件,那么这一步就完成了。
    • 如果还有其它CSV格式的“StreamingHistory”文件要导入,返回文件 > 导入 > 上传 > 从你的设备选择文件,选中第二份文件,然后点击打开
    • 导入位置菜单中,选择添加到当前表格,然后点击导入数据
      • 继续按同样的方式,添加全部CSV格式的“StreamingHistory”文件。
  7. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/f\/ff\/See-Your-Listening-Time-on-Spotify-Step-26.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-26.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/f\/ff\/See-Your-Listening-Time-on-Spotify-Step-26.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-26.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 7 如果你导入了多份CSV格式的“StreamingHistory”文件,删除多余数据。你需要删除标题。方法很简单。
    • 首先,往上滚动到表格顶端。你会看到第一行写着各列标题“endTime”、“artistName”、“trackName”和“msPlayed”。如果你添加了多份文件,就会有许多行标题,但我们只需要最上面一行的标题就可以了。
    • Ctrl + F(Windows)或Cmd + F(Mac),打开“在表格中查找”窗口。
    • 输入endTime
    • 点击朝下箭头,直到数据中间一行写着endTime的数据。
    • 右击左侧的行号,选中删除行
    • 如果你添加了多份表格,搜索更多endTime条目,并将它们一一删除。
  8. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/8\/86\/See-Your-Listening-Time-on-Spotify-Step-27.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-27.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/8\/86\/See-Your-Listening-Time-on-Spotify-Step-27.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-27.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 8 添加语言列,帮助TheNextWeb工具改进数据可视化。操作方法如下:
    • 点击E1单元格,输入Language
    • 点击E2单元格,输入=DETECTLANGUAGE(C2),然后按EnterReturn键。
    • 一旦你在E2看见了en等语言名称,点击该单元格,右下角会出现一个蓝色方块。
    • 双击蓝色方块,将方程式应用到该列的其余部分。
  9. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/b\/b4\/See-Your-Listening-Time-on-Spotify-Step-28.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-28.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/b\/b4\/See-Your-Listening-Time-on-Spotify-Step-28.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-28.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 9 在网页浏览器打开“1-Year Spotify Dashboard”模板。点击或将下面的链接粘贴到网页浏览器:https://datastudio.google.com/open/1B4lsJDWBriU7R2nx9ii2zuJE6FXRTBrg?usp=sharing
  10. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/2\/27\/See-Your-Listening-Time-on-Spotify-Step-29.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-29.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/2\/27\/See-Your-Listening-Time-on-Spotify-Step-29.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-29.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 10 复制模板。点击右上角的三个点,然后选择复制
    • 第一次进行这项操作时,可能需要选择自己的国家/地区,同意条款,然后点击继续。你可能还需要选择Data Studio的电子邮件偏好设置。如果不想接收邮件,每个选项都点选,然后选择继续
    • 完成后,再次点击三个点图标,选择复制
  11. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/a\/a5\/See-Your-Listening-Time-on-Spotify-Step-30.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-30.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/a\/a5\/See-Your-Listening-Time-on-Spotify-Step-30.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-30.jpg","smallWidth":460,"smallHeight":350,"bigWidth":728,"bigHeight":554,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 11 点击新数据源菜单,选择底部的创建数据源
  12. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/9\/9f\/See-Your-Listening-Time-on-Spotify-Step-31.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-31.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/9\/9f\/See-Your-Listening-Time-on-Spotify-Step-31.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-31.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 12 选择“Google表格”,然后点击授权页面上会显示你的“Google表格”文件列表,其中就包括了你刚创建的“Spotify数据”表格。
  13. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/9\/90\/See-Your-Listening-Time-on-Spotify-Step-32.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-32.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/9\/90\/See-Your-Listening-Time-on-Spotify-Step-32.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-32.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 13 选择“Spotify数据”表格,然后点击右上角的连接这会将你的收听数据导入到工具里。只要多几个步骤,就能查看自己的收听总时长。
  14. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/e\/e8\/See-Your-Listening-Time-on-Spotify-Step-33.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-33.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/e\/e8\/See-Your-Listening-Time-on-Spotify-Step-33.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-33.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 14 点击添加到报告,返回到“复制这份报告”的页面。
  15. {"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/e\/ef\/See-Your-Listening-Time-on-Spotify-Step-34.jpg\/v4-460px-See-Your-Listening-Time-on-Spotify-Step-34.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/e\/ef\/See-Your-Listening-Time-on-Spotify-Step-34.jpg\/v4-728px-See-Your-Listening-Time-on-Spotify-Step-34.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"} 15 点击复制报告现在你就可以查看过去一年完整的收听记录,包括以分钟计算的收听总时长。

<<:  怎么用可可粉制作巧克力

>>:  怎么在iPhone、iPod和iPad上编辑和裁剪照片

怎么给猫洗澡

虽然猫咪总是非常仔细地梳理自己的毛发,但它总有需要洗澡的时候。有时它身上可能会沾上非常粘或者脏兮兮的...

怎么恢复死硬盘

你的硬驱刚停止运行。它从来没有发出过任何奇怪的声音,比如吱吱、砰砰或点击声,也没有发出过巨响。它就这...

怎么成为宇航员

虽然你警告过你的父母,如果他们不帮助你成为宇航员,你会跟他们断绝关系,但他们还是把你送去篮球/足球营...

怎么让苍蝇远离宠物狗

如果你家里总有苍蝇飞来飞去,宠物狗受的罪可能远远超出你的想象。苍蝇不仅会骚扰狗狗,有的还会叮咬它的皮...

怎么自己调配指甲油颜色

只要使用眼影和透明指甲油,或者将2种指甲油混合在一起,就能调配出你想要的指甲油颜色。你甚至可以买市售...