Import a spreadsheet of cars in Grove

Send the file with a line for Cedar. Click + in the message box, then File, pick the spreadsheet, and write something like "@Cedar please import this week's list". In Cedar's own room, Upload this week's list opens the file picker and writes the line for you. Cypress reads the file the way its Import screen does: it matches each column to a field by its name and its values, turns kilometres into miles, and reads money and dates. Then it checks every row against your fleet. Nothing is saved yet.

Read the card. Cedar answers with an Import card: the file, how many rows are new cars and how many update cars you already have, and how many things need you. If a column could not be read cleanly, the card says so under From the file: a column left out, a column in kilometres, rows without a VIN, or a column that is missing (no mileage, no floor price, no lot).

Check the columns, when the card asks. The card shows Columns first when Cypress guessed what a column is, or found no column that is clearly the VIN. On top are the fields Cypress requires, as on its Import screen: VIN, Mileage, Lot or ZIP and Floor price, each green once a column fills it. Only a missing VIN stops the import; a new car missing the others gets them while you get it ready. Each column shows its name, its first value, what it is (the required fields first in the list), and Match, Guess or Yours. Click Looks right to keep them, or Use these columns after a change: Cypress reads the file again with your columns. To change the columns later, open the three dots and click Change columns.

Settle what needs you, one thing at a time. The card asks only what it has to, in this order:

• The same VIN twice: which row to keep.
• A mileage lower than Cypress has: odometers do not go back, so keep Cypress's number or use the file's.
• A lot Cypress does not know: pick the saved lot it is, and tick Remember so the name matches next time, or leave those cars without a lot.
• A car already sold: leave its row out, or update it anyway.
• Rows Cypress cannot take: they are left out; fix them in the file and send it again.

A lower mileage is asked even when only the last check shows it (a VIN twice in the file, once you keep one row).

Read every car before you run it. Once nothing needs you, Cypress checks the rows again, exactly as they will be sent, and the card lists them: New cars (with their miles and lot), Updates (each field from → to, for example "Mileage 25,500 → 26,000"; a change that goes to review first says so), No change (Cypress already has it as the file does), To archive and Left out (with why), one row per car with its badge. Chips narrow the table; See all brings every car. New cars come in as drafts: none goes on the market until it is ready and you launch it. Under the table, Cars in Cypress not in the file stay as they are; open it to tick the ones to archive and click Archive (a car in a sale or with open offers goes to your Cypress Manager to archive).

Click Run import, read the confirm, and click Import now. The card shows the cars coming in and being valued, then "Imported: 2 new cars in, 1 updated".