How to create a csv file to import the Employees in Payroll Admin software? Important points to be remembered while filling the details. Do not change the headings that have been provided by MarvelSoft. Date format to be maintained is dd/mm/yyyy. In case if the user is not able to set this date format, then check if the Computer system date format is also set to dd/mm/yyyy. Spellings for the data that should not be changed while filling the form are GENDER - Male and Female MARITAL STATUS – Married and UnMarried HADICAP – No In case if the details are filled in Excel file, the user can convert the excel sheet to csv format. This can be done as mentioned below. In the excel sheet filled with the employee details click on File → Save As → there choose the file format CSV (MOS-DOS) (*.csv) as shown below.
|
Open MS Excel and fill the required details of the employees.Some of the details that can be imported are as follows CONTRACTORNAME, EMPNAME, EMPID, CADRE, GENDER, RELIGION, FATHERNAME, HUSBUNDNAME, MARITALSTATUS, MOTHERTONGUE, DOB, DOJ, NATIVESTATE, PRESENTADDRESS, PERMANENTADDRESS, DESIGNATION, DEPARTMENT, HANDICAP, COMMUTINGMODE, ESINO, PFNO, UANPF, FIXEDSALARY, BASIC, DA, HRA, OTHERALLOWANCE1, OTHERALLOWANCE2, PAYMENTMODE, BANKNAME, BANKACCNO, ELBALANCE, PHONENO, SHIFT
Fill all the details of all the employees in the Excel file by using the above field names as the table headers.
Once all the details are fill save the Excel file with .csv extension in order to convert it to a csv file.
Now this file can be used to import the employe details easily as shown earlier. |