Import spreadsheets

import pandas as pd

xls = pd.ExcelFile('customers.xlsx')
print("Sheets:", xls.sheet_names)

for name in xls.sheet_names:
    df = pd.read_excel(xls, sheet_name=name)
    print(f"\n--- {name} ({df.shape[0]} rows x {df.shape[1]} cols) ---")
    print("Columns:", list(df.columns))
    print(df.head(10).to_string())

df = pd.read_excel('file.xlsx')                          # first sheet
all_sheets = pd.read_excel('file.xlsx', sheet_name=None) # dict of DataFrames
sales = pd.read_excel('file.xlsx', sheet_name='Sales')   # one sheet
csv = pd.read_csv('file.csv')
tsv = pd.read_csv('file.tsv', sep='\t')

// apps/<app>/src/api/importCustomers.ts
import { z } from 'zod';
import { createEndpoint } from 'zitejs/backend';
import { zite } from 'zitejs/db';

export default createEndpoint({
  description: 'Import customer rows from a parsed spreadsheet',
  inputSchema: z.object({
    rows: z.array(z.object({ email: z.string().email(), name: z.string(), plan: z.string() })),
  }),
  outputSchema: z.object({ imported: z.number() }),
  execute: async ({ input }) => {
    const result = await zite.Customers.bulkCreate({
      records: input.rows.map(r => ({ email: r.email, fullName: r.name, plan: r.plan })),
      matchOn: ['email'], // upsert on email so re-imports don't duplicate
    });
    return { imported: result.records.length };
  },
});