The .csv files can be opened or imported directly into Excel 2010 and higher .CSV files are ubiquitous and may be imported into pretty much any database. The .CSV files do contain the extra data from the "CMS National Downloadable File" and the "Physician Compare Address / Phone File".
What fields are in the "main" .csv file?
NPI, EntityType, EntityDescription, EnumerationDate, UpdateDate, OrganizationName, OtherOrganizationName, LegalBusinessName, FirstName, MiddleName, LastName, Suffix, CredentialText, Proper_Name, SoleOwner, SubPart, Gender, Office_Contact_Title, Office_Contact_NamePrefix, Office_Contact_FirstName, Office_Contact_MiddleName, Office_Contact_LastName, Office_Contact_NameSuffix, Office_Contact_Telephone, Office_Contact_Credential, GroupName, BUS_Address1, BUS_Address2, BUS_City, BUS_State, BUS_PostalCode, BUS_Voice, BUS_Fax, PRAC_Address1, PRAC_Address2, PRAC_City, PRAC_State,PRAC_PostalCode, PRAC_Voice, PRAC_Fax, PECOS_Registered, PECOS_PART_B, PECOS_HHA,PECOS_DME, PECOS_PMD, TAXONOMY, TAXONOMY_Group_Classification, TAXONOMY_Specialization, TAXONOMY_CODE, TAXO_IS_PRIMARY
What fields are in the additional practice locations .csv file?
NPI, EntityType, PROPER_NAME, PRAC_Address1, PRAC_Address2, PRAC_City, PRAC_State, PRAC_PostalCode, PRAC_Voice, PRAC_Fax