Google Sheets is an excellent choice for working with PXM exports because both platforms use the international web encoding standard, UTF-8. This ensures that special characters are preserved when transferring data between PXM and Google Sheets, and generally requires little additional effort.
While Google Sheets allows you to open a CSV file directly, it still makes assumptions about your data. Columns containing only numeric characters—for example, UPCs or certain SKUs—will be treated as integers, causing any leading zeros to be removed. This can be a problem when those leading zeros are important for your data integrity.
To prevent Google Sheets from automatically interpreting your data and potentially modifying it, you can follow these steps to properly import your CSV into a new or existing 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.
Insert new sheet(s)
Set the 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.