Exporting and importing vendor data using CSV format using Microsoft Excel

Exporting and importing vendor data using CSV format using Microsoft Excel

Support Team Asked on January 6, 2018 in Sage.
Add Comment
  • 1 Answer(s)

    There are three main steps in the process of transferring your vendors list to a new Sage 50-Canadian Edition file:

    Step I: Exporting the Vendors List to a CSV file:

    1. From the main menu of Sage 50 Accounting: click on ReportsListsVendors.
    2. The Vendor List Options box will come on.
    3. Press Select All
    4. Click OK
    5. It will then generate the Vendor List Report.
    6. Go to the File menu on the report,
    7. Click Export
    8. The Export Selection box will pop up.
    9. Make sure you save it in the C: drive and the Save as type box should be Comma Separated (*.CSV).
    10. Click on Save.

    Step II: Modifying the CSV file (with Microsoft Excel):

    1. Open  Microsoft Excel.
    2. Select File, then Open
    3. Select the C: drive to select the CSV file that was exported from the old Sage 50 Accounting file
    4. The first line of the CSV file has to contain a Version Number, Country Code, and the word ‘Vendors’:
    • Version:
      • Simply Accounting version 2005 Version Number = 12001
      • Simply Accounting version 2006 Version Number = 13001
      • Simply Accounting version 2007 Version Number = 14001
      • Simply Accounting version 2008 Version Number = 15001
      • Simply Accounting version 2009 Version Number = 16001
      • Simply Accounting version 2010 Version Number = 17001
      • Simply Accounting version 2011 Version Number = 18001
      • Simply Accounting version 2012 Version Number = 19001
      • Sage 50 version 2013 Version Number = 20101
      • Sage 50 version 2014 Version Number = 21001
      • Sage 50 version 2015 Version Number = 22001
      • Sage 50 Accounting version 2016 Version Number = 23001
    • Country Code based on the status of your version of Sage 50 data file:
      • Canada Country Code = 1
      • USA Country Code = 2
      • French Country Code = 3
      • Australia Country Code = 5
      • International Country Code = 7
    • For each vendor you should have:
      • the vendor’s name in column A,
      • the contact name in column B,
      • the street address in column C,
      • a second street address in column D,
      • the city in column E,
      • the province in column F,
      • the country in column G,
      • the zip code in column H,
      • the phone number in column I,
      • a second phone number in column J,
      • the fax number in column K,
      • the e-mail address in column L, and
      • the web site address in column M
    • Importing:
      1. In Sage 50 Accounting, click the File menu.
      2. Click on Import/Export.
      3. Click on Import Records.
      4. The Import Records Wizard appears.
      5. Select Sage 50 import format.
      6. Click Next.
      7. Click Back Up to create a backup for the company before importing.
      8. After the backup is successful, click Next.
      9. Click on the Browse button besides the Vendors box.
      10. Select the CSV file that you want to import into Sage 50 Accounting.
      11. Click on Next.
      12. Sage 50 Accounting will show a log of all the vendors that were added, and the reason why some vendors were not added (if there were any).
      13. Click on Finish.

    Source: Sage Community forums.

    Disclaimer: Sage Accounting Solution is an independent provider of Sage Related services and is not affiliated with Sage.

    See More: Support for this issue is available either by self-service or paid support options. Experts are available to resolve your Sage issue to ensure minimal downtime and continue running your business. First try to resolve the issue yourself by looking for a resolution described below. If you are experiencing too many issues, you may want to more info Call Sage Technical Support Phone Number

    Support Team Answered on January 6, 2018.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.