Mapping from CSV file into PayPal MultiOrder Shipping

[Mr_Fantastic]

I am having a challenge when I use PayPal MultiOrder from a file:

I have a my CSV file of orders> Open PayPal MultiOrder Shipping> Import from File> Import CSV file> I Map fields. It the goes to showing errors like this:

"The MultiOrder Shipping tool was unable to import the file you attempted to upload due to invalid or unreadable required data in row=35 column=5. Please check your file and try again."

I look at the file through Excel. This is a address cell. I don't understand. Is the program checking for valid address and not stating to me as such?

I remove the order entry (I thought I would just single order entry it. I get another row/ column error. And another. And another.... 

I have yet to be able to successfully utilize the Import File feature in PayPal MultiOrder Shipping.

Also, I have successfully used the same file in order to import into another shipping program with no issues. 

Any help in guiding me to a successful import would be most appreciative.

[ORS]

I was able to solve this using a compbination of:

- Removing any unused columns from the spreadsheet (that arn't being mapped)

- Filling blank cells (ie most of 'Address Line 2' fields with some text (like NA))

[ORS]

I just got the error again on a larger sheet. I removed all . at the end of St. Rd. etc. This didn't work. I exported as a TSV instead of CSV and it worked ...