We will describe how to work with Devart Excel Add-in for Salesforce in details below:
1. On the Devart tab, in the Import group, click "Get Data".
2. In the "Devart Excel Add-ins: Import Data Wizard", in the Data Source list select "Salesforce".
3. Set the connection parameters in order to connect to your database.
4. After you have set the connection parameters and Test Connection is successful, click Next.
5. The next wizard page is displayed, and you can select the required database object on the "Visual Query Builder" tab. In the right part of the page you can configure filters for data to select.
6. Alternatively, on the "SQL Query" tab you can enter your own SQL query to select data.
7. After you have specified query settings on the "Visual Query Builder" tab or entered your query on the "SQL Query" tab, click Next.
8. The next window displays the first 10 rows of the selected data.
9. By default, a new worksheet with the name of the corresponding Salesforce object is created. You can change this name or use an existing worksheet.
10. After clicking Finish, the data will be imported to the Excel worksheet.
You can edit existing rows of a table and add new ones and submit changes back to Salesforce. For this, perform the following actions:
1. After you have imported data, on the Devart tab, in the Edit Session group, click "Edit Mode";
2. Make the necessary data changes and click Commit. The changes will be sent to the server;
3. Click "Edit Mode" again to turn off the edit mode.
You can also read Excel Add-ins documentation. If you selected the 'Help files' check box during the Excel Add-in for Salesforce installation, the documentation can be accessed from Start Menu->All Programs->Devart Excel Add-ins->Documentation. You can also find the help file at
https://www.devart.com/excel-addins/download.html