Housing Benefit Data Converter

Instructions:

  1. Copy all text from your Housing Benefit PDF
  2. Paste it into the "Input Text" area below
  3. Click "Convert to CSV"
  4. The parsed data will appear in the "Output CSV" area
  5. Click "Copy to Clipboard" to copy the CSV data
  6. Paste directly into your legacy table format
  7. Use "Clear All" to reset and process another set of data

Column order: Our Ref, Date, Your Ref, HB Reference, Name, Address, [Empty], [Empty], Date From, Date To, [Empty], [Empty], [Empty], Amount

Legacy Table Format: This version includes 2 empty columns between Address and Date From, and 3 empty columns between Date To and Amount, to match your existing table structure.

Input Text

Output CSV

Status: Ready