When I export an Analytics report in .CSV format to Excel the last few digits of the MMSIDs are changed to zeros. How can I keep this from happening?

Answer

When you export an Analytics report in .CSV format that contains MMSIDs longer than 15 digits, Excel can’t handle importing numbers that long unless they are in Excel format. This causes the digits after the 15thdigit to become zeros. For example, 990000131680204836 becomes 990000131680204000.

The solution is to import the MMSID column to Excel in "Text" format instead of "General" format.

Here is how you do it:

  • After you run the analysis in Analytics and select Export to CSV Format, instead of choosing “Open with”, select “Save File” to save the file to your desktop. Do not try to open it by clicking on the filename. 
    Save File
  • Next open Excel and then click "File Open" and select the file. 
  • Then in the "Text Import Wizard" Step 1 select “Delimited”. 
    Delimited
  • In Step 2 for Delimiters select “Comma”.
    Comma
  • Then in Step 3 highlight the MMS Id column and select “Text” for the “Column data format”.
  • For any other columns that contain a number longer than 15 digits also select “Text”.
  • For columns that actually contain numbers that you may wish to do calculations on make sure they are set to “General”.
    Text
  • Then click “Finish”.

Topics

  • Last Updated Dec 27, 2024
  • Views 131
  • Answered By Michelle Eichelberger

FAQ Actions

Was this helpful? 0 0