cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Add support for Excel files/different separators

Add support for Excel files/different separators

I suggest to add support for importing Excel files when creating datasets.

"Export to CSV" is an available feature in Excel, but there are drawbacks:

When you are not an US-locale, or more specifically, your regional setting for separator is not US-style ",.", then Excel will export e.g. using semicola as separators, or the "wrong" decimal separator and the file can't be imported. This is a shortcoming of Excel which can only be solved by changing one's regional settings or using special macros.

The other issue is encoding, which also leads to issues with field names when not done correctly. If TWA would support Excel, it could switch to the right encoding in the first place.

Supporting Excel would lower the entry barrier for new users who are doing their first steps with Analytics. Excel is still used traditionally in many companies for data storage.

 

A "smaller" version of this idea would be to just support CSV with different separators, with a default that can be overridden on each import.

 

1 Comment
olivierlp
Community Manager
Status changed to: Archived

Hello,

We are archiving your idea as part of a general review. This action is based on the age of your idea and the total number of votes received, as per this announcement.

You can always post a new idea with all the details required in the form.

Thank you for your participation.