Welcome to the Q&A Forum

Browse the forum for helpful insights and fresh discussions about all things SEO.

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Trouble Exporting Xenu Crawl to Excel

Competitive Research

5649

BrittanyHighland last edited by

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!
1 Reply Last reply
Reply Quote 0
timhatton last edited by

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.
1 Reply Last reply
Reply Quote 1
john4math last edited by

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.
1 Reply Last reply
Reply Quote 1

Got a burning SEO question?

Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.

Start my free trial

Browse Questions

View

From

Sorted by

With category

Explore more categories

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 | | Sugartheagency

0
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 | | RonMedlin

0
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 | | remkoallertz

0
The starter crawl is going on 2 days and no results

Does the starter crawl work in the first 30 days? Mine has been going 2 days and still no results, has finished yet??
Competitive Research | | WalterW

0
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 | | escteam

0
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 | | adriandg

0
Keyword Trouble

Having the worse time trying to figure out what keywords to use on my website. Run a E commerce site and we sell HID lighting and aftermarket Lighting or High Intensity discharge lighting. Now when thinking about why people would come to our site...the obvious reason would be to buy HID kits. BUT here is the problem, Every keyword that i throw into the seoMoz keyword difficulty tool or any other tool whether its Google or whatever comes back as super high competition for that word. Now i find low comp words but they don't really relate to my site and could kill my bounce rate percentage. Not sure what i could do or if anyone has any tips that can point me in the right directions. It sounds like i am going to have to muscle my way through this one. Any help please guys.
Competitive Research | | Horrific_ending

0
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 | | BlueFountainMedia

0