Can you export a keyword rankings report with the keywords listed in order of ranking ?

[jlane9]

My keyword ranking report shows the results all jumbled.

I can put them in order when viewing the report online, but when I export it , the results go back to all jumbled rankings.

[danatanseo]

Hi Joseph,

While there's not a way to pull this data out of SEOMoz pre-sorted, this can easily be done by exporting this data into a CSV, electing your datafields and then formatting these as a table in Excel. Then you can simply click whatever header you want (i.e. Google US Rank) and sort from smallest to largest, numerically, then Voila! You have your keywords sorted in order.

Hope that helps!

Dana