Yes, this is a common setup.
If the sheet structure is stable, Salesforce Flow works well to create Leads with validation and de-dupe. For quicker setup or more flexibility, tools like Zapier or Make are commonly used to sync rows into Salesforce.
Main thing is to lock down required fields, handle duplicates early, and avoid the sheet becoming a second CRM.