As you may have noticed, the data is exported from your account in CSV files. The files are formatted and structured in a standard way to make them compatible with any BI tool.

If you wish to open the files in Excel, there are two ways to do so.

Option 1 - Split Data into columns

  1. Open the CSV file in Excel. The data will appear in one column, separated by commas.

  2. Select the first column where the data is

<a href=https://storage.googleapis.com/slite-api-files-production/files/4b6455d1-4964-4451-ae9a-1727d1aec8c6/image.png"/>

3. Go to the "Data" section in excel and click on "Text into column"

<a href=https://storage.googleapis.com/slite-api-files-production/files/855fc8f8-258b-4d5e-9d3a-6fb6822f4552/image.png"/>

4. This will open a pop-up. Select the option "Delimited" and click on Next

<a href=https://storage.googleapis.com/slite-api-files-production/files/bc9bd92d-8b72-4611-9762-4d9add9fdfa1/image.png"/>

5. Select "comma" as a delimiter and click "Finish"

<a href=https://storage.googleapis.com/slite-api-files-production/files/5fb361bd-853f-4402-a0ed-b437b37643b1/image.png"/>

⚠️ If the content of a cell (for instance an app name, or description etc.) contains a comma, this can trigger a jump in columns.

Option 2 - Import CSV in Excel

  1. Open a new excel file. In "File" go to "Import"

2. Select "CSV file" among the options

<a href=https://storage.googleapis.com/slite-api-files-production/files/8707ea07-d6d2-4195-8d57-dd622b85bc3a/image.png"/>

3. Select the CSV file you wish to import (the file you just exported from AppTweak)

4. Select the option "Delimited" in the Text Wizard

<a href=https://storage.googleapis.com/slite-api-files-production/files/0c97cb84-2b49-428d-b9cc-62555a8424be/image.png"/>

5. Select comma as delimiter and click on Finish

<a href=https://storage.googleapis.com/slite-api-files-production/files/9ce2bce5-e51f-41f4-a1d5-b7b177859580/image.png"/>

⚠️ If the content of a cell (for instance an app name, or description etc.) contains a comma, this can trigger a jump in columns.

Did this answer your question?