.CSV Files

.CSV Files

What are the advantages of using .csv files?

The .csv files may be opened or imported directly into Excel 2007 and higher. .CSV files are ubiquitous and may be imported into pretty much any database.

.CSV Files Details - Each State or Taxonomy Type 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

Approximate "main" .csv file counts.

File Name / State	Count
(AA.zip) - APO / FPO Military (AA)	430
(AE.zip) - APO / FPO Military (AE)	3,193
(AK.zip) - Alaska	30,323
(AL.zip) - Alabama	83,295
(AP.zip) - APO / FPO Military (AP)	2,281
(AR.zip) - Arkansas	79,569
(AS.zip) - American Samoa PO BOX Only	176
(AZ.zip) - Arizona	148,121
(CA.zip) - California	947,663
(CO.zip) - Colorado	161,352
(CT.zip) - Connecticut	92,849
(DC.zip) - District Of Columbia	44,286
(DE.zip) - Delaware	25,321
(FL.zip) - Florida	537,621
(FM.zip) - Federated States Of Micronesia	18
(GA.zip) - Georgia	205,931
(GU.zip) - Guam	1,062
(HI.zip) - Hawaii	34,144
(IA.zip) - Iowa	55,980
(ID.zip) - Idaho	39,123
(IL.zip) - Illinois	298,376
(IN.zip) - Indiana	130,128
(KS.zip) - Kansas	63,844
(KY.zip) - Kentucky	102,648
(LA.zip) - Louisiana	111,709
(MA.zip) - Massachusetts	230,444
(MD.zip) - Maryland	176,341
(ME.zip) - Maine	40,218
(MH.zip) - Marshall Islands	8
(MI.zip) - Michigan	283,518
(MN.zip) - Minnesota	137,179
(MO.zip) - Missouri	131,530
(MP.zip) - Northern Mariana Islands	284
(MS.zip) - Mississippi	51,579
(MT.zip) - Montana	25,660
(NC.zip) - North Carolina	235,755
(ND.zip) - North Dakota	22,041
(NE.zip) - Nebraska	46,784
(NH.zip) - New Hampshire	37,335
(NJ.zip) - New Jersey	210,915
(NM.zip) - New Mexico	58,304
(NV.zip) - Nevada	92,532
(NY.zip) - New York	580,560
(OH.zip) - Ohio	333,060
(OK.zip) - Oklahoma	97,945
(OR.zip) - Oregon	129,805
(PA.zip) - Pennsylvania	311,847
(PR.zip) - Puerto Rico	49,218
(PW.zip) - Palau	55
(RI.zip) - Rhode Island	38,750
(SC.zip) - South Carolina	98,530
(SD.zip) - South Dakota	21,665
(TN.zip) - Tennessee	155,519
(TX.zip) - Texas	515,526
(UT.zip) - Utah	78,404
(VA.zip) - Virginia	171,912
(VI.zip) - Virgin Islands	1,086
(VT.zip) - Vermont	16,264
(WA.zip) - Washington	207,666
(WI.zip) - Wisconsin	126,676
(WV.zip) - West Virginia	64,435
(WY.zip) - Wyoming	16,040

Note:

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)