Excel to UCRF Text Converter

Commercial UCRF v3.10 (pipe delimited). Upload your Excel and get the text file, with every error shown per account. Your file is converted inside this browser only. Nothing is uploaded. More data tools

1. File header details

2. Upload your Excel

Drop the .xlsx file here or click to chooseNo file selected

Convert Excel to a UCRF text file and check it before you submit

This converter reads a workbook with the HD, BS, AS, RS, CR, GS, SS, CD and TS sheets and writes the Commercial UCRF v3.10 file. It links every row by A/c No., builds the header and trailer from the real counts, and checks each field against the guide before you download.

Features

  • Per-account errors: click an account to see the sheet, row, field and the exact reason.
  • Test a fix: type a corrected value, press Validate and see if the error is gone.
  • Match with your Excel: compare the output with your sorting sheet or any text file, field by field.
  • Bureau names: a Member ID is remembered for each bureau you type.
  • Private: the file never leaves your browser.

Frequently asked questions

Which format does this create?

A Commercial UCRF v3.10 text file: pipe delimited, dates as DDMMYYYY, one segment per line (HD, BS, AS, RS, CR, GS, SS, CD, TS) with CRLF line endings.

Is my Excel file uploaded anywhere?

No. The file is read and converted inside your browser. Nothing is sent to a server.

Which Excel layout can I use?

A workbook with the sheets HD, BS, AS, RS, CR, GS, SS, CD and TS, where column A is the A/c No. and column C onward hold the fields. Formula and sorting sheets are ignored.

What does the validation check?

Required fields, lengths, dates, whole-number amounts, code lists, State and PIN match, legal constitution against relationship, ID formats such as PAN, and the segment order. Each problem shows the account, sheet, row and field.

Can I fix an error without editing the Excel?

You can test a corrected value in the account panel and press Validate. This changes the generated text in your browser only. Fix the same cell in Excel to make it permanent.

Is this the bureau's own validator?

No. It follows the UCRF guide but the bureau can apply further checks. Send a test file to the bureau UAT before the real submission.