cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

Is there a way to name the CSV sheet exporting by the Data Export widget?

mariaSutton
8-Gravel
8-Gravel
‎May 08, 2024 12:22 PM
‎May 08, 2024 12:22 PM

Is there a way to name the CSV sheet exporting by the Data Export widget?

Hi, 

I am trying to explicitly name the sheet that is exported when using the Data Export widget in a mashup. Currently the filename is copied to the sheet name, however the sheet name can only hold 31 characters and the file name will always be longer. 

Preview file
115 KB
0 Kudos
Notify Moderator
1 REPLY 1
CharlesJi
14-Alexandrite
14-Alexandrite
(To:mariaSutton)
‎May 08, 2024 11:09 PM
‎May 08, 2024 11:09 PM

Hi @mariaSutton, 

The Data Export widget simply exports a CSV (Comma-separated values) file, which are just lines of data with commas separated.

If you open a CSV file in Excel, it takes the filename to 'name' its sheet automatically (just for the visualization, no changes made to the file itself).

 

You'll have to save it as some sort of Excel file in order to rename the Excel sheet name explicitly. Note that by doing so, your file extension will be changed (e.g., from .csv -> .xlsx), and technically, the file will no longer be a CSV file anymore.

Notify Moderator
Top Tags