Run SOQL queries and export the results, or bulk import/update/upsert/delete records from a CSV file — without leaving VS Code. Inspired by the "Data Export" and "Data Import" features of the Salesforce Inspector Advanced Chrome extension.
Requirements
Salesforce CLI (sf) installed and at least one org authenticated (sf org login web). This extension reuses those authenticated sessions instead of asking you to log in again.
Features
Export (SOQL)
Run SF Data Toolkit: Open Query Editor (Export) from the Command Palette.
Pick a Salesforce org (first time only, or click the org indicator to switch).
Write a SOQL query and click Run Query. Results (including flattened parent-relationship fields like Account.Name) render in a table.
Click Export to CSV to save the full result set to a file.
Queries are auto-paginated up to 50,000 records; a warning is shown if a query is capped.
Import (CSV)
Right-click a .csv file in the Explorer and choose SF Data Toolkit: Import CSV Data (or run the command from the palette and choose a file from the Import tab).
Pick the target object and operation (Insert / Update / Upsert / Delete). Upsert requires an External ID field.
CSV columns are auto-matched to fields by name — adjust the mapping table if needed.
Click Start Import. The load runs via Bulk API 2.0. On completion you'll see a success/failure count; if any records failed, an error log CSV is written next to your source file.
Development
npm install
npm run watch # esbuild in watch mode
Press F5 in VS Code to launch an Extension Development Host with the extension loaded, then try the commands above.
