Export Settings in Netpeak Spider

1. File export format.
2. Regional settings.
3. Export all issues.
4. Report name settings.
5. Additional options in export settings.
6. Export data to Google Drive.
   
   

Netpeak Spider allows exporting almost any report in a few clicks using the ‘Export‘ button on the control panel or the main menu.

Learn more about all possible options of data exporting in the article ‘Saving and export of results‘.

You can choose the format and report parameters in the ‘Export‘ tab of the program settings. Please note that these settings don’t affect data exported from the ‘Dashboard‘, and the ‘Audit of the optimization quality (PDF)‘ report.

1. File export format

1.1. .XLSX is a common format used by Microsoft Excel. It supports cell selection and parameter description similar to results table in Netpeak Spider.

When exporting a report containing more than 1,000,000 URLs, Netpeak Spider will automatically split the file into several files due to the format limits.

Also, note that there are the following limits for export in XLSX:

• Row limit: 1_048_500 
• Column limit: 16_300 
• Cell value limit: 32_767 
• File size: 4 GB

1.2. .CSV is a text format designed to store tabular data.

If you open a .CSV file via LibreOffice, it is important to set the following configurations:

• Character set → Unicode (UTF-8)
• Separator Options → Comma

There are no limits for export in this format.

1.3. Google Sheets (Google Drive) is an online spreadsheet format from Google. Supports cells highlighting, parameter description, and sharing access via link. More about Google Drive setting → in section 6.
Limits for export in this format are the following:

• Row limit: 1_048_500 
• Column limit: 16_300 
• Cell value limit: 32_767 
• File size: 4 GB
• Cells: 2_000_000

2. Regional settings

Using regional settings, you can choose a locale – a set of parameters that defines regional settings of the user interface, such as language, country, time zone, charset, etc. You can:

• Use the current locale of the app according to the language chosen in the general settings (Russian or English). This configuration is set by default.
• Set locale – choose a country and a region from the dropdown list.

The selected locale may affect the date and time format, and delimiters used in exported reports.

3. Export all issues

The ‘Export All Issues‘ section contains the following settings:

Export notice issues → by default, all issues are included to export. But using this setting you can exclude the notice issues from export, as they usually do not critically impact SEO efficiency.

Export all columns → by default, a corresponding set of columns is exported for each issue. Check this setting to enable the exporting of all analyzed parameters.

4. Report name settings

Report names in Netpeak Spider are formed in the following format: export date ~ project name (website domain) ~ issue or table name ~ number of URLs ~ Netpeak Spider ~ HHMMSS. In the ‘Report name settings‘ section, you can configure such settings as:

Add base prefix (project name and date) → tick to let the program automatically add the date (year, month, day) when a project was exported to the name of a file and the name of the project (by default, website domain).

Add issue severity → (works for exporting the ‘All issue reports‘ set) tick to let the program add the severity of issues to the name of the report (Error, Warning, Notice).

5. Additional Options in Export Settings

Save cells highlighting when exporting tables in .XLSX and Google Sheets formats → works for exporting the current table (the ‘Export... ‘ button above the main panel of the program) and allows to export a report with cell highlighting and link formatting.

Include unique hashes to special reports → allows adding the ‘Page Hash‘ and ‘Text Hash‘ parameters to export special reports.

6. Export data to Google Drive

The opportunity to export reports to Google Drive is implemented in the Pro plan.

This feature allows you to export reports or PDF audits for quick share and real-time communication. You need to add your Google account to export data from the program to Google Drive. To do so:

1. Open the ‘Export‘ tab in the settings and choose ‘Google Sheets’ file export format.

2. Click on ‘Add new Google account‘, choose the necessary account, grant all the permissions for further work.

3. After granting the permission in the ‘Saved Google accounts‘ menu, you can see the accounts that will be used as the final destination for crawled data. You can add the unlimited number of accounts. To see all available accounts, click on the dropdown list.

4. If you need to delete a saved account, just choose it in the dropdown list and press ‘Delete Google account‘.