You are here: Query > Run: Download mapped object data from Salesforce to Excel

Run: Download mapped object data from Salesforce to Excel

When you click the Run tab, the data file opens.

  1. In the Extract Records box, type the number of records to return, or check the All box.
  2. If you want the downloaded data to start on a different row, type the row number in the Start Row box.
  3. Click Write Records, and then click Append or Overwrite.

    Overwrite will replace the only data for the number or rows specified. For example, if a previous query returned 100 rows and the new query returns 50 rows, the data set will display rows 1-50 of the new run and rows 51-100 from the previous run.

  4. Click Script, click Save, and save the script.
  5. Click Run to download the data from Salesforce.

    You can also click Run and then click Partial Download.

Other run features

  • Data File: To create a new data file, open a different data file, or save the active data file, click Data File and click the command you want.
  • Write Headers: To add the mapped columns to a new sheet, click Write Headers.
  • ID Column: Studio automatically adds the ID Column from the Data File Preview.
  • Log Column: Studio automatically adds the Log Column from the Data File Preview.
  • Send email on run: Check the box to send email notifications automatically after the run. The email addresses for the sender and recipients are set on the Email Settings tab of the Application Options box.
  • Schedule: Schedule a script to run regularly or at a later time. For more information, see Schedule a run.