Important Notice - Opening CSV Files Downloaded from the Manufacturer Payment Portal (MPP) in Microsoft Excel

Published 04/30/2025

The Manufacturer Payment Portal (MPP) reports are now available in comma-separated values (CSV) format.  To open the CSV file in Excel, please follow the directions on the Microsoft website [support.microsoft.com] to enable the Legacy Text Import Wizard. To ensure proper formatting of the Manufacturer/Contract Data report CSV file, use the Excel Legacy Text Import Wizard once enabled.

When using the Excel’s Legacy Text Import Wizard, please select the following options:

  1. Step 1 of 3:
    1. Select Delimited data type.
    2. Check ‘My data has headers’.
  2. Step 2 of 3:
    1. Check ‘Comma’ in the ‘Delimiters’ section (Do not have to uncheck Tab).
  3. Step 3 of 3:
    1. Customize the data format for the columns based on your preference.
    2. For fields where a longer string of numbers exists, such as “DETAIL REF NUMBER”, select ‘Text’ under ‘Column data format’ to prevent Excel from displaying inappropriate values or scientific notation.
    3. Important Note: Opening the CSV files without following Step 3 below could lead to the file not displaying properly.

 For additional assistance, please contact the TPA by phone at 1-877-534-2772, option 1 or by email at tpaoperations@tpadministrator.com.