---
title: "How to Import Data using Command Line of Salesforce Data Loader?"  
description: "How to Import Data using Command Line of Salesforce Data Loader?"  
author: "John d'souza"  
published: 2018-02-08  
canonical: https://answers.mindstick.com/qa/34228/how-to-import-data-using-command-line-of-salesforce-data-loader  
category: "salesforce"  
tags: ["salesforce", "dataloader", "command-line", "import data"]  
reading_time: 2 minutes  

---

# How to Import Data using Command Line of Salesforce Data Loader?

How to [Import](https://www.mindstick.com/blog/294/how-to-import-or-export-sql-server-table-data-in-ms-excel-sheet-using-c-sharp-code) [Data](https://yourviews.mindstick.com/view/84027/what-does-google-do-with-your-data) using [Command Line](https://www.mindstick.com/interview/477/how-can-i-execute-a-php-script-using-command-line) of [Salesforce](https://www.mindstick.com/articles/12736/exploring-the-usage-and-benefits-of-salesforce-for-businesses) Data [Loader](https://www.mindstick.com/forum/156609/create-loader-with-bootstrap)?

## Answers

### Answer by Tarun Gautam

Salesforce provides the facility to import data from [command](https://www.mindstick.com/interview/36/what-is-the-use-of-alter-table-command-in-database) line. This facility is available in both the versions Salesforce Classic and Lightning Experience, and the editions are Developer, Enterprise, Unlimited, Performance, and Database.com.

> Note, that, the Data Loader command-line interface is supported only for Windows.

## For importing the data there are some needs for User Permissions:

| To insert records | Add on the record |
| --- | --- |
| To update records | Edit on the record |
| To upsert records | Create or Edit on the record |
| To delete records | Delete on the record |
| To hard delete records | Delete on the record |

Now, you can execute the command in Data Loader from the command-line and insert some new accounts. To do it copy the following data into a file name accountInsert.csv. This is the account record that you are importing into your organization.

```
Name, Industry, NumberOfEmployeesDickenson plc, Consulting, 120GenePoint, Biotechnology, 265Express Logistics and Transport, Transportation, 12300Grand Hotels & Resorts Ltd, Hospitality, 5600
```

\
Use the following command into your command prompt:\

```
process.bat "<file path to process-conf.xml>" <process name>
```

- Replace <file path to process-conf.xml> with the path to the directory containing process-conf.xml.\
- Replace <process name> with the process specified in process-conf.xml.

\
Your command should look something like this:

```
process.bat "C:\DLTest\Command Line\Config" accountInsert
```

After execution, the command prompt window will display success and error messages, but you can also check the log files: insertAccounts_success.csv and insertAccounts_error.csv, and after the successful execution, the insertAccounts_success.csv file contains your imported records, with the ID and status of each record.


---

Original Source: https://answers.mindstick.com/qa/34228/how-to-import-data-using-command-line-of-salesforce-data-loader

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.
