This article covers some frequently asked questions about how Amplitude exports .CSV files.
How does Amplitude determine the structure of the .CSV file when exporting from an Event Segmentation chart?
Amplitude uses the breakdown data table as a guide when creating the .CSV file to export. The format and structure of the table should be mirrored in the .CSV.
The .CSV file is not showing all the possible values of the user/event property. Why is that?
There are limits to the amount of values appear in a .CSV file. This differs from chart to chart. Read more about these limits here.
Why is the value of the user property different between the chart and .CSV export?
When downloading users from the chart via Microscope, the .CSV will contain the most recent property values for the user. The chart is returning the property value at the time of the event.
Sometimes the .CSV has certain property values populated which are listed as "none" in the chart. Why is that?
Similar to the previous answer, when downloading users from the chart via Microscope, the .CSV will contain the most recent property values for the user. The chart is returning the property value at the time of the event.
Why are there leading spaces (tabs) in my exported .CSV file?
By default, leading empty spaces may be in the cells of your exported .CSV file. To change this default setting:
- Go to Personal settings,
- then Profile,
- and enable the Always Remove Leading Spaces from Export toggle under Site Settings.
Read more about how to manage your settings.