Turn files into rows.

The load action takes the spreadsheet on a row and imports its lines into a table. AI matches the sheet’s columns to yours, and asks you when the match is not sure.

Get started

How actions work

Example 1

A file arrives, its orders load

One row with a file becomes five order rows.

Example 2

A messy file asks once

AI matches the columns and fixes the values.

Example 1 · Import Marketplace Orders

A file arrives, its orders load.

Each marketplace file is a row in Order Files. When a new row arrives with its file, the load action imports the order lines into Orders and stamps each order row with the file. Then the other Orders actions fill in each order.

Example 1 · Import Marketplace Orders: a new file arrives and its five orders load

Example 2 · The first file from a marketplace: AI matches the columns, then asks how the dates are written

Example 2 · The first file from a marketplace

A messy file asks once.

The first file from this marketplace had its own headers, a quantity written as “two”, and dates written two ways. AI matched the columns and fixed the values, then asked how the dates are written. The answer is saved, so the next file, in Example 1, loaded with no questions and no AI cost.

What you set on a load.

These settings belong to the load. Inputs, outputs, columns and conditions work the same as on every action: see Actions.

File format

Excel or CSV. A file of the other kind is refused. To take both kinds, make one load action for each.

One table to import into

Choose the table once. A table can have only one load action. To import into a different table, make a new load action.

Values for every row

Add an input to put the same value on every row that the action loads: the file the row came from, as in Example 1, or a parent row.

Good to know.

A file that needs a person waits.

If the AI is not sure, or a value cannot be read, the import stops on the table’s Imports page until someone answers. No row loads before that.

Each answer is kept.

The next file with the same columns loads by itself.

A key column refuses copies.

The first row with each value loads. A later row with the same value, or a value already in the table, fails until you fix or skip that row.

Cost.

1 credit a run, plus the AI calls when the action must match columns. The file in Example 2 took 8 calls and 63 credits. The file in Example 1 took none.

Limits.

100 MB a file and 2,000,000 cells a sheet.