Skip to main content
. 2020 Sep 9;14(1):214–229. doi: 10.1007/s40617-020-00451-w

Table 9.

Task analysis used to generate the behavior analysis NPI database from the NPPES downloadable file (Centers for Medicare & Medicaid Services, 2019b)

1. Direct the browser to http://download.cms.gov/nppes/NPI_Files.html.

2. Open the downloaded zip file.

3. Upload the NPI data comma separated value (CSV) file (npidata_pfile_20050523-20190407.csv)a into the online program CSV Explorer (https://www.csvexplorer.com).b

4. Within the CSV Explorer program, filter the data set so it includes only entries with one or more of the following taxonomy codes: 103K00000X, 106E00000X, or 106S00000X.

5. Download the filtered data set from CSV Explorer and open it in Microsoft Excel.

aThe exact data file name will vary depending on the date it is retrieved

bCSV Explorer is an online paid subscription program designed to allow users to interact with large data sets. As of April 1, 2019, the NPPES downloadable file consisted of almost 6 million rows of NPI data. This data set was uploaded to CSV Explorer and filtered so only rows that included the three taxonomy codes relevant to ABA were included