Skip to main content

An official website of the United States government

Here's how you know

Pages in this section

Software Specs and Limits

These comma delimited files provide consolidated information submitted by reporting entities for active years of Open Payments data. These files can be imported into a database or a spreadsheet for easier reading and interaction.

Some datasets, particularly the general payments datasets, are extremely large and may be difficult to download and/or cause computer performance issues. The Centers for Medicare and Medicaid Services (CMS) recommends using WinZip, WinRAR, or 7-Zip for file decompression.

This documentation will assist users in importing the data.

Notice:

Notice

Be aware of the file size and row limitations of the software you are attempting to import the files into. For information on limitations, look at the software's official documentation.

Documentation by Application

ApplicationNotesLinks
Microsoft ExcelOfficial size limitations for Microsoft ExcelExcel Specifications and Limits on microsoft.com
Microsoft AccessOfficial size limitations for Microsoft AccessAccess 2016 Specifications on microsoft.com
Oracle SQL DeveloperOracle SQL Developer toolOracle SQL Developer Overview on oracle.com
Oracle DatabaseOracle Database official size limitationsOracle Physical Database Limits on oracle.com
Oracle SQL Client ToolsOracle SQL Client ToolsOracle SQL Client on oracle.com

Help us improve Open Payments

Your feedback helps us make this tool more useful for you. Please take our one minute survey.

Take the Survey