Spreadsheets to customfixed-width, perfectly.
Drop in a Mass Meter Exchange CSV or XLSX spreadsheet and get a validated custom fixed-width character-formatted file, then convert it to a headerless TXT file ready to import into any utility billing software — every column padded to spec, every date normalized. Full customization from a simple spreadsheet to a custom fixed-width version.
Configurable fixed-width layout
Define any number of columns and any character widths — live ruler preview updates as you tune the spec for your billing system.
Headerless TXT export
One click produces the headerless fixed-width .txt file your utility billing import expects, plus a matching XLSX for your records.
Validation on every row
Flags truncated values, unparseable dates, and auto-corrects common typos like 5-digit year entries.
Handles 900+ rows smoothly
Chunked parsing with a live progress bar keeps the browser responsive on the biggest weekly or monthly batches.
Cloud history
Every conversion is saved to a private admin-only bucket so you can re-download originals and outputs anytime.
Preserves original data
No column reordering, no silent transformations — blank fields stay blank, values stay where they belong.
How it works
Three steps from a simple spreadsheet to a billing-ready fixed-width file.
- 01
Upload CSV or XLSX
Drop in a weekly or monthly Mass Meter Exchange spreadsheet — a single line or more, up to 900+ rows, with 1 to 39+ columns in any fixed-width format.
- 02
Review & validate
See the character ruler preview, tune any column width for your billing system, and catch data issues before export.
- 03
Download & save
Export the headerless fixed-width TXT and matching XLSX, and archive the run to cloud storage in one click.
Built for
Weekly or monthly meter exchange imports
Convert each batch (e.g. 7/09 – 7/13) into a single billing-ready fixed-width file without hand-formatting columns.
Field-crew data hand-offs
Take raw CSV or XLSX from field crews and produce billing-system input any utility software will accept on the first try.
Audit-friendly archives
Keep the source spreadsheet, the fixed-width XLSX, and the final TXT together in cloud history for every submission.
One admin, zero setup
Single sign-in for the RUOS admin account — no local scripts, no Microsoft Access exports to babysit.
Ready to convert your next batch?
Sign in to the admin workspace to upload, validate, and export.