The steps below outline an easy way to transfer an existing list of inventory items to Incremental using Microsoft Excel®.

1. Exit Incremental Server if running.
2. Go to the folder where Incremental Server stores your inventory, invoices, and messages.
3. Locate the text file named inventory or inventory.txt and open the file using Microsoft Excel®.
4. Add inventory items as shown below.
   

   Columns A (Item Number), B (Description), D (Unit Price), E (Inventory Quantity), and L (Standard Unit Cost) must be completed for each inventory item. Completion of other inventory information is optional. Use the table below as a guide.

   Excel® Column	Content	Maximum Length
   A	Item Number (Uppercase)	63 Characters
   B	Description (Uppercase)	63 Characters
   C	Remark (Uppercase)	63 Characters
   D	Unit Price	31 Characters
   E	Inventory Quantity	31 Characters
   F	Minimum Quantity	31 Characters
   G	Sold/Allocated Quantity (Calculated by Incremental)	31 Characters
   H	Not used - must be blank	N/A
   I	Unaccounted Quantity (Calculated by Incremental)	31 Characters
   J	Category	63 Characters
   K	Location	63 Characters
   L	Standard Unit Cost	31 Characters
   M	Gross Profit (Calculated by Incremental)	31 Characters
   N	Profit Margin (Calculated by Incremental)	31 Characters
   O	Note	63 Characters
   P	Last Audit Date	63 Characters

5. Save inventory.txt (tab-delimited text format)
6. Exit Microsoft Excel®. Incremental Server can not open an inventory file while it is open in Microsoft Excel®.
7. Load Incremental to view your inventory.