Batch lookup domain authority on list of URL's?

[SirSud]

I found this site the describes how to use excel to batch lookup url's using seomoz api.

The only problem is the seomoz api times out and returns 1 if I try dragging the formula down the cells which leaves me copying, waiting 5 seconds and copying again.

This is basically as slow as manually looking up each url. Does anyone know a workaround?

[Mark_Ginsberg]

You'll have to do this in Google docs and not in Excel, but try this solution:

http://www.seomoz.org/ugc/updated-tool-seomoz-api-data-for-google-docs