*Updated 28th March 2018, this is a rewrite of how the output is provided so please re read the instructions.
I love the On-page Optimisation in MOZ. This feature allows you to enter your focus keyword against a page for the url you wish to score.
The GetYoastData output can also be used for adding keywords to the Position Tracking/Rankings Overview section of semrush plus may other applications.
Personally I add my focus keywords with a label just to keep it tidy when reporting back. However you can not extract the url from the database as it is created via the get_permalink() or get_page_link() functions.
I created GetYoastData which outputs to a csv (Excel) file that can be downloaded via FTP.
Grab the code and save it to a file called GetYoastData.php on your desktop
Edit the ‘MySecretKEY’ to any string that you want. This will form a basic security key as part of the URL.
Create a folder in the root directory via FTP (where the wp-config.php file is) for this example we will assume the folder name ‘yoast’
Upload GetYoastData.php to your new folder (yoast) via FTP
Visit page www.YOUR-DOMAIN.COM/yoast/GetYoastData.php?key=MySecretKEY
Refresh your FTP client and you will see a new file named ‘Yoast Data Output.csv’
Download the file Yoast Data Output.csv
I would recommend that you delete your newly created folder (‘yoast’)
A rewrite of how the data is output, which is no longer output to the screen, you will need to download the csv file via FTP.
Changed table_prefixes fixed as suggested by Alexander
Added basic security
Applied changes re get_permalink() as suggested by Joost de Valk
Compatible with WordPress SEO – Version 1.5.3