9. Import
X-Sheets supports importing data from CSV files to quickly populate new sheets with existing data.
9.1 CSV Import
The CSV import wizard creates a new sheet from a CSV file. Access it from the Data Editor by tapping the + button on the sheet tab bar and choosing Create Sheet from CSV.
The wizard walks you through five steps:
Step 1: Sheet Name & File
- Enter a sheet name (required). Must be unique — cannot match an existing sheet name.
- Upload a CSV file using the file picker.
Step 2: CSV Structure
- Preview the first row of your data in a table.
- Check “First row contains column headers” if your CSV has a header row. If checked, the first row becomes column labels instead of data.
Step 3: Column Names
- Column names are auto-generated (col_0, col_1, etc.) but fully editable.
- If you enabled headers in Step 2, the first row values are used as names.
- Use the + button to add extra columns or – to remove.
- At least one column must have a label.
Step 4: Normalization (Primary Key)
- Select which column serves as the primary key / identifier from a dropdown.
- Check “This sheet doesn’t contain an identifier” to auto-generate an ID column.
- Duplicate or empty primary keys are skipped during import.
Step 5: Confirmation
- Review your settings and tap Import to finalize.
- All imported columns default to Text (String) type. You can change column types after import via column settings.
Tip: After importing, open the column settings for each column to set the correct type (Number, Date, etc.) and formatting.
Next: Sharing & Permissions →