---
title: .CSV file schema reference
description: "Required and optional columns for the events, event properties, and user properties .CSV files used by Amplitude Data import and export."
product: data
lang: en
last_updated: 2026-11-20
token_estimate: 3001
---
# .CSV file schema reference

This reference defines every column in the .CSV files Amplitude Data uses for bulk tracking-plan import and export. For the import and export procedures, refer to [.CSV import and export](https://amplitude.com/docs/data/csv-import-export).

> For AI agents: a documentation index is available at [/docs/llms.txt](/docs/llms.txt). Append `.md` to any page URL for markdown, or send `Accept: text/markdown`.

Amplitude uses two separate files with separate schemas: one for events and event properties, one for user properties. Pick the section that matches the file you're building.

## Events and event properties file schema

The events and event properties .CSV file requires a specific schema for a successful import. The table below highlights the required schema by entity type. Note that:

- The file's header must contain all listed fields.
- The fields can be in any order, but their names and values must match exactly in spelling and capitalization for a successful import.
- Some fields require a value depending on entity type, as indicated in the following list.

### Action

- Definition: Action to perform on a particular entity.
- Values:

  - `Ignore`: No changes made to the entity or its subproperties.
  - `Remove`: You can remove event and property groups from the tracking plan. The remove value doesn't affect individual properties. Removing an event or property group disassociates related properties, and changes a live property's status to unexpected. The remove value doesn't delete an entity or stop ingestion.
  - `<blank>`: Creates or updates an entity and its associated sub-entities.
- For events, event properties, property groups, and property group properties.

### Array min items

- Definition: Minimum number of items for a property with an array property value type
- For event properties and property group properties

### Array max items

- Definition: Maximum number of items for a property with an array property value type
- For event properties and property group properties

### Array unique items

- Definition: Denotes if an array property value type has unique items
- Values:

  - `TRUE`: Array has unique items
  - `<any>`: Assumes array doesn't have unique items
- For event properties and property group properties

### Const value

- Definition: Const value for properties with a const property value type
- For event properties and property group properties

### Enum values

- Definition: Enum values for properties with an enum property value type
- Format: Separate each enum value with a comma
- For event properties and property group properties

### Event activity

- Definition: Description of an event's activity.
- Values:

  - `Active`.
  - `Inactive`. Marking an event as inactive applies retroactively and immediately, and excludes the event from the `Any Active Event` metric.
- For events.

### Event hidden from dropdowns

- Definition: Set event visibility in dropdowns
- Values:

  - `True`: Event is hidden in event dropdowns
  - `False`: Event is visible in event dropdowns
  - `<blank>`: Retains the current value
- For events

### Event hidden from persona results

- Definition: Set event visibility in persona results
- Values:

  - `True`: Event is hidden from persona results
  - `False`: Event is visible in persona results
  - `<blank>`: Retains the current value
- For events

### Event hidden from pathfinder

- Definition: Set event visibility in pathfinder
- Values:

  - `True`: Event is hidden from pathfinder
  - `False`: Event is visible in pathfinder
  - `<blank>`: Retains the current value
- For events

### Event hidden from timeline

- Definition: Set event visibility in timeline
- Values:

  - `True`: Event is hidden from timelines
  - `False`: Event is visible in timelines
  - `<blank>`: Retains the current value
- For events

### Event category

- Definition: Category of an event
- For events

### Event display name

- Definition: Only applicable to optional display names of events
- For events

### Event property name

- Definition: Name of the property
- Required for event properties and property group properties

### Event source

- Definition: Sources associated with the event
- For events

### Number property value min

- Definition: Minimum value of a property with number property value type
- For event properties and property group properties

### Number property value max

- Definition: Maximum value of a property with number property value type
- For event properties and property group properties

### Number is integer

- Definition: Denotes if a property with number property value type is an integer
- Values:

  - `True`: Property is an integer
  - `False` or `<blank>`: Property isn't an integer
- For event properties and property group properties

### Object type

- Definition: Entity type
- Values:

  - `Event`
  - `Property Group`
- Required for events and property groups

### Object name

- Definition: Name of the event or property group
- Required for events and property groups

### Object owner

- Definition: Owner of the event or property group
- Leaving this as `<blank>` removes the owner if one exists on the event or property group

### Object description

- Definition: Description of the entity
- For events and property groups

### Property type

- Definition: Type of property associated with the event
- Values:

  - `Event Property`
  - `Event Property Group`
- Required for events

### Property group names

- Definition: Property group that's associated with the event
- For events

### Property description

- Definition: Description of the property
- For event properties and property group properties

### Property value type

- Definition: The value type of an event property or property group property
- Values:

  - `string`
  - `number`
  - `boolean`
  - `any`
  - `enum`
  - `const`
- For event properties and property group properties

### Property required

- Definition: Denotes the required status of the property
- Values:

  - `True`: Property is required
  - `False` or `<blank>`: Property is optional
- For event properties and property group properties

### Property visibility

- Definition: Set property visibility in charts
- Values:

  - `VISIBLE`: Property is visible in charts
  - `HIDDEN`: Property is hidden in charts
  - `<blank>`: Retains the current value
- For event properties only

### Property is array

- Definition: Denotes if the property is an array
- Values:

  - `True`: Property is an array
  - `False` or `<blank>`: Property isn't an array
- For event properties and property group properties

### Property regex

- Definition: Regular expression (Regex) values for properties with a string property value type
- For event properties and property group properties

### String property value min length

- Definition: Minimum length of a property with string property value type
- For event properties and property group properties

### String property value max length

- Definition: Maximum length of a property with string property value type
- For event properties and property group properties

### Tags

- Definition: Tags associated with an event
- Format: separate each tag with a comma
- For events

### Additional fields .CSV export of events and event properties

The following list includes additional fields found in the .CSV export of your tracking plan’s events and event properties.

#### Action

- Definition: The default action to perform on a particular entity. This field exists in the import template, but the downloaded file includes default values.
- Values:

  - `Ignore`: The user property is unexpected, blocked or deleted.
  - `<blank>`: The user property is planned or live.
- For events, event properties, property groups property group properties

#### Event first seen

- Definition: The date on which the event was first seen.
- Format: `mm/dd/yyyy`
- For events

#### Event last seen

- Definition: The date on which the event was last seen.
- Format: `mm/dd/yyyy`
- For events

#### Property first seen

- Definition: The date on which the property was first seen.
- Format: `mm/dd/yyyy`
- For property groups

#### Property last seen

- Definition: The date on which the property was last seen.
- Format: `mm/dd/yyyy`
- For property groups

## User properties file schema

The list below highlights the required schema for the user properties .CSV file import. Note that:

- The file's header must contain all listed fields.
- The fields can be in any order, but their names and values must match exactly in spelling and capitalization for a successful import.
- Some fields require a value as indicated in the following list.

### Action

- Definition: Action to perform on a particular user property.
- Values:

  - `Ignore`: Amplitude makes no changes to the user property.
  - `Remove`: Amplitude removes the user property from the tracking plan. The removed value doesn't delete a user property or stop its ingestion.
  - `<blank>`: Creates the user property if it didn't already exist, or updates the user property if it did exist.

### Array min items

- Definition: Minimum number of items for a property with an array property value type

### Array max items

- Definition: Maximum number of items for a property with an array property value type

### Array unique items

- Definition: Denotes if an array property value type has unique items
- Values:

  - `TRUE`: Array has unique items
  - `<any>`: Assumes array doesn't have unique items

### Const value

- Definition: Const value for properties with a const property value type

### Enum values

- Definition: Enum values for properties with an enum property value type
- Format: Separate each enum value with a comma

### Number property value min

- Definition: Minimum value of a property with number property value type

### Number property value max

- Definition: Maximum value of a property with number property value type

### Number is integer

- Definition: Denotes if a property with number property value type is an integer
- Values:

  - `True`: Property is an integer
  - `False` or `<blank>`: Property isn't an integer

### Property type

- Definition: User property type
- Values: User property (required)

### Property name

- Definition: Name of the user property
- This value is required

### Property description

- Definition: Description of the user property

### Property visibility

- Definition: Set property visibility in charts
- Values:

  - `VISIBLE`: Property is visible in charts
  - `HIDDEN`: Property is hidden in charts
  - `<blank>`: Retains the current value

### Property value type

- Definition: The value type of a user property
- Values:

  - `string`
  - `number`
  - `boolean`
  - `any`
  - `enum`
  - `const`

### Property is array

- Definition: Denotes if the property is an array
- Values:

  - `True`: Property is an array
  - `False` or `<blank>`: Property isn't an array

### Property regex

- Definition: Regular expression (Regex) values for properties with a string property value type

### String property value min length

- Definition: Minimum length of a property with string property value type

### String property value max length

- Definition: Maximum length of a property with string property value type

### Additional fields in .CSV export of user properties

The following list includes additional fields found in the .CSV export of your tracking plan’s user properties.

#### Action

- Definition: The default action to perform on a particular entity. This field exists in the import template, but the downloaded file automatically includes default values.
- Values:

  - `Ignore`: The user property is unexpected, blocked, or deleted.
  - `<blank>`: The user property is planned or live.

#### Property first seen

- Definition: The date on which the property was first seen.
- Format: `mm/dd/yyyy`.

#### Property last seen

- Definition: The date on which the property was last seen.
- Format: `mm/dd/yyyy`.

