Hi @Madhuri Prakash Kamble,
Welcome to Microsoft Q&A forum. Thank you for your questions. I understand how disruptive this issue may have caused.
Regarding the error encountered during the CSV-based restore, stating that there are no sites that match the specified URL, this usually means that Microsoft 365 cannot identify the target site URL as an active SharePoint site at the time the restore job runs. This commonly happens when the site is in a soft-deleted state. Soft-deleted sites are retained in the SharePoint admin center under Deleted sites, but they are not considered active, even though the URL is still reserved. Because of this, restore to original URL cannot be completed and the restore process returns this error. Other possible contributors include an incorrect URL format in the CSV file or the site being in a pending deletion state.
For your second question, restoring to the original URL does not work while the site remains soft deleted. A restore to original URL requires the destination site to already exist and be active. While a soft-deleted site still holds its original URL, it is inactive and therefore cannot be used as a restore target.
As a recommended alternative, you can first restore the deleted site directly from the SharePoint admin center by navigating to Deleted sites and restoring the site. Once the site is active again, the original URL becomes available and the CSV-based restore to the original URL can be retried successfully.
I hope you found the answer helpful, and we would greatly appreciate it if you could mark it as accepted. This helps highlight the solution for others who may be searching for similar information in the community. Your contribution not only supports fellow users in finding the right guidance more quickly, but also helps build a more resourceful and collaborative space for everyone.
Thank you for your kindness and contributions to the forum.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.