EPF Excel to Text converter
Turn your ECR Excel sheet into the text file the EPFO portal needs. ECR is the monthly list of each employee's wages and PF (Provident Fund) that you upload to EPFO, the PF office. Your file stays on your computer.
Filing every month yourself? We can do it for you.
- 25+ years in practice
- Founder worked 35 years at EPFO
- 100+ clients
- 3,500+ employees covered
How to make the text file by hand
You can also do this yourself in Excel and Notepad:
- Open your filled ECR Excel sheet. Delete the heading row and any empty rows.
- Save it as CSV: File → Save As → CSV (Comma delimited). Close Excel.
- Right-click the CSV file and open it with Notepad.
- Replace every comma with
#~#: Edit → Replace, type,and#~#, then Replace All. - Save it as a .txt file, with no spaces in the file name.
This goes wrong if a name or number has a comma in it, or if Excel shows a UAN (the employee's PF account number) as 1.00123E+11. The converter avoids both.
Note: The converter only changes the file format. It does not check your figures. Check the amounts before you upload the file to EPFO.
Common questions
ECR (Electronic Challan cum Return) is the monthly list of each employee's wages and PF, sent to the PF office. Challan means the PF payment slip. You upload the ECR on the EPFO employer portal. It lists each employee's UAN, wages and PF amounts for the month.
The EPFO portal takes the ECR as a text file, with the details split by #~#. This tool makes that file from your Excel sheet.
Yes. Your file is read in your own browser. It is not sent to us or saved anywhere.
.xls and .xlsx files. Use our ECR Excel format so the columns are in the right order.
Want to stop filing PF yourself? We'll file it every month.
We never miss a PF or ESI due date.