I am looking for a solution and wondering if xchange can do this or if there is at least a way around.

So I have an excel workbook that contains multiple sheets with info
I can create a sheet that will auto copy the info I need to one place
But the next step is where I need help

I have to transfer all this info from the excel worksheets to a govt PRF form

What I have been doing is -
I created a front page that I inserted as page 1 in front of the official form. Then I use the editor in xchange v6 to insert a text field
Say "full name" text field here I type the name into this field and then I insert other text fields in the 37 places on the form where it asks for the full name of the person. Name all those text fields in property the same as the one on the first page and the names copy.

This is fine

but Is there a way that I can either import the info from Excel into that first page or save that page in excel as a pdf and have it save as a form that will still work the way I described above?

Hello phones and stuff,
I am afraid that importing the content of an excel document directly into the form fields would not be possible at the moment.
The main method to import information to form fields is through the use of FDF files, which excel cannot currently export its data to as far as I could find.

Hello phones and stuff.
I apologize for my earlier statement, I was testing using CSV as my file format, but did not think to close excel while testing. Thus I was unable to get it to work, and made a false remark.
Apparently excel cannot have the document in questions open in order for the Editor to read these files, but it certainly is possible using CSV (which excel can export to!).
Much like in the thread you've linked above, simply ensure that row 1 contains the names of the form fields, and row 2 contains the desired data. At the moment, we do not offer a selection interface to choose lines beyond row 2 for alternate data. then you need only navigate to the form tab, and click Import Form Data, and select the desired file.

Unfortunately CSV import for forms was a relatively new addition to the software, and I do not believe that any version 6 builds supported it. If you are wanting to perform these imports, I would suggest updating to the latest version of the software to take advantage of this function.