Useful Excel to HDL DAT File Converter

Now I am going to provide a excel macro tool which will convert the excel data into HDL file using a macro at the click of a button.

This excel sheet consists of two sheets “Excel Input” and “Open – Save HDL DAT Files“.

In the “Excel Input” sheet we need to input the data in rows and columns and then go to next tab

The next tab “Open – Save HDL DAT Files” will look like

There are two buttons in this sheet:

Open HDL DAT File by Clicking Here: If you click on it, you can browse for a DAT file and when select any DAT file, it will get opened up in the “Excel Input” tab in excel format. And then you can modify the data in excel and come back to this sheet and click on “Save DAT File by Clicking Here” to save it as DAT file.

Save HDL DAT File by Clicking Here: If you click this, it will ask for a filename and you can browse for the folder and then save the data in the “Excel Input” worksheet as a .dat file.

With this, we can save it as DAT file.

Once you save the dat file, you can zip it and then upload the file to Import and Load Data Screen to load the data into the application.

This is a very useful tool when we work on data conversions and whenever there is a need to modify the existing HDL or generate the new HDL file.

Download Link – Excel to DAT File Converter

Steps to edit a HDL file using this tool:

1. Open the second tab “Open – Save HDL DAT Files” and import the HDL file using “Open HDL DAT File by Clicking Here” button and browsing for the file.
2. The dat file contents will be open on the “Excel Input” tab. Make the modifications as needed.
3. Then go to second tab “Open – Save HDL DAT Files” and click “Save HDL DAT File by Clicking Here” to save the HDL DAT file.

Note: For this Excel tool to work, Macros needs to be enabled on your Microsoft Excel. You will find a ribbon to enable the macros, once you open this sheet if at all Macros aren’t enabled already.

if you face issues with macros, check out this article on how to enable macros in MS Excel