Here you can see a simple process that does the job. It’s far from automated but gets the data in excel in about 5 minutes. Hope that it will help you.
What you need to know before you start:
– you can only go back 10 pages for a given filter, so may want to save old reviews locally. – you need to retrieve by app store country.
To find the reviews just insert the right values to the following URL format: https://itunes.apple.com/CODE/rss/customerreviews/page=1/id=APPID/sortby=mostrecent/FILETYPE
CODE is an App Store territory code. List is available here.
APPID is a your app identification number unique for each app.
FILETYPE This file can be /xml or /json.
Import XML data
If you previously created an XML Map, you can use it to import XML data into cells that are mapped, but there also are several methods and commands for importing XML data without an XML Map.
If you have an XML Map, do this to import XML data into mapped cells:
- In the XML Map, select one of the mapped cells.
- Click Developer > Import.If you don’t see the Developer tab, see Show the Developer tab.
- In the Import XML dialog box, locate and select the XML data file (.xml) you want to import, and click Import.