Import Data to a Business Object

You can edit the data stored in a business object by importing a CSV file or an Excel spreadsheet (XLS or XLSX). When you import the file, you can choose to replace all the current data or add the data in the file as new rows to your existing data.

Use this import option to update the data in a particular business object. To simultaneously update the data for one or more business objects, you can import data from the Data Manager (see Work with the Data Manager).

To import data to a business object:

1. Open the Data tab of the business object that you want to edit.
   The table in the Data tab displays the data stored in the fields of the business object.
2. Click Import From File in the toolbar.
   The Import Data dialog provides options to either replace the existing data or to append the data in the file to the existing data.
   
   Description of the illustration bo-data-import.png
   

   When you append the data from a file, the IDs for the new data are renumbered to prevent duplicating IDs.

3. Upload the file by browsing your local file system or by dragging the file into the dialog box.
4. Select Append or Replace in the dialog box. Click Import.
5. Click OK.