Trouble Exporting Xenu Crawl to Excel
-
I'm trying to export a Xenu file to Excel, but Xenu is only giving me the option to save as a Xenu or txt file...which I can't open with Excel. What am I missing?
Thanks!
-
I think you might be doing Save As... rather than Export.
You should have the option "Export to Tab Separated File" under the File menu? That will export to a TSV format which Excel can read quite happily.
-
I've never used Xenu before, but if you can save the export as a txt file, you can import that into Excel. Here are some sample directions I found.
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
-
SEOMOZ EXCEL PLUGIN ARRAY FORMATTING
Morning All, I have followed along, and am trying to build my own " dashboard", SEOmoz API in Excel, to get the Domain Authority and MozRank for a bunch of URLs. I have a list of competitor sites / related competitors, and I want to pull in the moz url metrics so I can decide who to investigate further. I'm using this array SEOMOZ_URKMETRICS_toFit(A2,"Cols=128" and it keeps listing the results vertically. All the tutorials show this lovely link data in horzontal rows to the right of the url in question, but mine doesn't want to behave. PS. I do know the bit data is wrong, I'll fix that. Thanks in advance to anyone who can help.
Competitive Research | | Sugartheagency0 -
How Do You Create an excel spreadsheet of all blog post content on a site?
Is there a quick and easy way to create an excel spreadsheet with a list of all blog content and it's SEO factors i.e. URL, title, description, etc.? I know I could use screaming from to get the entire site but is there a way to just get the content on the blog?
Competitive Research | | RonMedlin0 -
Majestic gives me a 24 situation and 24 trust flow. Seomoz just a total number of 7\. How come the difference? My ranking is still bad, so is Majestic crawling faster then google?
Hi, my total domain value number on SEOmoz is 7. In Majestic it is 24 situation and 24 trust flow. My ranking is still bad (page2) and my competitors have a lower trust/ situation flow in Majestic. But in Seomoz the're better. Is the conclusion that Majestic is more up to date then Google itself and that Seomoz is more inline with the google crawling? Because Majestic doesnt reflect my ranking. (ps I started with the domain for a month, and I only have some history in registration)
Competitive Research | | remkoallertz0 -
Why my site is not crawled by open site explorer?
Hello friends, Im new here... I just create a campaign for my site www.electrosecurity.com.ec , but when I try to use open site explorer to see anything there... I receive a message saying that my site is not crawled... What can I do? I have a few links coming to my site.. but these links does not appears on my campaigns details.. for these links my site is PR3, but i can not see any of this links on the general view of my campaign. Sorry for my english....
Competitive Research | | lans27870 -
Page quantity vs no crawl errors.
Which one is better: Have a ton of pages but accept crawl errors or; Have a lot less pages with no crawl errors. Let's say I have a product catalogue with 10 regular pages and 500 product pages (same page with content and title defined by url parameter like 'id'). It seems that even with a different product name, product description, price, color etc, I get dupplicate content crawl errors. I also know I could use a link tag with cannonical rel attribute to fix the crawl errors but I would lose indexing on 499 pages. In this case is it better SEO wise to have: 510 pages with 499 dupplicate content crawl errors or; 11 pages with 0 crawl errors?
Competitive Research | | escteam0 -
Excel workbook for SEO?
A while back someone on here posted a really good workbook for analyzing ranking factors for competitors. Unfortunately I lost it, and I am hoping someone might know what i'm talking about and hit me up with a link to it, or perhaps your favourite seo workbook for excel? Thanks!
Competitive Research | | adriandg0 -
Excel Concatenate Function for Google Places?
I'm trying to expedite my research by using the concatenate function. How should the search URL be modified to trigger a google places search as opposed to a normal search. Thanks!
Competitive Research | | BlueFountainMedia0 -
How due I take the advanced report that i have exported as a excel file and recreate your online color coded version with the data.
In the keyword difficulty screen how do I recreate your beutiful color coded spreadsheet in the exported excel file based on the advanced reports.
Competitive Research | | bmcfarlane0