In order to do bulk registration of employees and to generate monthly EPF challan, employers need to upload text files in PF portal. The unified PF portal accepts only text files, so employers need to convert PF excel file formats into text files before uploading them into PF portal.
The conversion of every PF excel file into text file includes Two steps, in the first step, we need to convert to Excel file into CSV format and later we will save CSV file in the text format.
How to Prepare Text File for EPF
Step1: Open Excel file which may be a new employee bulk registration file or ECR file etc… Now go to save as option in the file menu. Before doing save as delete all the headings from row 1. ( i.e the headings like UAN number, name, EPF wages etc…)
Step 2: Now a Save as window will open there select file type as CSV (MS-DOS)
Step 3: Now open the folder which consists saved CSV file and right click on it and open it with notepad.
Step 4: Now in notepad go to edit option and select replace all option. Now replace all Commas with #~# symbols.
# hash ~ Tilde
After Conversion:
Step 5: Now go to save as option in file menu and save the file as text file. Now upload the save text file in PF portal.
I am unable to upload txt file as the error message has come out. Please send me the excel format of wages and procedure to be maintained to create text file. Please send me very urgently as the time is too short to submit EPF contribution for Sep
Is it necessary to write the date of joining in text file
I am unable to upload txt file as the error message has come out. Please send me the excel format of wages and procedure to be maintained to create text file. Please send me very urgently as the time is too short to submit the same before 23/6/23
Thank you for your kind help.
Regards,
Subrata Chowdhury
Superb sir thanks a lot
SIR , mera uan no sahi hai , fir bhi mera text upload nahi ho raha ha … mai text attach kar rahi hun … plz mujhe batayen
100713599245#~#SADASHIB ROUT#~#150#~#150#~#150#~#150#~#18#~#12#~#6#~#0#~#0
100713635808#~#SURYAKANTA BEHERA#~#270#~#270#~#270#~#270#~#32#~#22#~#10#~#0#~#0
101294364282#~#BALARAM DAS#~#50#~#50#~#50#~#50#~#6#~#4#~#2#~#0#~#0
100713604229#~#ANAM DAS#~#270#~#270#~#270#~#270#~#32#~#22#~#10#~#0#~#0
101376196481#~#PRASANT SAMAL#~#390#~#390#~#390#~#390#~#47#~#32#~#15#~#0#~#0
101108132649#~#KALAKAR PATRA#~#390#~#390#~#390#~#390#~#47#~#32#~#15#~#0#~#0
101376196499#~#AJIT KUMAR SWAIN#~#285#~#285#~#285#~#285#~#34#~#24#~#10#~#0#~#0
101376191563#~#BIPLAWA DAS#~#240#~#240#~#240#~#240#~#29#~#20#~#9#~#0#~#0
101377213462#~#JYOTI PRAKASH PRADHAN#~#270#~#270#~#270#~#270#~#32#~#22#~#10#~#0#~#0