Solution Properties
Solution ID:
220924150010119
Last Modified Date:
Wed Jan 15 18:06:21 UTC 2025
Taxonomy Path:
Category//Data//Data management
Author:
sageadmin
Exporting and importing vendor data using CSV format using Microsoft Excel
Description
[BCB:470:SES Data migration/conversion:ECB]
Cause
Resolution

NOTE:

It's not possible to export data directly from Sage 50 Cloud to Excel. If you're exporting from Sage 50 Cloud, you must download the CSV file to the C drive first before opening it in Excel.

Export the Vendor List to a CSV file

  1. Go to File, then Import/Export.
  2. Select Export Records.
  3. When the Export Records Wizard appears, select Export to a Sage 50 import file format.
  4. Select Next.
  5. Select Vendors. Take note of the export file name and the location.
  6. Select all or some of your vendors to export.
  7. Select Next.
  8. Select Finish.

Modifying the CSV file (with Microsoft Excel)

  1. Open Microsoft Excel.
  2. Select File, then Open.
  3. Select the CSV file exported from the old Sage 50 Accounting file on the c: drive.
  4. The first line of the CSV file must contain a Version Number, Country Code, and the word Vendors.

Version

  • Sage 50 version 2020 Version Number = 27001
  • Sage 50 version 2021 Version Number = 28001
  • Sage 50 version 2022 Version Number = 29001
  • Sage 50 version 2023 Version Number = 30001
  • Sage 50 version 2024 Version Number = 31101
  • Sage 50 version 2025 Version Number = 32101
  • Sage 50 version 2026 Version Number = 33002

Country Code based on the status of your Sage 50 Accounting 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 add:  

  • 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

Follow the sample format below.   NOTE: The row # 2 is only for titles and it isn’t part of the import file.
Microsoft Excel CSV sample import file format.

Import into your new company

  1. Log in to the new company in single-user mode.
  2. Select File, Import/Export.
  3. Click Import Records.
  4. The Import Records Wizard appears. Select Sage 50 import format.
  5. Click Next.
  6. Click Back Up to create a backup for the company before importing.
  7. After the backup is successful, click Next.
  8. Click the Browse button beside the Vendors box.
  9. Select the CSV file that you want to import into Sage 50.
  10. Click Next.
  11. Sage 50 Accounting displays a log of all the added vendors.
  12. Click Finish.
[BCB:159:Chat 50 CA English:ECB]

 

 




Steps to duplicate
Related Solutions

How to import .CSV data