How to fix exported data appearing in one column

When you open a downloaded CSV file, you may find that all the data appears in a single column instead of being separated into multiple columns.

This usually happens when the column separator used by STACKED does not match the separator expected by your spreadsheet application or regional settings.

To fix this, change the Column Separator in STACKED and download the data again.


Change the column separator

  1. Open Settings in STACKED.

STACKED showing Settings option

  1. Go to the Browser tab.
  2. Under Data File Format, find Column Separator. Select a different separator.

STACKED Browser settings showing the Column Separator option under Data File Format.

  1. Download the CSV file again and open it in your spreadsheet application.

You may need to try a different separator depending on your spreadsheet application and regional settings.

The Column Separator setting is available in the Expert UI. If you don’t see the Browser tab, learn how to enable the Expert UI.