Using Excel Data to fill out an Adobe Fillable PDF

Hi there. I have an excel file of inventory that I'd like to put into an adobe PDF form. I've named all of the data categories exactly how they appear on the form and I've changed to file format to a text tab deliminated text file. When I try to import this data into the form I get the error message, "could not load data from the text file." Additionally, even when the data begins to work and it shows a list of all the data I get an error message saying "some data in the text file was not imported successfully" and the form remains blank. I really need assistance automating this process as I have hundreds of forms to complete. I'm not sure if this is a factor in my issue, but I am only filling out some of the forms on the data sheet and am leaving others blank. I have tried creating a txt file with all of the categories and put in information to see if that was the issue but I still got an error message.