Finxora Logo
Sign In

EPFO TXT Converter

Convert your ECR Excel sheet into the '#~#'-delimited TXT format for EPFO portal uploads, entirely in your browser.

Files are processed locally on your device — nothing is uploaded to a server.
1. Upload your file
Select an Excel file (.xlsx) to begin.
2. Follow the steps
A simple, three-step process.
1

Prepare Your File

Ensure your data is in the standard EPFO format. You can use our sample files as a template.

2

Upload Excel File

Click the upload area or drag and drop your .xlsx file into the designated box.

3

Convert & Download

Click the "Convert" button. Your browser will immediately download the formatted .txt file, ready for your EPFO portal upload.

Conversion status
Validation results and the TXT preview appear here.

Nothing to show yet

Upload an .xlsx file on the left, then click “Convert”. Validated rows will download as a #~#-delimited .txt file, and any format errors or warnings will be listed here.

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