MacGyver

Was wondering if anyone could shed some light here.

I have several spreadsheets of data (csv files) that I have been modifying, then trying to incorporate into my WP blog using the plugin wpallimport. My troubleshooting leads me to believe that some issue is occurring once I save the newly modified csv.

When I upload the csv to be parsed through the plugin, the columns/nodes containing foreign language characters display as either "???????" or they cannot be read and are seemingly omitted.

Notes:
The native csv files are encoded in UTF-8 and once I've modified them, I verify that they are still encoded that way. Even so, I still have an issue with the plugin. But here's what's interesting: if I upload the native csv file (unmodified/untouched), the plugin displays all information perfectly. Unfortunately, this won't do because I need to modify them first.

I have been using OpenOffice Calc, Microsoft Office 2010 Excel, GoogleDocs, Notepad and Notepad++ searching for a way to correct this through saving in different encoding, trying different file extensions. The wpallimport customer service never returned my email.

I'd appreciate any help and can explain further.

Thanks for your time!