How to Create Text File for EPF

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…)

Convert EPF Excel File Format into CSV & Text Formats

Step 2: Now a Save as window will open there select file type as CSV (MS-DOS)

Convert EPF Excel File Format into CSV & Text Formats

Step 3: Now open the folder which consists saved CSV file and right click on it and open it with notepad.

Convert EPF Excel File Format into CSV & Text Formats

Step 4: Now in notepad go to edit option and select replace all option. Now replace all Commas with #~# symbols.

# hash  ~ Tilde

conversion excel to text file for epf

After Conversion:

conversion excel to text file for epf

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.

conversion excel to text file for epf

5 thoughts on “How to Create Text File for EPF”

  1. 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

    Reply
  2. 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

    Reply
  3. 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

    Reply

Leave a Comment