This article covers some frequently asked questions about how Amplitude exports .CSV files.
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.
How does Amplitude determine the structure of the .CSV file when exporting from an Event Segmentation chart?
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 is the value of the user property different between the chart and .CSV export?
By default, leading empty spaces may be in the cells of your exported .CSV file. To change this default setting: Read more about how to manage your settings.
Why are there leading spaces (tabs) in my exported .CSV file?
Thanks for your feedback!
October 8th, 2024
Need help? Contact Support
Visit Amplitude.com
Have a look at the Amplitude Blog
Learn more at Amplitude Academy
© 2024 Amplitude, Inc. All rights reserved. Amplitude is a registered trademark of Amplitude, Inc.