Which Steps Import Spreadsheet Data into a ServiceNow Table?

CSA By islever Editorial Last updated

Short answer

B Load Data, Create Transform Map, Run Transform

Question

Which set of steps is used to import spreadsheet data into a ServiceNow table?
  1. Select Data Source, Schedule Transform
  2. Load Data, Create Transform Map, Run Transform Correct Answer
  3. Define Data Source, Select Transform Map, Run Transform
  4. Select Import Set, Select Transform Map, Run Transform

Key Takeaways

The exam tests the exact order of the import set workflow — Load Data, Create Transform Map, Run Transform — and the trap is choosing an option that starts by selecting an import set or data source instead of loading the data.

Importing spreadsheet data into a ServiceNow table follows three ordered steps: Load Data into an import set table, Create a Transform Map to map fields to the target table, and Run Transform. The community unanimously agrees the correct answer is B, with 100% of votes.

Common mistake: Choosing D ('Select Import Set, Select Transform Map, Run Transform') because the process involves import sets, but the import set table is automatically created when you Load Data — you never select an import set as the first step.

Expert Analysis

Why the Answer Is Correct

ServiceNow's standard spreadsheet import workflow begins with Load Data, which stages the spreadsheet into a temporary import set table. Next, you Create a Transform Map to define how the import set fields map to the fields on the target table. Finally, you Run Transform to move the staged records into the target table. Comment [1] confirms this exact sequence: 'You need to Load it, Create Transform map based on data, Run transformation.' With 100% of community votes on B, there is no ambiguity.

Why the Other Options Are Wrong

Option A fails because 'Schedule Transform' is not part of a one-time spreadsheet import and it omits both loading the data and creating the transform map. Option C references a Data Source, which applies to scheduled or external integrations (JDBC, LDAP, FTP) rather than a simple spreadsheet loaded via the Load Data module. Option D is the closest distractor since transforms do operate on import sets, but you cannot 'Select Import Set' as a first step — the import set table is generated automatically by Load Data. Comment [4] briefly argued for D, but even that comment's own description ('create new or select existing table') describes what Load Data does, reinforcing B's wording.

Community Comment Notes

Community consensus is overwhelming: every substantive comment backs B, including [1], [2], [3], and [5], with [1] providing the clearest step-by-step rationale. Comment [3] notes consistency with a related question in the CSA question pool, suggesting this workflow is tested repeatedly. The lone dissent in comment [4] actually walks through the same logical workflow, merely mislabeling the first step, which highlights why precise terminology matters on the exam.

Official Reference

These links open the official vendor documentation in a new tab.

Exam Strategy

Memorize the three-step import flow in exact order: Load Data, Create Transform Map, Run Transform. Distractors swap in 'Data Source' or 'Import Set' as the first step — those terms belong to scheduled or external data imports, not the simple spreadsheet workflow. If the question mentions a spreadsheet, start with Load Data.

Community Votes

B
100%

100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 5 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 5

  1. DarksideSunrised 👍 3 Answered B
    You have a spreadsheet: 1) You need to Load it 2) Create Transform map based on data 3) Run transformation
  2. bern_111 👍 3 Answered B
    B should be the correct answer
  3. Cplatt 👍 2 Answered B
    Based on a previous question the answer to this would be "B"
  4. TimmyLam 👍 1
    I believe the answer is D 1. Select your import set (create new or select existing table) 2. Create new or use existing transform map 3. Run the transform
  5. JuanSP 👍 1 Answered B
    B is the right one

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Which ServiceNow ACL Rule Grants Full Table Access?

S-grade

Which three methods can ServiceNow use to notify users of events?

S-grade

Which Storefront Provides Pre-Built Spokes for Third-Party Integrations?

S-grade

Which ServiceNow Roles Are Required to Impersonate a User?

S-grade

Practice All CSA Questions

Access 368 questions with complete answers and detailed explanations.

View Full CSA Practice Test →

← Back to CSA Study Guide