Spreadsheet · Import Guide
Review NPI Provider Data Without Damaging Identifiers
Import the CSV through Excel's data importer so NPI and taxonomy values remain text.
Official Excel import documentationBefore You Start
- A reviewed release small enough for Excel
- The release manifest
- Microsoft Excel
Step-by-Step
- 1
Start from Data Import
Use Data > From Text/CSV instead of double-clicking the file.
- 2
Set identifiers to text
Mark NPI and taxonomy columns as text before loading.
- 3
Load the table
Confirm UTF-8 encoding and comma delimiters.
- 4
Check row limits
Do not use Excel for artifacts larger than its worksheet limit.
- 5
Record the release
Keep the source release ID and checksum with the workbook.
Field Mapping Reference
| Our CSV Column | Excel Field | Note |
|---|---|---|
| npi | npi | Keep as text to preserve all ten digits |
| provider_name | provider_name | — |
| primary_taxonomy | primary_taxonomy | — |
| practice_state | practice_state | — |
| source_updated_at | source_updated_at | Parse as a date |
Tips for Better Results
Never allow scientific notation for NPI.
Use Power Query for repeatable refreshes.
Keep the original CSV immutable.
Need the data contract first? Review the synthetic schema preview and published release methodology before importing a future delivered artifact.
Get the Agent ListFrequently Asked Questions
Should NPI be stored as a number?
No. Store NPI as a ten-character string so formatting and leading-zero behavior are explicit.
How do I verify the imported file?
Compare the file checksum and imported row count with the versioned release manifest before using the data.