1. Home
  2. Getting Started
  3. Exporting Data
  4. Export App Reviews Data to CSV
  1. Home
  2. Monitoring Reviews & Ratings
  3. Export App Reviews Data to CSV

Export App Reviews Data to CSV

Downloading Reports

From the Export CSVs tab, you can download a range of pre-configured reports for multiple apps at once, and for any date range you require.

We offer the following reports

  • Stars by Date
  • Stars by Date & Country/Language
  • Stars by Version
  • Ave Stars by Country/Language
  • Review Volume by Date
  • Review Volume by Date & Country/Language
  • Stars by Device
  • Ratings by Date
  • Interesting Words
  • Popular Words
  • Critical Words
  • Topics Summary
  • Custom Topics Summary
  • Custom Tags Summary
  • Reply Stats
  • Reply Stats by Date
  • Reply Effect
  • Export Reviews

 

How To Download Reports

  1. Navigate to the Exports page in the left menu.select 'exports' screenshot
  2. Choose which sources you would like included in the report (max 25). In the drop-down filter, you can select and deselect the sources you’d like to be included.
    sources filter screenshotexport sources screenshot
  3. Whilst the filter pane is open, adjust the date filter to contain the range you want.

    date filter screenshot
  4. Click ‘Download’ next to the report you need and choose whether you want your report in CSV or Excel (.xlsx) format.

    download data to .csv or .excel screenshot
  5. If you would like any reports added that are not already on the list, select the ‘Let Us Know’ button at the bottom of the page and tell us what report you’re after.'let us know' screenshot

Export App Reviews Data

Appbot also allows you to easily export aggregated app reviews data as a CSV so that you can create your own charts and reports or import your reviews into other systems.

The options to export app reviews that are available to you depend on the plan that you’ve chosen. 

Downloading Reviews

  1. To download your app reviews as a CSV, head over to Reviews in the Explore navigation menu.
  2. Apply the necessary filters to refine the review list to only show the reviews you are interested in (or leave it as it is to export them all).
  3. Press ‘Export’ to export app reviews.export app reviews spreadsheet

The downloaded CSV will contain the following fields:

  • App Name
  • App Store
  • App ID
  • Review ID
  • Country or Language
  • Version (if available)
  • Star Rating
  • Date
  • Author
  • Subject
  • Body
  • Translated Subject
  • Translated Body
  • Device (if available)
  • Reply Appbot URL
  • Reply text
  • Reply date

Downloading Topics & Custom Topics

  1. Head over to ‘Topics’ or ‘Custom Topics’ from the navigation.
  2. To download a Topic summary, click on the ‘Export’ button above the list of topics to export app reviews.export 'topics' screenshot

Understanding Reply Effect

  1. Head over to ‘Exports’ from the navigation.
  2. Download the ‘Reply Effect’ export.export 'reply effect' screenshot

Troubleshooting

All Exports are limited to 20,000 rows per file, but there is no limit on how many exports you can run if you are on a plan that includes exports.

If you experience an error when attempting to export from Appbot, follow these steps:

  • Adjust the date range to a much shorter period (eg. 30 days). If this works, then the date range you original selected has too many reviews for a single file. You will need to run several sequential exports and append them in your spreadsheet program.
  • Try selecting fewer apps (ideally, just a single app). If this works, the sum total of apps you have included in your original attempt has too many reviews for a single file. You will need to run several exports and append them in your spreadsheet program.

If you need any further assistance on how to export aggregated app reviews, don’t hesitate to contact us with any questions or check out our FAQ section here.
 

Was this article helpful?

Related Articles