Importing a Microsoft Excel File 
You can import data for business partners and items from a Microsoft Excel file to a company in SAP Business One. The data is copied from the cells of the Microsoft Excel table and written to the corresponding fields in SAP Business One.
Note
This method is not valid for importing accounts.
Use this method to add new master records for business partners or items, or to update existing master records.
You must first configure the definitions for the import, according to the following rules:
Files must not contain a title row or any blank rows.
Business partner and item numbers must not contain any of the following invalid characters:
! < > * ? % { } =
Microsoft Excel files must be closed before the import.
Microsoft Excel files must be saved as .txt files (text files with Text Only).
Import data must be saved in columns A to BT in the Microsoft Excel table. Some columns can have empty fields.
The number of characters in the cells of the Microsoft Excel table must not be greater than the length of the corresponding fields in SAP Business One.
Prerequisites
You have backed up the database.
If SAP Business One is running on a network, you have ensured that other users will be logged off the system during the import.
Procedure
Log on to the company into which the data is to be imported (target).
Choose
Administration 
Data Import/Export Import Data Import from Excel 
.From Data Type to Import, choose the required entry, either Business Partners or Items. For example, to import a price list, choose Items.
Each row in the price list represents a column in the Microsoft Excel spreadsheet being imported. Choose the corresponding field for each row from the list, in accordance with the column definition from the Microsoft Excel spreadsheet.
To update existing data records in the system during the import procedure, select Update Existing Records.
The system overwrites the data in the corresponding fields of the existing master records.
The numbers of the master records for business partners or items cannot be overwritten.
The type of a business partner cannot be changed once business transactions have been entered for that partner.
When importing item data, you can also update the information for the expense and revenue accounts.
To overwrite the respective item master data record, select Update Accts in Existing Items.
Choose OK.
When the file manager opens, select the file to be imported and choose Open.
The status bar displays the progress of the import.
To interrupt the import process, if necessary, choose the Stop button that appears in the status bar.
Result
Once the import process is complete, the system opens a Message window that contains the messages generated during the import process. The window displays the number of imported business partner/item master records. To make sure that all the rows have been imported from the Microsoft Excel table, compare the number of master records reported in the message with the number of rows in the Excel table.
We recommend that you save this import report, to enable tracking any errors that may have occurred. Choose Save in the Message window and enter a meaningful name for the file.
The next time you import data in this window, the fields you selected during the last run are displayed by default. Choose Clear to delete this information. All the entries in the list are deleted and you can redefine the sequence of the fields.
The following error messages may appear after an import:
Error 47
The Microsoft Excel file was open when the import was attempted. Close the Excel file and restart the import.
Invalid Entry
The entry in the cell of the Microsoft Excel table is longer than the corresponding field in SAP Business One.
Invalid Code
The number of the business partner or item contains an invalid character.