XL-Connector is an Excel extension that allows us to pull and push data to Saleforce from within Excel.
Setup and pulling data from Salesforce
If you need to reference a list of values for an IN query, use these steps to achieve it:
[@Tablename[Columnname]]SELECT Id, Name FROM Contacts WHERE Id in [@Contacts[Id]]For more reference on dynamic values within XL-Connector, check this link:
https://www.xappex.com/knowledge-base/importing-data-from-salesforce-com-using-soql-2/#dynamic
Note: Table Ranges ([@Tablename[Columnname]]) are more reliable than cell references (Sheet!A2:A100) because you can add values to your table without rewriting your range referenced (e.g. from A2:A10 to A2:A100 when the data changes)