Merge Files to one Workbook

Required Tool:

Type of Tool

Level:

Data Cleanup, Data Preparation

Data Preparation

Popular Tool

What is this Tool?

This is placeholder text. To change this content, double-click on the element and click Change Content. Want to view and manage all your collections? Click on the Content Manager button in the Add panel on the left. Here, you can make changes to your content, add new fields, create dynamic pages and more.

Your collection is already set up for you with fields and content. Add your own content or import it from a CSV file. Add fields for any type of content you want to display, such as rich text, images, and videos. Be sure to click Sync after making changes in a collection, so visitors can see your newest content on your live site.

Ingredients

  • ingredient 1

  • ingredient 2

  • ingredient 3

  • ingredient 4

  • ingredient 5

  • ingredient 6

  • ingredient 7

  • ingredient 8

Preparation

Step 1: Headings in Top Row


Make sure all your data headings are named correctly and try to remove any empty columns or rows. This will help the AI read your data better and give you an overall improved analysis.



Step 2: Convert your file to CSV format


A CSV file is just a file that a computer can read. Don't know how to create a CSV file? Follow our easy step-by-step guide and you'll be using the Tools in no time!



Step 3: Use the Data Cleanup Tool First


This tool works best once you've put your data through the Data Cleanup Tool. This means that tiny errors in your data are removed, so our AI can accurately create insights for you. 



Step 4: Use the Data Preparation Tool

This Tool works best once you've also put your data through the Data Preparation Tool. So all your spreadsheets are together, and columns are in the right place ready for our AI to work its magic.