Format input
easily
Format your input for IN clauses of SOQL/SOSL queries easily. For example, if you want your SOQL query to be SELECT Name FROM Account WHERE BillingCity IN ('London', 'Paris', 'Rome') then simply paste in the cities in the box below and then select the 'Format input' button to return 'London', 'Paris', 'Rome'.
Save time
with less exports and VLOOKUPs
For example, if you already have a list of Account IDs and need to retrieve their corresponding BillingCity, simply paste the IDs and click 'Format input.' You can then construct your SOQL query like this: SELECT Id, BillingCity FROM Account WHERE Id IN ('001abc', '001xyz'). This approach eliminates the need to export all Account IDs with their BillingCity values and perform a VLOOKUP to generate your report.
Use with
confidence
This service is completely stateless, ensuring your data remains private and secure. Every time you format your data, it’s processed instantly on the client side, keeping it fully under your control and never stored or shared.
VSC
extension ready
If you prefer, you can use the VSC extension version too. Search for the 'IN Clause Ready' extension and install.