To import Salesforce data into Excel, you can use the Salesforce Excel connector.
Step 1: Open Excel and go to the Data Tab → New query → From Other sources.
Step 2: Next, select → Salesforce objects → choose one option from Production or Custom → enter your Salesforce credentials, if asked for.
You will have 2 options here.
Step 3: Navigator allows users to select SF objects OR use the “Load To” option to load to a table or create a connection.