We have UTF8 encoding on in our app for foreign language characters. I have a report that I need to export to populate HubSpot that we are integrating into Quickbase. When I export the file to CSV, the encoding is lost.
I've looked at Excel help and saved the file as a CSV UTF8, but it doesn't correct the problem.
Has anyone found a solution for this issue?
Are you sure that it isn't encoded correctly? Excel's auto-import function (when you click to import a text file) doesn't handle UTF-8 properly in my environment. Try opening the exported csv file in a text editor like Notepad to see if the accents are correct. In my case it does. If you want to open it in Excel, you need to go through the full data import function, choosing UTF-8 as the file origin encoding, otherwise it assumes 1252 (Windows) and it displays errors like in your screenshot - at least in my environment.
