Import a sheet list

Turn a sheet list from Excel, Revit or a consultant into sheets, with sections, series, tracks and revisions filled in from its columns.

Cartoon Set reads a sheet list as a CSV file or as rows pasted from Excel. It works out each sheet's section and series from its number, and reads track and revision columns if the list has them. You check everything in a preview before anything changes.

The import runs in your browser. Nothing is sent anywhere until the set is saved.

Import a list #

Click Import ▾ → From a spreadsheet….
Under 2 · Upload or paste it, click Choose a .csv file…, or paste rows into the box. Pasted rows are read when you click away, or when you click Read the pasted rows.
Under 3 · Check the columns and the preview, check what each column is (see below).
Choose where the sheets go and what to do with numbers already in the set.
Check the preview, then click the button at the bottom: Add … sheets to this set or Start a new set with … sheets.

Tab-separated and semicolon-separated files work too. If the list has a title block above its header row, those lines are left out.

Check the columns #

Every column has a menu saying what it holds. Most are matched from their headers, like "Sheet No." or "Drawing Title". Change any that are wrong:

Sheet number and Sheet title
Section (discipline) and Series (number block): override where a sheet goes.
Series purpose and Notes
Tracks (a list of names): one column naming the tracks, like "Permit, Construction".
A track (Yes / X = on it): one column per track, marked Yes, X or a check.
An issue (holds revisions): one column per issue, holding each sheet's revision.
Not imported: leave the column out.

An issue column is read from a header like Permit · Submission (2027-03-01): the track, the issue and its date. A Yes or X in an issue column means "it went out here": the sheet gets its next revision.

With no header row, the first column is read as the number and the second as the title.

Where the sheets go #

Each sheet's number places it:

The letters pick the section. A-101 goes in A. A missing section is made, named from the US National CAD Standard list (A Architectural, S Structural…).
The number picks the series. Three or more digits make blocks of a hundred: A-101 goes in A-100 (100–199). A shorter number after a dot makes one block per prefix: A1.01 goes in A1.00.
No number (like A-COVER) puts the sheet in the section's "(unnumbered)" series.

An existing series that covers the number is used. Tracks and issues named in the columns are made if they're new, with revision marks guessed from what the columns hold.

Into this set or a new one #

When the set on screen already has work, choose Into:

This set: the sheets are added to it.
A new set: it replaces the set on this computer. Give it a Name.

Numbers already in the set #

Numbers already in the set decides what happens when a number is already there, or repeats in the list:

skip them (the default)
update their title, notes and tracks
add them again (flagged as duplicates)

Read the preview #

The preview lists the first sheets with their number, title, section, series and tracks. Under it:

How many sheets will be added, updated or skipped.
The import also makes: the new sections, series, tracks and issues.
Notes on anything left out or worth checking, like rows with no number, columns not imported, or sheets that will get a warning.

Prepare a messy list first #

Step 1 · Get it into the template has two downloads: Template (.csv) and Rules document (.md). Give both to an AI assistant you trust, along with your sheet list, and have it fill in the template. Then import its CSV here.

A CSV exported from Cartoon Set already matches the template. See Export.

An AI assistant connected through the AI connector can also build the set for you straight from your list.