How to export the data of your pages
Visual SEO Studio makes your work flow less dependent on a spreadsheet, yet there are many cases when you want to export crawled pages data.
Why exporting data?
- pass data to team mates in a common format
- create customized reports for the clients
- integrate analysis with external data
- further elaborate data with tools typical of a spreadsheet (e.g. pivot tables, etc...)
- create graphs not provided by the tool
How to export data from any Visual SEO Studio table
Every single table with data in Visual SEO Studio can natively be exported to Excel and CSV formats.
All you have to do is:
- click on upper-left gear icon and pop up a context menu
- select the desired format (e.g. Excel)
- confirm a file name and location
- you'll then be asked whether to open the newly created document
Exporting to Excel has the advantage over the CSV format that data types are already correct: dates, number, etc... are stored with own formats, and the header is pre-formatted.
We are proud to say Visual SEO Studio has been the first SEO tool to support native Excel format (compatible with OpenOffice and LibreOffice as well).
Export data with helper buttons
Some reports and functions within Visual SEO Studio provide a visible button to export data, easier to spot compared to the context menu. The functions are equivalent.
Such helper buttons can be found for example in Tabular View, or in Links Inspector.
Export to Excel helper button
Export data shown in suggestions tree-views
Data shown in tree views - e.g. duplicated titles in HTML Suggestions, and many other cases - can be exported passing through the Tabular View.
Open in Tabular View data from a suggestions tree-view
The filtered data will be loaded in Tabular View as a subset of the entire crawled pages. From there, you'll be able to export the table content the usual way.
Exporting to XML Sitemap
The Tabular View also permits to export its content to an XML Sitemap.
This makes a very powerful feature when the loaded content is a specific subset. For example you might want to produce a specific subset of pages using a Custom Filter; this a common scenario for e-commerce owners who want to submit a sitemap for only a set of product pages, or for webmasters who want to accelerate the discovery of redirected pages.
Export to XML Sitemap button
Note: there are other ways to build a XML Sitemap, more immediate. Read the Visual XML Sitemaps Tools page for further details.
Read more Visual SEO Studio tutorials.
No registration required