How to export/import product master from 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:


Master Data

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


Product Master Excel File

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


Excel file

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:


Import this CSV file


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


Unisolve software





      • 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 Sales Invoice in CSV format in Cross

        How to Export Sales Invoice in CSV format in Cross 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 ...
      • 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 Create Lock MRP Master According to DPCO's New Issued Restricted MRP in Unisolve & Cross

        How to Create Lock MRP Master According to DPCO's New Issued Restricted MRP The DPCO (Drug Price Control Order) declared a new ceiling price for essential and life saving medicines (as per a prescribed formula). According to the government's new ...
      • 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, ...