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
- Open the CSV file in Excel. The data will appear in one column, separated by commas.
- Select the first column where the data is
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"
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
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"
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
- Open a new excel file. In "File" go to "Import"
2. Select "CSV file" among the options
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
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
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.