I always have huge spaces (tab?) in front of a text in every cell of heading when export data to csv. The only way how I can remove all these extra spaces fast enough is to create an extra column or row with a formula ‘=clean()’
Could anyone advise, please, what setting on my computer I need to change to fix this?
Best answer by Thao Nguyen
View original
+5
Hi
Thank you for writing in! Happy to help!
Our engineering team modified exported CSVs to include additional quotation and tab characters in front of all values as a preventative measure for a security risk known with CSV downloads (details here). Attackers can potentially use a formula to inject false data or leak data. And in order to prevent formula triggering cells from running, our engineering team revamped our CSV exports by prefixing quotation and tab characters in front of all values.
With that being said while that security issue remains we received feedback from customers who said that they were willing to take that risk. Therefore, we implemented a way to export CSVs from Amplitude without any characters in front for those users.
If you are willing to take that risk as well you can enable the feature to remove the spaces in your CSV in your Org Settings section on the Profile page. You can scroll down and turn off leading spaces in CSV with the toggle on that page.
If you are not willing to take that risk one possible solution for Excel you could try to eliminate the additional characters, you can use the following formula: TRIM(CLEAN(cell)).
Hope this helps! Please do let me know if you have any more concerns about this.
Best regards,
Thao
Thank you
Best Regards,
Elena.
I found one more quick fix for removing all tab characters. Open csv file with a text editor (Notepad or VS Code), use Find/Replace and save it back, then open it with Excel.
+5
You are welcome,
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.