Data Export & Import

TurboKit provides powerful tools for querying, exporting, and importing Salesforce data, making it easier to manage your data across environments.

Data Export

The Data Export tool allows you to execute SOQL queries against your Salesforce org and export the results in various formats.

Key Features

• SOQL Query Builder: Write and execute SOQL queries with intelligent autocomplete for objects and fields
• Query Performance Metrics: View execution time and batch statistics for your queries
• Multiple Export Formats: Export data as CSV, Excel, or JSON
• Query History: Access your recent queries for quick reuse
• Query Templates: Save and reuse common query patterns
• Field Selection: Quickly select all fields or only custom fields with keyboard shortcuts

Using Data Export

1. Open TurboKit and select "Data Export"
2. Enter your SOQL query in the query editor
3. Use the autocomplete feature to help build your query
4. Click "Execute Query" to run the query
5. View the results in the data table
6. Export the data in your preferred format

Advanced Features

• Keyboard Shortcuts: Press Ctrl + Space between SELECT and FROM to insert all fields
• Custom Query Templates: Define your own query templates for quick access
• Query History Management: Save frequently used queries with descriptive labels

Data Import

The Data Import tool allows you to import data into Salesforce, with intelligent field mapping to simplify the process.

Key Features

• Intelligent Field Mapping: Automatically map fields based on field names or API names
• Multiple Import Formats: Import data from CSV, Excel, or JSON files
• Validation: Validate your data before importing to catch errors
• Batch Processing: Import large datasets in manageable batches

Using Data Import

1. Open TurboKit and select "Data Import"
2. Upload your data file (CSV, Excel, or JSON)
3. Select the target Salesforce object
4. Map the fields from your file to Salesforce fields
5. Validate the data to check for potential issues
6. Import the data into Salesforce

Best Practices

• Always validate your data before importing
• Use unique identifiers when updating existing records
• Consider using External IDs for more reliable record matching
• Test imports in a sandbox environment before using in production

Integration with Other Features

The Data Export & Import tools integrate seamlessly with other TurboKit features:

• Use the REST API Explorer to understand the underlying API calls
• Combine with Metadata Inspection to view field details before exporting or importing
• Use with Profile Reader to ensure you have the necessary permissions for the objects you're working with