What software can I use on my Mac to open and read a SEOMoz CSV exported file?
-
I do not want to buy XL or Pages just to read the CSV from SEOMoz. So I bought an app on the AppStore... and this app is unable to read the CSV from SEOMoz.
Since I already wasted $2, Id rather avoid to waste more (and avoid that to others too!). What software is recomanded to open these CSV files?
Also, I tried Google Docs, but I bumped in their 400K cells limit
-
I have been struggling with both Excel and Numbers to open the CSV files in order to get everything as they should be. But, I tried the spreadsheet at Google Docs a few minutes ago and the result was perfect
-
I second you on the Excel for Mac is brilliant.
-
Another option, without needing extra software is to calculate how many rows you can show in google docs, given the number of columns, and then use the text editor to split the CSV into two or more files.
Excel for Mac is brilliant, by the way. I love it.
-
Ultraedit or any similar Text Editor will do. Here's a link to Ultraedit for Mac Download http://www.ultraedit.com/files/uex/OSX/UltraEdit_3.0.0.16.dmg
-
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
I am using moz pro but ı can't use keyword explorer
hi am buying moz pro but can't please help me. ı want scan this web site https://baliktasarim.com/
Moz Pro | | nurmasumi20020 -
Can I add another user to my SEOMoz Pro campaign?
I have a couple of campaigns on my SEOMoz Pro account and I would like to give access of one of theses campaigns to a SEO consultant, is that possible? Or do I need to give access to my full SEOMoz account?
Moz Pro | | bernardovailati3 -
Can I rely on Keyword Difficulty tool?
I just ran into a problem that I hadn't expected. Testing the Keyword Difficulty I saw the results contained a result for a page that has Domain Authority=1 and Page Authority=1. As a result, Keyword Difficulty was reduced (compared to last month), which may actually be reversed if the site is crawled. Sadly, I didn't run the report on the figures as it was a small project. Questions: Can I rely on results shown by Keyword Difficulty? Are results where Domain Authority =1 are used to calculate Keyword Difficulty? If so, why is that? Is there any difference between a page that has received no links and a page that OSE/Mozscape has no link data for? The problem Using the Keyword Difficulty tool, I found swings of up to 14% in Keyword Difficulty (between Oct -Nov). Dr Pete may suggest that this is because of changes in Google's index ( http://www.seomoz.org/blog/a-week-in-the-life-of-3-keywords ). However, It would be helpful to have a figure for Keyword Difficulty that isn't affected by the gaps in the Mozscape data. The (bad) solution You can mirror something close to Keyword Difficulty using: =(Sum of Page Authorities + Sum of Domain Authorities )/20 Right now, I have resorted to manually calculating keyword difficulty. I use the SEOMoz Page Authority & Domain Authority figures and a quick splash of Excel SUMIF and COUNTIF. I find the results don't look as 'easy' when I can ignore results where the data is unknown (PageAuthority=1 & DomainAuthority = 1). Background Info One result I still have a report on is for the phrase [fixing your business puzzle] using US Results on Google. For the specific result, I found the additional information about the site: DNS lookup shows the domain was registered in 2010
Moz Pro | | Darroch
Archive.org shows no records
OSE shows no data for the site
Site uses https
Google showing No links
Robots.txt file seems fine
No Sitemap.xml0 -
Has the relevancy of SEOmoz tools disappeared?
I have A rankings for my on-site grades for my most important keywords. I have no Critical issues and no Warnings with my Crawl Diagnostics. Most of the Competiive Link analysis data shows my site beating out the competition. If all this is accurate, how can my SERPs continue to decrease and lesser pages with terrible optimization and backlinking be ranking higher? I even have a facebook page beating me in the results. If there is nothing left for me to address using SEOmoz, and I keep getting worse & results, doesn't it mean that the SEOmoz tools are not relevant to producing actual results? Or, am I missing something?
Moz Pro | | TOPYX0 -
How can I download all the inbound links to my Site?
Hi, From Site Explorer, I want to download all the inbound links linking to my site: www.comm100.com/livechat/. But it seems that there is a limitation. I can only download a part of the inbound links? What should I do? Or is it because my account is free trial? Do I have to pay for it? Please help. Thanks,
Moz Pro | | Sophia_M0 -
A grade but no ranking. Can anyone help?
Hi there, I'm new to SEOmoz but familiar with SEO in general. I recently setup a new campaign for my wife's eCommerce business - www.toucankids.com. We optimized 6 pages for 6 well researched key phrases. These pages have been indexed by Google however they didn't show up in the on page reports section of SEOmoz. I've just worked out how to add them manually so i've done that. The good news is that all of the pages get an A grade so we must be doing something right. The bad news is that we haven't got a top 50 result for any of them which is quite disheartening. I'd rather not invest lots of effort more page optimisation if this approach isn't working. Can anyone offer any advice on next steps / fine-tuning? Thanks in advance! P.S. We're going through a process of link building to try and improve our domain authority at the moment so i'm hoping that Friday's linkscape update will give us some better news in that department.
Moz Pro | | rmbdigital0 -
Why does it take so long for SeoMoz to update data?
I changed the Anchor Text of 4 40/100 MozRank sites 2 months ago, yet SeoMoz still shows the old Anchor text in the reports. Why is this taking so long? I also notice my inbound domains hasn't increased nor has my MozRank in 3-4 weeks. What's the turnaround?
Moz Pro | | sanchez19600 -
Recommended Q&A Software
So I just read an SEOMoz post about the great SEO benefits of Question and Answer sites (or sections of sites) - much like the Q&A section I'm in right now. 🙂 I did some googling and haven't really found a good software for implementing (installing, skinning, integrating, etc.) a Q&A section on my website. There are a few out there, but they are pretty basic, nothing like this site or Yahoo Answers. Anyone know of good software (i'm on a PHP server) to implement Q&A on my site? Something that has the look and feel of this site or answers.yahoo.com, etc.? Thanks for the help!
Moz Pro | | mynewco0