• Water Information
  • Water data
    • Design Rainfalls
    • Geofabric
  • Water status
    • Australian Water Resources Assessment
    • National Water Account
    • Water Storage
  • Water forecasts
    • Floods
    • Streamflow Forecasts
• Regulations
  • Find your organisation
  • Data delivery
    • Data Delivery Overview
    • How to Deliver Data
  • Water Data Transfer Format
    • What is XML?
    • WDTF Validation
    • WDTF Download
    • WDTF Visualisation Tool
    • Excel to WDTF Conversion Tool
    • WIRADA
  • Funding program
  • Data licensing
  • Incorporated documents
    • Commercially Sensitive Sites
    • Metadata and Contextual Information Requirements
    • Persons and Classes of Persons
  • Amendments
• Standards
  • Water Data Collection Standards
    • Water Information Metadata
    • Metadata Consultation Process
    • Water Data Transfer Standards
  • National Water Information Standards
  • Water Accounting Standards Board
    • Water accounting story
    • Standards development
    • Frequently asked questions
    • About Water Accounting Standards Board
    • Exposure Draft Australian Water Accounting Standard 1
    • Feedback responses
    • Assurance Engagements on General Purpose Water Accounting Reports
    • Resources and links
    • Contact us
  • Projects
    • Acoustic Doppler Current Profiler Standards
    • New South Wales Hydrometric Standards
    • Water Quality Metadata
    • Standards workshops
  • Business Forum
• News and events
  • Presentations
    • National Climate and Water Briefings
    • National Water Information Briefings 2011
    • Water Information Industry Seminars 2009
    • Water Information Industry Seminars 2007-08
    • Webinars
• About
  • Water information role
  • Water contacts
    • National Water Account contacts
    • Hydrometeorology contacts
    • Water regulation contacts
    • Water Accounting Standards Board contacts
  • Publications
  • Video
  • Consultation
  • Work in progress
  • Water research
    • Water Information Research and Development Alliance
    • Australian Research Council Linkage Projects

Excel-to-WDTF Conversion Process

Many data managers across the country use Microsoft's Excel and Access as their basic data storage mechanism. The HYXL2BOM software developed by the NSW Office of Water can be used to convert Excel and CSV files to WDTF.

Your comments regarding usage of this software are welcome. Please direct your comments via email to waterdata@bom.gov.au of Bureau of Meteorology, Australia, with "Excel-to-WDTF Conversion Process" in the subject line.

Download Installation Package

Download the installation package which contains:

• installation program hyxl2bom_install.exe, and
• user guide Excel_to_WDTF_UserGuide.pdf for guidance on installation and execution.

Related links

• FAQ
• Water Act 2007
• Definitions
• Regulation terms
• Water Information terms
• Categories of Person
• Categories of Water Information
• Sub-categories of Water Information

Water links

• Water Act 2007
• Water Regulations 2008
• Water Market Reports
• Water Dictionary
• Publications
• News
• Contact Us