Skip to main content
M
mariaSutton12-Amethyst
12-Amethyst
May 8, 2024
Solved

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

  • May 8, 2024
  • 1 reply
  • 1528 views

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. 

    Best answer by CharlesJi

    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.

    1 reply

    C
    CharlesJi16-PearlAnswer
    16-Pearl
    May 9, 2024

    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.

      Terms & ConditionsCookie settingsAccessibility statement