Preparing Excel Data for Upload (Customer / Supplier / Item listings)[MIGRATED]

posted Dec 30, 2008, 8:56 PM by Unknown user   [ updated Jun 9, 2011, 12:12 AM by Unknown user ]
The following instructions should let you export a properly formatted CSV file for use with all our upload functions.

You will need a copy of OpenOffice.org installed. This is available at www.openoffice.org.

  1. Open the Excel file in 'OpenOffice Spreadsheet'. Start > All Programs > OpenOffice > Spreadsheet/Calc
  2. Click File > Save as
  3. Next choose the file type (the drop down in the lower right corner of the Save dialog) "Text CSV".
  4. Tick the 'Edit filter settings' checkbox (Make sure you do this!).
  5. Press save.
  6. A dialog will appear, 'Export to text files'. For field delimiter, put the | symbol. Leave text delimiter as empty (Look at the last image).
  7. Press OK.
The file will be saved. Now try uploading this file.