.CSV Files

.CSV Purchase (Also includes all of the Database Products)

What are the advantages of using .csv files?

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".

.CSV Files Details - Each State Zip file contains the three files as explained below. 

1. The first file is the "main" .csv file. it is named State.csv (Example CA.csv for California).
     a. Sample CSV Main File (CSV).

2. The second file has additional practice locations and is named STATE_additional_prac_locs.csv.
     a. Sample CSV additional practice locations (CSV)

3. The third file is CSV_File_Resources.txt, it contains details about the .csv files. 
     a. CSV Resource File (TXT).

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, Source_File, PROPER_NAME, PRAC_Address1, PRAC_Address2, PRAC_City, PRAC_State, PRAC_PostalCode, PRAC_Voice, PRAC_Fax

"main" .csv file counts.


Some .csv files need to be imported into MS Excel instead of just double-clicking them to open. MS Excel does not handle zip codes that start with a "0", phone numbers that begin with "0", etc.

"Import data from a CSV, HTML, or text file" Microsoft.com Support link (Opens a new tab / window)