Start by removing obvious duplicates and fixing formatting issues like state abbreviations (use "CA" not "California").
Use conditional formatting in your spreadsheet to highlight duplicate item names.
The first entry imports, and duplicates get skipped.
Focus on the most critical 100 to 500 items first rather than trying to perfect everything.
Search "data validation" in the Knowledge Base or contact Customer Success for a spreadsheet review.
Open your Settings > Import and get started right away.

