Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Exporting Reports as CSV changes the end of MMS ID to 0 if longer than 15 characters

    • Article Type: Q&A
    • Product: Alma
    • Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care


    I export a report from Alma Analytics to Excel in csv format. It contains system numbers (MMS IDs) with 16 digits. The IDs are automatically rounded, meaning the last digit becomes a 0. Why is that happening? I need my system numbers unchanged.


    This is not an Alma problem.
    Excel cannot handle numbers with more than 15 digits. (See Microsoft Knowledge Base,
    The solution is to import this column in Excel in "Text" format instead of "General" or "Number" format.

    Category: Analytics

    Subject: Reports