My Spotify History Data

View your complete Spotify play history and analyze how much time you've spent with your favorite artists and songs! This app processes your Spotify data export files and delivers detailed statistics and insights into your listening habits so you can view and explore the data in Excel or Google Sheets (CSV format). 📌 Note: This app analyzes Streaming History and Extended Streaming History files only. (ONLY Upload files named Streaming_History....) It does not process other Spotify export data types (like playlists, library, or user data). ## What You Get - Overall Statistics: Total plays, listening time, date range, and daily averages - Top Artists: Your most-played artists with play counts and listening hours (unlimited or set your own limit) - Top Tracks: Your favorite songs ranked by play count (unlimited or set your own limit) - Timeline Data: When you discovered artists and tracks - Detailed Metrics: Play counts, percentages, and time breakdowns - All in One View: Single "My Data" tab with summary, artists, and tracks all together ## How to Use ### Step 1: Get Your Spotify Data 1. Go to Spotify Privacy Settings 2. Scroll down to "Download your data" 3. Select either: - "Account data": Faster delivery (usually a few days, sometimes just 1 day), includes full metadata - "Extended streaming history": Can take up to 30 days (but sometimes arrives in 1 day), more complete history 4. Wait for Spotify to email you 5. Download and unzip the files 6. Look for files named StreamingHistory0.json, StreamingHistory1.json, etc. ### Step 2: Upload Your Files 1. In the Apify actor input form, find the file upload fields: - 📁 Spotify JSON File 1 (required) - 📁 Spotify JSON File 2-5 (optional) 2. For each file: - Click on the upload field - Either upload the JSON file from your computer, OR - Provide a URL to the JSON file if hosted online 3. Upload all your StreamingHistory files (you can use up to 5 files) 4. (Optional) Configure additional settings like date filters 5. Click "Start" ### Step 3: View Your Results Check the Dataset tab to see the "My Data" view with: - 📊 Row 1: Summary of your listening habits - 🎤 Next rows: All your top artists (ranked by plays) - 🎵 Final rows: All your top tracks (ranked by plays) ## Output Fields | Field | Description | |-------|-------------| | rank | Ranking position (0 = summary, 1+ = most played) | | name | Artist or track name | | type | Summary, Artist, or Track | | image | Link to Infographic image of summary of your data | | playCount | Number of times played | | totalMinutes | Total minutes listened | | totalHours | Total hours listened | | totalDays | Total days listened (summary only) | | percentage | Percentage of your total listening time | | firstPlayed | Date you first played this | | lastPlayed | Most recent play date | | daysCovered | Number of days between first and last play (summary only) | | avgMinutesPerDay | Average minutes per day (summary only) | | uniqueArtists | Total unique artists (summary only) | | uniqueTracks | Number of unique tracks (summary or for each artist) | | trackName | Track name (tracks only) | | artistName | Artist name (tracks only) | ## Input Options ### Required - Spotify JSON File 1: Upload your first StreamingHistory JSON file ### Optional Files - Spotify JSON File 2-5: Upload additional StreamingHistory files (up to 5 total) ### Optional Filters - Start Date: Filter plays from this date onwards (YYYY-MM-DD format). Leave empty for all data. - End Date: Filter plays up to this date (YYYY-MM-DD format). Leave empty for all data. - Minimum Play Time: Only count songs played for at least X seconds (helps filter out skips). Leave empty to include all plays (no filtering). - Maximum Artists to Export: Limit the number of top artists in results. Leave empty for unlimited. Recommended: 500 - Maximum Tracks to Export: Limit the number of top tracks in results. Leave empty for unlimited. Recommended: 500 ## Tips - Multiple Files: Upload all your StreamingHistory files (up to 5) to get complete analysis - No Default Filtering: By default, ALL plays are included. Set minimum play time only if you want to filter out skips - Export Limits: For very large datasets, use the max artists/tracks settings to limit output size and improve performance - Filter Skips: Set minimum play time to 60+ seconds to filter out skipped songs - Date Ranges: Use date filters to compare different time periods (e.g., 2023 vs 2024) - Download Results: Export the dataset as CSV/JSON/Excel for further analysis ## Troubleshooting Most plays show as "Unknown" artist/track - Some Spotify exports don't include full metadata - This can happen with certain export types or older data - The actor will still calculate time statistics correctly even without full metadata - If you need complete metadata, try requesting a different export type from Spotify "Failed to fetch file" or "File not found" - Make sure you uploaded the correct JSON files from Spotify - Files should be named StreamingHistory*.json from your Spotify export - If providing URLs, ensure they are publicly accessible - Try re-uploading the files "JSON data must be an array" - Your file might be corrupted or in the wrong format - Make sure you're uploading the actual StreamingHistory JSON files from Spotify - Content should start with [ and contain streaming history records "Some plays are missing" - Check your date filters (Start Date / End Date) - Check if you set a minimum play time (plays shorter than this are excluded) - Spotify only provides data from when you started using the service Output is too large / Actor times out - Use the "Maximum Artists to Export" and "Maximum Tracks to Export" settings - Try setting both to 500 for a reasonable dataset size - Or filter by date range to analyze smaller time periods ## Privacy This actor runs entirely in your Apify account. Your Spotify data is: - Only processed during the actor run - Stored only in your Apify dataset ## Roadmap Here are the future features we will be developing. If you have any additional suggestions, contact us at https://docs.google.com/forms/d/e/1FAIpQLSfsKyzZ3nRED7mML47I4LAfNh_mBwkuFMp1FgYYJ4AkDRgaRw/viewform?usp=dialog - Support Stream History File for Podcasts (i.e. StreamingHistory_podcast_0.json) - Support Playlists (i.e. Playlist1.json) ## Support Have Questions or Need Additional Features? We're here to support you! Whether you need help with setup, have questions about interpreting results, or want to request additional features for Pitches Pro, we've got you covered. Contact Us: Just fill out the form at https://docs.google.com/forms/d/e/1FAIpQLSfsKyzZ3nRED7mML47I4LAfNh_mBwkuFMp1FgYYJ4AkDRgaRw/viewform?usp=dialog, and we'll try our best to help as quickly as possible.