Google Sheets is a great companion to working with Amplifi exports as both platforms utilize the international web encoding standard of UTF-8. This means that your special characters will preserved when round tripping data between Amplifi and Google Sheets and there is very little extra you need to do.
Google Sheets has the ability to open a CSV file directly, but it will make assumptions about your data and you will find that columns with only number characters will be interpreted as integer data and will strip any leading 0s. This is a problem for things like UPC or some SKU formats as the leading 0s are really important part of the data.
If you would like to tell Google Sheets not to interpret your data you can easily follow these steps to import your CSV to an existing or new sheet:
Open Google Sheets
Go to File > Import
Select the CSV file you wish to import and click Select
Next choose if you want to create a completely new spreadsheet, replace the current sheet, or insert a new sheet into your spreadsheet. I usually choose Insert new sheet(s)
I let Google Sheet discover my Separator Type: Detect Automatically
Next turn off the box for Convert text to numbers, dates, and formulas (in image above)
That should do it! Looking for help with Excel, click here. For information on other CSV readers, click here.