ubricHelp

Exporting to CSV and Sheets

Download the four Rubric CSVs and load them into Google Sheets or Excel to build your own tracker.

Rubric exports four CSV files from a report: action-plan.csv, pages.csv, broken-links.csv and sitemap-issues.csv, using the download buttons in the report. Each is a plain CSV you can open in Google Sheets or Excel, so you can sort page scores, filter failing checks and build your own tracker on top of Rubric's data.

In short
  • →Rubric exports four CSVs: action-plan.csv, pages.csv, broken-links.csv and sitemap-issues.csv.
  • →Download them from the buttons in the report, then open them in Google Sheets or Excel.
  • →Use them to sort pages against the 70 line, hand failing checks to developers, or build a tracker.

What CSVs can I export from Rubric?

Rubric exports four CSV files, one for each part of the report you are most likely to work with outside the app. You download them from the export buttons in the report. Between them they cover the ranked fixes, every page with its score, the broken links found during the crawl and any problems with your XML sitemap.

FileWhat it contains
action-plan.csvThe ranked, phased fixes from the Action Plan (Phase 01, 02 and 03)
pages.csvEvery crawled page with its citability score
broken-links.csvBroken outbound links found during the crawl
sitemap-issues.csvProblems found with your XML sitemap

How to open a Rubric CSV in Google Sheets

Google Sheets imports a CSV in a few clicks.

01
Download the CSV. Use the export button in the Rubric report.
02
Open the import dialog. In Google Sheets, choose File, then Import, then Upload, and select the downloaded file.
03
Import with a comma separator. Choose to insert it as a new sheet and let Sheets split on commas. The columns line up automatically.

How to open a Rubric CSV in Excel

Excel can open a Rubric CSV directly, or import it with more control.

01
Open the file. Double-clicking the CSV opens it in Excel with the columns already split.
02
Or import it for control. Choose Data, then From Text/CSV, and pick the file if you want to set the delimiter or the data types yourself.
Tip
If numbers or scores look wrong after opening, re-import with Data, then From Text/CSV, and set the score column to a number type. Opening very large files directly can occasionally misread a column that a guided import handles cleanly.

Building your own tracker

The exports are built to be worked in a spreadsheet, which is where you turn a one-off audit into something you track over time.

  • Sort pages.csv by score, lowest first. This is your weakest-pages list, worst at the top.
  • Filter to pages below 70. These are the pages an engine tends to answer around rather than name. They are where the score is won.
  • Watch the middle, not just the bottom. Your site score is the median of the page scores, so lifting the pages in the middle of the pack moves the site number more than polishing pages already above 70.
  • Feed action-plan.csv to your developers. The phased fixes make a ready-made checklist for a build sprint.
Note
A CSV is a snapshot from the crawl it was exported from. When you have shipped fixes, re-run the crawl and export again to refresh the numbers. There is no automatic weekly re-crawl of sites you have not added to your Watch list.

When to use a CSV over the other options

Export to CSV when you want the data in your own spreadsheet: to hand fixes to a developer, to build a tracker, or to combine it with other data such as measured citations. If you would rather your own AI assistant read your live results, connect the MCP instead. The related articles on exporting your data and handing fixes to developers cover the export tabs and turning action-plan.csv into a developer checklist.

Common questions

Did this answer your question?