Which Steps Import Spreadsheet Data into a ServiceNow Table?

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 Source Reference Answer
  3. Define Data Source, Select Transform Map, Run Transform
  4. Select Import Set, Select Transform Map, Run Transform

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.

Community Insight

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.

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.

Community Discussion (5 comments)

JuanSP 👍 1 Selected: B
B is the right one
DarksideSunrised 👍 3 Selected: B
You have a spreadsheet: 1) You need to Load it 2) Create Transform map based on data 3) Run transformation
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
Cplatt 👍 2 Selected: B
Based on a previous question the answer to this would be "B"
bern_111 👍 3 Selected: B
B should be the correct answer

Comments & Corrections

No comments 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.

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

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.

Related Analysis

Practice All CSA Questions

Access 368 questions with complete answers and detailed explanations.

View Full CSA Practice Test →

← Back to CSA Study Guide