1. One Survey per Workbook/Excel file: Each workbook (or Excel file) should contain only one survey data set. If you need to analyze other survey data, you should use a separate workbook.

2. Survey Data Set Up: Your survey data is located on a single sheet within the workbook. The data should start in cell A1, with the first row containing the questions and the first column containing the respondent IDs (or a Timestamp that can serve as an ID). Each intersecting cell holds the answer to a specific question from a particular respondent. When Splitter is first activated, it will automatically rename the sheet to "Form Response 1."

3. One Cell Data : Answer for any question type—whether single answer, multiple answers, or open-ended—are recorded in a single cell, regardless of the length of the response. For multiple answers, separate each answer with a comma.

4. AI-Assisted Data Cleaning: Before creating tables, AI may be needed to clean the data, especially for open-ended questions. Copy the data from the relevant column, paste it into an AI tool with specific instructions, and then paste the cleaned data back into the survey data column. This AI data cleaning process may require multiple attempts, with adjustments to the prompts and careful double-checking, until the results are satisfactory.

5. Initial Run: On the first run, Splitter will automatically code all text data within the survey. This process may take a few minutes, depending on the size of your survey data.

6. Generating Tables: After coding is complete, you can directly generate the data tables you wish to create on a new sheet.

7. Tables Essentials: Splitter is equipped with cross-tabulation, filtering functions, and basic statistics like averages and standard deviations for in-depth data analysis, similar to Pivot Table.

8. Organize and Code Data: You have the option to organize and refine the codes for text data, or to create codes for numeric data. You can also combine or exclude codes as needed.

9. Post-Analysis Data Cleaning: Data cleaning may be necessary after reviewing the results. You can update the cleaned data based on the specific question and make adjustments to improve accuracy.

10. Editing Responses: Splitter allows you to edit individual responses to improve accuracy or clarity.

11. Saving Your Work: When you save the workbook, Splitter will retain the latest arrangements, ensuring your data and analysis setup are preserved.

12. Data Safety: Your data is safe. If during organizing or editing you feel you’ve made a mistake, simply copy the data in the "Form Response 1" sheet to another workbook and start over.

13. Sharing Your Work: Your work, including its arrangements, can be shared with other Splitter users. Simply send the file to another Splitter user, allowing them to create tables based on your saved configurations.