--- title: "SFDC: Load Data using the custom object import wizard" description: "Hi Everyone, here we see how to load data using the custom object import wizard in salesforce" author: "Anonymous User" published: 2015-03-10 updated: 2019-09-07 canonical: https://www.mindstick.com/articles/1638/sfdc-load-data-using-the-custom-object-import-wizard category: "sales force" tags: ["cloud computing", "cloud", "sfdc", "dev-401"] reading_time: 3 minutes --- # SFDC: Load Data using the custom object import wizard Most [organizations](https://yourviews.mindstick.com/view/84018/why-should-b2b-organizations-use-content-marketing) keep important data in all sorts of places, including documents and spreadsheets. In this post, we learn how to load data that currently lives in a personal [spreadsheet](https://answers.mindstick.com/qa/31730/explain-spreadsheet-and-its-basics) into the Warehouse app, where everyone in our [organization](https://answers.mindstick.com/qa/95707/who-is-the-current-secretary-general-of-the-united-nations-organization-u-n-o) can view and manage the data.\ There are several ways to load data, and this post shows only one method, using **a Custom Object Import Wizard**. This wizard uses a CSV file as its source. A CSV file is a plain [text file](https://www.mindstick.com/forum/2174/how-do-i-locate-a-particular-word-in-a-text-file) with each field separated by commas—thus the name “comma-separated values.” ## Create a data file The first step is to make a simple data file that you can use for this tutorial. 1. To save you time, download the necessary CSV-[formatted text](https://answers.mindstick.com/qa/95106/what-is-the-best-way-to-convert-a-pdf-to-nicely-formatted-text) file, from this URL: [https://raw.github.com/joshbirk/workshop2013/master/files/Merchandise.csv](https://raw.github.com/joshbirk/workshop2013/master/files/Merchandise.csv) 2. Right-click and save the file locally. The field names are on the first line. These names match the labels for fields in the Merchandise object. Text fields are delimited by quotes, allowing you to include spaces and special [characters](https://answers.mindstick.com/qa/42112/who-is-the-originator-of-avengers-characters) inside a [text field](https://www.mindstick.com/forum/33753/how-to-get-value-from-text-field-on-button-click-in-ios). Fields that have a number data type don’t require quotes. ## Load the Data Loading data from a CSV file into a custom object is simple using the Custom Object Import Wizard. From **Setup**, in the Quick Find field, type import and then click Import [Custom Objects](https://www.mindstick.com/forum/23332/sort-arraylist-of-custom-objects-by-property). ![SFDC: Load Data using the custom object import wizard](https://www.mindstick.com/mindstickarticle/80576dc1-87b6-4837-920f-3aa0efff2c81/images/fc23a1e4-4093-4536-8956-13f292653549.png) 1. At the bottom of the page, click Start the **Import Wizard!** 2. When the wizard starts, select Merchandise, then click Next. 3. Select No, and then click Next. 4. Select None, and then click Next. 5. Click Choose File or Browse... and select the data file you created earlier, then click Next. 6. Notice on the Field Mapping step you can match headings in your CSV file to field names in Salesforce. That was already done in the CSV file, so you can click Next. ![SFDC: Load Data using the custom object import wizard](https://www.mindstick.com/mindstickarticle/80576dc1-87b6-4837-920f-3aa0efff2c81/images/a0cb00ee-f5a3-49b7-a1e8-d372419bc960.png) 7. Click Import **Now! And then Finish.** **Note:** Once you finish the wizard, the platform queues the data load. For large sets of data, it may take a while for the data load to happen, and you’ll be notified by email when the data load completes. If you want to monitor this process more closely, in Setup, click Imports. ## Check the imported data: Once the data load is completed, go back to your app and confirm that the new Merchandise records are in place. 1. Click the **Merchandise tab.** 2. Next to the View drop-down list, make sure All is selected and click Go! ![SFDC: Load Data using the custom object import wizard](https://www.mindstick.com/mindstickarticle/80576dc1-87b6-4837-920f-3aa0efff2c81/images/3127c84e-93bd-474c-b93b-921273a7b9f0.png) ***This document is referred from* [*salesforce help tutorials*](http://www.salesforce.com/us/developer/docs/workbook/index.htm) --- Original Source: https://www.mindstick.com/articles/1638/sfdc-load-data-using-the-custom-object-import-wizard Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.