---
sourceDocument: Yokohama IT Operations Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/it-operations-management

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama IT Operations Management

ft:clusterId :

    - itom

bundleId :

    - itom

workflow :

    - Technology


---

# Prepare a CSV file for mapping your candidates

# Prepare a CSV file for mapping your candidates {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Organize information about potential application services (candidates) in your
organization and save it in a CSV file.

## Before you begin

Role required: service_mapping_admin

## About this task

## Procedure

1. Create an .xlsx file.
2. Define entry point attributes for service candidates in the .xlsx file.  
   Customers use these entry points to access services. For example, they use http://www.google.com:8080 to access the Google page.  
   Warning:  
   Do not confuse column order in the .xlsx file. Entering attributes in wrong columns causes mapping errors.  
   {#prepare-csv-file__table_spv_tbv_tw__entry__2}

   | Column | Description |
   |-|-|
   | A | Enter a unique name of the planned service instance. For example, NY Public Library or Google. Warning: Service Mapping imports only application services with unique names. If there is more than one entry with the same name in CSV files you use, the latest imported record overwrites the previous ones. |
   | B | (Optional) If you know the URL that serves as the entry point to your service instance, enter it in this column. For example, enter https://www.nypl.org/ or www.google.com:8080. Warning: If you define the URL, you do not have to define the IP address, port, FQDN, and protocol. Service Mapping parses the URL to extract the IP address, port, and FQDN. If there is no URL that serves as the entry point, define other parameters in columns C, and E. |
   | C | (Optional) The IP address of the entry point in the IPv4 format. Enter this parameter only if you did not enter the URL in column B. |
   | D | (Optional) The port of the entry point. For example, 8080 for the Google page. Enter this parameter only if you did not enter URL in column B. If you did not enter either URL or the port, Service Mapping uses port 80 for the http protocol and port 443 for the https protocol. |
   | E | (Optional) The FQDN of the service entry point, for example,www.google.com for Google. Enter this parameter only if you did not enter the URL in column B. |
   [ ]

   {#prepare-csv-file__table_spv_tbv_tw}
3. Save the file in a drive that you can access during the import with the .csv extension.

## What to do next

[Map multiple application services from a CSV file using classic Service Mapping](https://servicenow-prod.fluidtopics.net/0ElnFoss5kGCl7N1cGU5oA "This method suits you if your organization has performed cross-organization mapping and analysis and collected some information about planned service instances. If so, you can organize the collected information in a specific order and save it as a CSV file. Service Mapping extracts information from this file and creates potential service instances referred to as service candidates.")