---
schema_version: "1"
id: 055bdd4d8da739aeae4413f8d5756d1d6eb3923c3eb4442b7b5dd5cc1595894f
title: Notes on Importing Data
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/notes_on_importing_data.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.notes_on_importing_data.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: d93c8eb9693cc971a0d395f089a84fe08508d5c3e548d81a73f7f11948a26b5f
description: Review these notes when importing data into Salesforce.
products:
  - Salesforce Platform
  - Cross Cloud
release: "264"
---
# Notes on Importing Data

Review these notes when importing data into Salesforce.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Salesforce Classic and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Your edition determines the types of objects you can import.</td></tr></tbody></table>

## Field Accessibility

You can import values into a field only if you have read and edit access. User permissions, page layout assignments, and field-level security settings determine field access.

Field-level security is available in Professional, Enterprise, Unlimited, Performance, and Developer Editions.

## New Values for Picklists and Multi-Select Picklists

If you import a picklist value that doesn’t match an existing picklist value:

- For an unrestricted picklist, the Data Import Wizard uses the value that’s in the import file.
- For a restricted picklist, the Data Import Wizard uses the picklist’s default value.

## Multi-Select Picklists

To import multiple values into a multi-select picklist, separate the values by a semicolon in your import file.

You can import up to 100 values at a time in a multi-select picklist field. If you have more than 100 values in your import file for any one record, the import wizard leaves the field blank in that record.

## Checkboxes

To import data into a checkbox field, use 1 for checked values and 0 for unchecked values.

## Default Values

For picklist, multi-select picklist, and checkbox fields, if you do not map the field in the import wizard, the default value for the field, if any, is automatically inserted into the new or updated record.

## Date/Time Fields

Ensure that the format of any date/time fields you are importing matches how they display in Salesforce per your locale setting.

## Formula Fields

Formula fields cannot accept imported data because they are read only.

## Field Validation Rules

Salesforce runs validation rules on records before they are imported. Records that fail validation aren’t imported. Consider deactivating the appropriate validation rules before running an import if they affect the records you are importing.

## Geolocation Custom Fields

To import a geolocation custom field using the Data Import Wizard, supply two values: a latitude and a longitude. Import both values in one field, separated by a semicolon. If you enter only one value, it is imported as the latitude, and the longitude is interpreted as 0. If you supply more than two values, the import fails for the entire row.

## Currency Fields

If you have currency data in your CSV file, format your values for your locale. For example, if you’re in the U.S. locale, use periods for decimals and commas for thousand markers. Using the incorrect currency format could change your imported values.

#### See Also

- [Data Import Wizard](https://help.salesforce.com/s/articleView?id=xcloud.data_import_wizard.htm&release=264.0.0&type=5 "You can use the Data Import Wizard to import accounts, contacts, leads, solutions, campaign members, person accounts, and custom objects. You can import up to 50,000 records at a time.")
- [Choosing a Method for Importing Data](https://help.salesforce.com/s/articleView?id=xcloud.import_which_data_import_tool.htm&release=264.0.0&type=5 "Learn about your options for importing data into Salesforce.")
- [Salesforce Data Import](https://help.salesforce.com/s/articleView?id=xcloud.importing.htm&release=264.0.0&type=5 "Salesforce offers several ways to import your data. You can import up to 50,000 records into Salesforce.")