Why Export App Store Reviews?
Exporting app store reviews to a spreadsheet can streamline your process of analyzing user feedback. Whether you're looking to conduct sentiment analysis, track trends over time, or simply share feedback with your team, having data in a spreadsheet format is invaluable.
How to Export App Store Reviews: Step-by-Step
Step 1: Access App Store Connect
First, log in to your Apple Developer account and navigate to App Store Connect. Once there, select My Apps and choose the specific app whose reviews you want to export.
Step 2: Navigate to Reviews
Within the app's dashboard, go to Activity in the top menu and select Ratings and Reviews. Here you'll see all the reviews for your app.
Step 3: Using the API for Export
Apple doesn't provide a direct export option in the UI. However, you can use the App Store Connect API to programmatically retrieve reviews. You'll need to generate an API key by going to App Store Connect → Users and Access → Keys, and then using the GET /v1/apps/{id}/customerReviews endpoint to fetch reviews.
curl -g -X GET 'https://api.appstoreconnect.apple.com/v1/apps/{appId}/customerReviews' \-H 'Authorization: Bearer {token}'Make sure to replace {appId} and {token} with your app's ID and the generated token respectively.
Step 4: Convert JSON to CSV
The API will return data in JSON format. To convert this to a CSV file, you can use an online converter or a script in Python or another language you're comfortable with. Here's a simple Python snippet to convert JSON to CSV:
import json import csv # Load JSON data with open('reviews.json', 'r') as json_file: data = json.load(json_file) # Define CSV file with open('reviews.csv', 'w', newline='') as csv_file: writer = csv.writer(csv_file) # Write CSV header writer.writerow(['reviewId', 'rating', 'title', 'body']) # Write data for review in data['data']: writer.writerow([review['id'], review['attributes']['rating'], review['attributes']['title'], review['attributes']['body']])Alternative: Use ReviewTower for Simplification
If handling APIs and scripts feels cumbersome, consider using a tool like ReviewTower. It allows you to automatically export reviews to CSV or Excel formats with ease, saving you time and effort.
Conclusion
Exporting reviews to a spreadsheet can greatly enhance your ability to analyze and act on user feedback. Whether you choose to use the App Store Connect API or a tool like ReviewTower, having your data organized in a spreadsheet will empower your development and marketing strategies.