You are here: More... > Use cell-based mapping

Use cell-based mapping

You can use cell-based mapping to upload or download one record at a time.

When you use cell-based mapping, the header is written in the cell to the left of the value in the Value column of the Mapper.

For example, if you type the cell C2 in the Mapper, the header is written to cell B2.

Map single-object scripts

Cell-based mapping for Create, Update, and Upsert

  1. Click the Map tab, and select the fields in the Mapper.
  2. Click AutoMap, type the cell numbers in the Value column, or drag the fields from the Mapper to the Excel Preview.
  3. Click the Run tab.
  4. Enter the data for one record, and then click Run.

Cell-based mapping for Query

  1. Click the Map tab, and select the fields in the Mapper.
  2. Click AutoMap, type the cell numbers in the Value column, or drag the fields from the Mapper to the Excel Preview.
  3. Click Condition, and add the criteria for the query.
  4. Click the Run tab, and then click Run.
  5. In the Preview of Records box, select the record that you want to download, and then click Copy Selected Row.

Map master-detail scripts

Cell-based master-detail scripts work the same way as single-object scripts, with these exceptions:

  • The master fields use cell-based mapping, but the detail fields use column-based mapping so that you can upload or download multiple details for a master object.
  • Single-sheet mapping is the default for master-detail scripts. To use multiple-sheet mapping, choose Multiple Sheets in the Use Sheets box.
  • Auto Map for single-sheet mapping writes the headers for the master object in column B. Headers for the detail objects are written in row 15, starting in column D. You can change the row number.
  • Auto Map for multiple-sheet mapping writes the headers for the master object in column B and the headers for the detail objects in row 1, starting in column A.
  • Studio for Salesforce bases conditions and headers on the object that is listed as the active object.

    For example, before you click Write Headers, make sure that the object you are writing headers for is listed as the active object.

  • When you use single-sheet mapping, you can write the headers to any sheet in the workbook and run the script from that sheet. Choose the object in the Active Objects list, and then click Write Headers.
  • When you use multiple sheets, you must run the script from the sheets that are mapped.