Importing data — Analyze the files

Click Analyze files and RowFold reads a sample of each sheet — up to the first 300 rows — to propose a plan. Every column gets a suggested field type (numbers, currency, percentages, dates, emails, URLs, phone numbers, checkboxes, select lists, and more), and select columns get their options collected from your actual values. Relations are found by matching values across files: when most of a column's values match the row names in another sheet — say an Orders file whose Customer column is full of names from your Customers file — that column is proposed as a relation between the two tables. Detected relations also produce suggested rollups, such as a count of linked rows or a total of an amount column.