Welcome to the Q&A Forum

Thanks - excellent analysis. Exactly what I was looking for and hadn't considered this possibility. Will dig in!

How it works: After crawling a website with Screaming Frog, export the data into one of the three available file formats (.csv, .xls, or .xlsx). Copy all of the data from the Screaming Frog worksheet (starting in cell A4) into cell A2 of the ‘data’ sheet of this analysis workbook. The easiest way to copy all the data is to click cell A4, the use Ctrl + Shift + RIGHT to select all columns of data. Then Ctrl + Shift + DOWN to select all rows of data. Then use Ctrl + C to copy the selected cells. Go to the data sheet of this workbook and Ctrl + V to paste that data into cell A2. Pasting the data into cell A2 will align all the data with the column headers I already have in row 1. If this data does not align properly, then there is an added or missing column of data which you will need to adjust for in the ‘data’ spreadsheet. Report tab The reporting tab is set up to make customizing this report for each website as easy as possible. Hope it helps you. E1hkbk6.png gWksyX0.png