EPFO TXT Converter
Convert your ECR Excel sheet into the '#~#'-delimited TXT format for EPFO portal uploads, entirely in your browser.
How it works
Each Excel row must hold 11 fields — UAN, member name, gross / EPF / EPS / EDLI wages, EPF and EPS contributions, the EPF–EPS difference, NCP days and refund of advances. Valid rows are joined with the #~# delimiter the EPFO portal expects; a header row is detected automatically and conversion stops at the first blank row.
- UAN must be 12 digits; wage and contribution fields must be whole rupees.
- Rows failing validation block the download and are listed for correction.
- Contribution mismatches (12% EPF, 8.33% EPS) and wage ceilings surface as warnings, not errors.
Worked example
A row with UAN 123456789012, member RAMESH KUMAR, gross wages ₹20,000, EPF/EPS/EDLI wages ₹15,000, EPF contribution ₹1,800 (12% of ₹15,000), EPS contribution ₹1,250 (8.33% of ₹15,000), difference ₹550, NCP 0 and refund 0 converts to one line:
123456789012#~#RAMESH KUMAR#~#20000#~#15000#~#15000#~#15000#~#1800#~#1250#~#550#~#0#~#0
Who should use it
- HR and payroll teams preparing monthly ECR filings.
- Accountants handling EPF compliance and bulk member registrations.
- Small business owners managing their own payroll uploads.
From estimates to financial reports
A standalone converter answers a specific filing question. For business reporting, reconcile the converted data with your payroll and liability records. A broader working-paper package may also connect to a balance sheet, CMA report or project report.
Frequently Asked Questions
Is this converter free to use?
Yes — the converter runs entirely in your browser at no charge.
What Excel formats are supported?
We support .xlsx (Excel 2007 and later) files. If your file is in the older .xls format, save it as .xlsx (Excel Workbook) and upload again.
Is my data secure?
Yes, all conversions are processed locally in your browser. Your files are not uploaded to any server.
What if my file fails to convert?
Ensure your file follows the EPFO format. Download our sample files to verify the correct structure.
Last updated 14 Oct 2026 · Prepared by the Finxora team
Related calculators
Need bank-ready paperwork? Try our CMA report software and project report software for bank loans, or see balance sheet pricing. Read more on the product pages: CMA report software page, project report software page and balance sheet software page.