Welcome to the Q&A Forum

unbelievable, we re pushing 2014, and still i have to do this manually.

Hi there,

i hope someone knows the solution to this problem.

I created/ copied the "advanced Excel Keyword Analysis Report" that Dan Peskin was kind enough to share, you can find it here: http://moz.com/blog/how-to-build-an-advanced-keyword-analysis-report-in-excel.

Now i m looking for a solution to rank my Keywords by using an API, preferably the MOZ API. My keywords are alligned in a column "Keword List", which will be regularly updated. Next to this column i would like to have a column with the corresponding rank.

Is there a automatic solution, or do i have to do it manually?