How to Export/Import Product Master through Excel/CSV

How to Export/Import Product Master through Excel/CSV


How to Export/Import Product Master through Excel/CSV

In this article, we have explained you How to export your product file in Excel & how to Import Product 

data file (which is in CSV format) in our software.


This option is very useful to export existing product in excel file. Files is the excel format can be imported to and exported from programs that store data in tables, with the help of this option. After this option you can enter you new Product List with help of Import option & save your time. If you not used this option then you will add your Product List on manually basis. 

For this please open System-> Master Data-> Product Information-> Product menu & right click on the same and select export to excel option. Image as per below:


After that click the path where save your Product Master Excel File. Image as per following:


After that you’re all Product Data shows in Excel file. Image as per below:


If you wants to add your new products into software master file, then open the excel file having name of products & manually enter or copy paste your Product List in this Excel Sheet as per columns. After that you can save this excel file as CSV Format and Import this CSV file through System-> Master Data-> Product Information-> Product menu. Image as per below:



This option is very useful & save your time also.


If you require support please read:  How to get online support (Guide & Video)


Thanks



SWIL Team





    • Related Articles

    • How to Import Purchase through CSV file in Unisolve / Cross

      How to Import Purchase through CSV file   CSV is a simple file format used to store tabular data, such as a spreadsheet or database. Files in the CSV format can be imported to and exported from programs that store data in tables, such as Microsoft ...
    • How to Export & Import Sales Invoice in CSV format in Unisolve

      How to Export & Import Sales Invoice in CSV format in Unisolve CSV is a simple file format used to store tabular data, such as a spreadsheet or database. Files in the CSV format can be imported to and exported from programs that store data in tables, ...
    • How to Import Credit-Debit Note (CSV)

      How to Import Returns (Credit/Debit Note) through CSV file   CSV is a simple file format used to store tabular data, such as a spreadsheet or database. Files in the CSV format can be imported to and exported from programs that store data in tables, ...
    • How to Import Sales Order Through CSV file

      How to Import Sales Order through CSV file CSV is a simple file format used to store tabular data, such as a spreadsheet or database. Files in the CSV format can be imported to and exported from programs that store data in tables, such as Microsoft ...
    • How to update HSN in Product Master

      How to update HSN in Product Master  The 1st Proviso to Rule 46 of CGST Rules 2017 has been amended, vide Notification No.79/2020-CT dated 15-10-2020, for declaration of HSN code in invoice. Under this amended Proviso, Notification No. 78/2020 – ...