At some point you’d have to take a deeper look into your websites sitemap. You should definitely do this if your sitemap does not get fully indexed into Google and you want o find out why. If you open the XML sitemap with a text editor it will most likely be in this format:
Step 1: Open Excel, click in the top left corner on “File” > “Options”.
Step 2: A little menu will pop up. Click on “Customize Ribbon” to edit the navigation tabs in Excel.
Step 3: In the tab “Main Tabs” activate the tick-box for “Developer”. This will unhide the Developer tab in Excel where you’ll find the option to import XML files.
Step 4: Click okay to leave the settings menu and click on Developer in the top navigation. On the right side will be a button called “Import”. Click that button.
Step 5: You can now select the XML Sitemap file you want to import. Click on “import” and follow the steps to paste all the information from the file into the first row/column (A1) of your spreadsheet.
Step 6: As filters are already activated and the values are in the correct cells, you can now review the sitemap data to see where you might have errors.
Step 7: Based on the steps before you can also prepare a text-file which can get uploaded to a scraper like “ScrapeBox” or “ScreamingFrog”. These tools will give you the values you need to make further decisions on your sitemap.