"Download CSV" for the Time Series Chart (Quiver)

Ask the Community
1

When the language of Foundry is set to “Japanese,” characters are garbled and lines are shifted.
However, “English” is downloaded without any problem.
Please let me check the cause and whether it can be improved.

■English

Timestamp Linear aggregation
2027/04/01 00:00:00.000T 11.053
2027/04/01 01:00:00.000T 11.487
2027/04/01 02:00:00.000T 11.765

■Japanese

Timestamp 邱壼ｽ｢髮・ｨ・2027/04/01 00:00:00.000T 11.053
2027/04/01 01:00:00.000T 11.487
2027/04/01 02:00:00.000T 11.765
2

Hi, what are the export settings used here, and do you have any examples of characters that get garbled? I wasn’t able to reproduce this with default settings and a random title (we use UTF-8 character encodings, which should support Japanese).

Another possibility is that the CSV data isn’t being correctly parsed by this renderer - we are aware that different machine language configurations can cause issues when CSVs get parsed into Excel files. How is this data being viewed?

3

Thank you for your comment.
As you said, the character code of the downloaded file is UTF-8, but it was opened with Shift_JIS in Excel, so it was just garbled.

I’m sorry that I inquired with insufficient confirmation.

4

I see, the issue comes from parsing the CSV into Excel. I think the best solution here would be to add the option to download data directly as Excel XLS files, which would not be influenced by language settings. We’ll track this as a feature request, thanks for your feedback!

1 Like
5

Hi @df758869b914c4e1d6ad, we might’ve actually found the fix for this issue - Quiver time series chart data exports in CSV format are now prefixed with a UTF-8 BOM, so that Excel can correctly parse the UTF-8 encodings.

Please let me know if exports work as expected now, or if you run into any further issues!

6

Thank you for your prompt response.
We were able to confirm that Excel can analyze it properly.

1 Like