Skip to content
Getting started

Bringing your data in

G Gript Team Updated Sep 7, 2026 8 min read

You almost certainly have work somewhere else already. Gript will bring it across rather than making you retype it. Everything happens in a guided wizard: you connect or upload, you pick what to bring, you check how the columns line up, and you press Import.

1

Where to start

Data Migration
Control Panel, Data Migration
The Data Migration page, listing monday.com, Trello, Asana, Jira, ClickUp, spreadsheets and Gript Bridge

Open Control Panel, then Data Migration. The page lists every source, in three groups.

SourceWhat comes across
monday.comBoards, items, groups, columns, and files.
TrelloBoards, lists, cards, checklists, and files.
AsanaProjects, sections, tasks, subtasks, and comments.
JiraProjects, issues, subtasks, files, and comments.
ClickUpSpaces, folders, lists, and tasks.
CSV, Excel or JSONAny spreadsheet, or a Gript JSON export.
Gript BridgeBoards from another Gript workspace, for example a sandbox into your live workspace.
2

How an import runs

The same four beats, whichever source you pick.
1
Connect, or upload
For another tool you sign in or paste an access token, which the wizard tells you where to find. For a spreadsheet you drop the file in.
2
Choose what to bring
The wizard lists what it found: boards, projects, spaces, lists. Tick the ones you want. There is no need to take everything on the first run.
3
Check the column mapping
This is the step worth slowing down for. Gript proposes a Gript column type for each of their fields (their status becomes a Status column, their due date a Date column, and so on). Change anything that looks wrong and skip anything you do not want.
4
Import
Gript creates the boards, groups, items and column values, and pulls the files across. Larger imports keep running in the background, so you can carry on working.

Import one board first and look at the result before you move everything. It takes five minutes and it teaches you what your own mapping should be.

3

Spreadsheets

The quickest way in, and the one most people use.
Getting a spreadsheet inWhat to know
The first rowShould be your column headings.
Every row after itBecomes an item.
The mapping stepTell Gript which heading is the task name, and what each other column should become: text, number, date, status, dropdown, person.
A person columnMatched by email address where it can, so assignments come across as real assignments rather than plain text.

A spreadsheet with a person column matches people by email address where it can, so assignments come across rather than turning into plain text.

A sales lead has eight newly signed clients in a sheet: company, contact email, contract value in kroner, a due date, an onboarding period, a stage, a priority, an owner and a line of notes. Ten minutes of retyping, or one paste. Gript reads what each column holds, down to the flavour: an amount in kroner is not a plain number, two dates in one cell are a timeline, a short set of repeating words is a Status. It creates the columns you are missing with the right settings already in place, explains every decision in one line under the row, and asks you instead of guessing when a date could be read two ways. Nothing is created until you click Create, and the preview shows exactly what will be.

The paste window
Board, + Add item, Ctrl/Cmd + V
The Paste into columns window: a Column mapping list with one row per copied column and a dropdown beside each, type chips and a reason line under the columns that will be created, and a preview table of the rows underneath
4

Paste rows straight onto a board: do it now

Seven clicks from a spreadsheet to a filled board.
1
Copy your rows
A block of cells in Excel or Google Sheets, a table on a web page, a table in Word or in an email: select it and press Ctrl/Cmd + C. Include the header row or leave it out, both work. Up to 100 rows go through at once.
2
Click + Add item
At the bottom of the group you want the rows in. A name box opens with "New Item" selected.
3
Press Ctrl/Cmd + V in that box
Instead of pasting one long name, a window called Paste into columns opens. Its heading line says how many items will go into which group and how many columns will be filled.
4
Read the Column mapping list
There is one row for each column you copied, showing its heading and two example values, with a dropdown beside it saying where it goes: Item name, one of the columns already on this board, + New column, or Skip this column.
5
Check the type of each new column
Under a row that will become a new column, the type Gript picked is the selected chip, the other types that fit sit next to it, and one line says why. Click another chip to change the type. The chip text names the settings too, for example "Number in DKK, 2 decimals" or "Status, 4 labels".
6
Answer any question
A row that turns amber is asking you something, for example how to read a date like 03/04/2026. Nothing is chosen for you. The footer names the column, and the Create button stays off until you answer.
7
Click Create
The button reads Create followed by the number of rows. The rows appear in the group with their values filled in, and any new columns appear at the right end of the board.

The Preview table under the mapping list rebuilds every time you change a dropdown, a chip or an answer, so it always shows exactly what will be created. It shows the first 8 rows and says how many more follow.

5

Before you paste, a minute on the sheet

None of this is required. Each one makes the result better.
One row per item
Every row becomes one item, and the column that names it becomes the item name. Merged cells and sub-total rows become rows too, so leave them out of the selection.
Keep the header row
A header row lets Gript match by wording, so a column headed Due date lands on your Due date column even when its values could fit two columns. Without a header, Gript reads the values instead, which works, but a heading is a stronger signal.
Keep amounts with their currency
Write 125.000,00 kr or $1,200.50 rather than a bare 125000, and Gript creates the Number column already formatted in that currency. A bare number becomes a plain Number column, which you can format later.
Write dates one way
A column that mixes 03/04/2026 with April 3, 2026 still works, but a column written one way tells Gript more. One date with a day above 12 (13/04/2026) settles the reading order for the whole column, so it never has to ask.
Copy more than you need
It is quicker to copy the whole table and set two columns to Skip this column than to select around them.
Consistent labels
Done, done and DONE become one label (matching ignores case), but Done and Completed become two. Tidy the words in the sheet if you want one Status label each.
6

The window, part by part

PartWhat it does
Heading line"8 items into New signings · 7 columns filled". The group is where you clicked + Add item. When you pasted from a filtered or virtual group, a Target group dropdown appears here instead, and you pick the group.
How column matching worksA folded explanation at the top. Click it to read how the matching was done and what is worth knowing, click again to fold it away.
Column mappingOne row per copied column: its heading (or Email, Amount, Timeline, Status, Column 3 when there was no header), two example values, and the destination dropdown. Only one column can be the item name; give that job to another row and the first one turns to Skip.
The line under a rowFor a new column: the type chips and the reason. For an existing column: how it was matched and what will happen. For a skipped column: why. For an ambiguous date column: the question and its two chips. The line opens when the row needs it and closes when it does not.
PreviewA table of the first 8 rows as they will be created: the name, then one column per destination, with new columns marked (new) and a coloured dot showing the type. Each cell is rendered the way the board will render it: kr 125,000.00 for an amount, a coloured label for a Status, a calendar icon and two dates for a timeline.
FooterThe count ("8 items · 5 new columns"), Cancel, and Create. While a question is open the footer says "Choose how to read the dates in Due" and Create is off. If the server refuses the paste, the reason appears here and nothing is created.
One mapping row
Column mapping, a column that becomes a new Number column
A mapping row for the copied Contract value column: the heading, two sample amounts, the dropdown reading + New column, the three type chips Number in DKK, Plain number and Text, and the reason line underneath
The preview
Paste into columns, after answering the date question
The preview table in the paste window: eight client rows with the name, an email, a kroner amount rendered as kr 125,000.00, a date, a timeline, a coloured Status label and a priority
7

How Gript decides where a column goes

In this order. The first rule that applies wins, and each board column is claimed once.
1
Same title
A copied column headed Budget lands on your Budget column, whatever it holds.
2
A heading that names a type
E-mail, Mail or Work email means your Email column. Phone, Mobile, Tel or Cell means Phone. Link, Website, URL or Homepage means Link. Date, Due, Deadline, Start date or End date means Date. Timeline, Period or Date range means Timeline. Time, Hour or Start time means Hour. Duration, Time spent, Effort or Estimate means Duration. Status, State or Stage means Status. Priority or Urgency means Priority. Amount, Qty, Price, Cost, Budget, Score, Value, Total or Revenue means Number. Notes, Description, Comments or Details means Long text. Location, Address, City or Country means Location. Tags, Labels, Keywords or Skills means Tags. Type, Category, Team, Department, Region or Source means Dropdown. Among several Number columns, an amount in kroner prefers the one already formatted in kroner.
3
The values
With no usable heading, the values decide: addresses go to an Email column, links to a Link column, dates to a Date column, phone numbers to Phone, amounts to a Number column already formatted in that currency when you have one, two dates in one cell to a Timeline column, and a short set of repeating words to the Status, Priority or Dropdown column that already holds at least half of them.
4
Otherwise, a new column
With full access to the board, Gript proposes + New column with the best type selected. With edit access only, the row is set to Skip and says why; you can still point it at a column that exists.

The item name is chosen first: a heading like Name, Task, Title, Item, Subject, Contact, Customer or Company, and otherwise the first column of ordinary words. A column of repeating labels or of tag lists is never taken as the name, so a sheet whose first column is a status still gets the right name column.

8

What each kind of value becomes

The type Gript picks first, and what sits one click away.
You pastedYou get
[email protected]An Email column. Text is one click away. "Thomas Frank <[email protected]>" is read as the address, with the name kept as its label.
125.000,00 kr · $1,200.50 · 500 EUR · DKK 500A Number column already formatted in that currency, with the number of decimals the values use and thousands separators on. Eleven currencies are recognised by symbol or code, written before or after the amount, in either 1.250,00 or 1,250.00 style: DKK, SEK, NOK, USD, EUR, GBP, CHF, JPY, CNY, INR and ILS. A bare kr is taken as Danish kroner. Plain number and Text are one click away.
50%A Number column that shows the percent sign, storing 50. When every value is a whole number from 0 to 100, Progress is offered as well.
12 kg · 3 pcs · 250 mA Number column with the unit set once on the column, so it is never typed into a cell.
42 · 3.5 · 1,000A Number column, with decimals when the values have them.
3 · 5 · 1 (every value from 1 to 5)A Rating column. Number is one click away.
2026-04-03 · 03.04.2026 · Mar 3, 2026 · 3 March 2026A Date column, with its date format matching what you pasted.
2026-03-01 14:00 · Mar 3, 2026 9:15 AMA Date column with Include time switched on, 12-hour when the values used AM and PM. Date only is one click away.
01.03.2026 to 14.03.2026 · 2026-04-01 to 2026-04-05A Timeline column. The two dates can be joined by to, til, until, an arrow or a dash. Date with end date is one click away.
14:00 · 2:30 PM · 9amAn Hour column, stored as 24-hour time.
2h 30m · 1:30:00 · 90 min · 2.5hA Duration column. Number (hours) is one click away, which turns 2h 30m into 2.5.
Done, In progress, Not started, repeated down the columnA Status column with those labels already on it, in the order they first appear, using the colours Gript uses for those words (green for done, blue for in progress, amber for waiting, red for stuck, grey for not started) and Done counted as complete. Recognised states include done, complete, closed, resolved, stuck, blocked, in progress, working on it, waiting, on hold, review, pending, not started, to do, open, new and backlog, plus færdig, afsluttet, i gang, venter and ikke startet.
High, Medium, LowA Priority column with those levels in the priority colours. Critical, urgent, normal and lowest count too, and høj, mellem, lav. Dropdown and Status are one click away.
Sales, Ops, Sales, Ops (any other short set of repeating words)Dropdown and Status are offered side by side, Dropdown selected. You pick. A set counts as labels when there are at least 4 rows, at most 12 different values, each at most 30 characters, and they repeat.
design, web · web, seo · design, seoA Tags column with those tags ready to pick. Dropdown with multiple choice is one click away.
Sentences averaging more than 80 charactersA Long text column. Shorter text becomes Text, with Long text and Dropdown one click away.
Yes, No · true, false · ja, nej · x · a tickA Checkbox column.
+45 12 34 56 78A Phone column.
https://nordiskbolig.dk · www.nordiskbolig.dkA Link column. An address without https is given it.

A column is read as a kind when at least 6 of every 10 non-empty cells agree. A column of 8 emails with one blank and one "n/a" is still an Email column; the "n/a" is left empty, and the reason line says so: "7 of 8 values are email addresses. The other 1 will be left empty."

9

What the row tells you

One line under every column, written to be checked against the two example values above it.

Under a column that becomes a new column: "All 8 values are amounts in Danish kroner, written 1.000,00 style. The column will show them as kr 125,000.00." Or: "3 different values across 8 rows: High, Medium, Low. The labels are added to the new column in that order." Or: "Every cell holds two dates, read as day.month.year." Or: "Every value is a whole number from 1 to 5, so this reads as a rating."

Under a column that goes to a column you already have: how it was matched ("Matched to Status by its header." or "Matched to Email because the values are email addresses."), which labels will be added ("On hold is not on Status yet and will be added as a new label."), that kroner pasted into a plain Number column will lose the sign ("Budget is a plain number column, so the DKK will not be shown."), that a percent column will store 50 rather than 50%, that a Date column without times will keep only the dates, or how many values fit after you re-map by hand ("2 of 8 values in Amount fit a date column. The rest will be left empty." and, when none do, "No value in Amount fits a date column. Every cell will be left empty.").

Under a skipped column: why. "Owner is a person column and cannot be filled from pasted text." or "Creating columns needs full board permission."

The note under an existing column
Column mapping, a column matched to the Status column
A mapping row for the copied Stage column pointing at the existing Status column, with the note underneath saying it was matched by its header and which label will be added
10

When Gript asks instead of guessing

A date like 03/04/2026 can mean 3 April or 4 March. When every date in a column could be read both ways, the row turns amber and asks: "These dates can be read two ways. 03/04/2026 is:" with two chips, 3 April (day first) and 4 March (month first). Nothing is chosen for you. The preview shows choose a reading in that column, the footer says "Choose how to read the dates in Due", and the Create button stays off until you click one of the two chips.

When one value settles it, there is no question: 13/04/2026 can only be day first, 04/13/2026 can only be month first, and the whole column follows. Dates written with dots (03.04.2026) are always read day first, dates written 2026-04-03 are never in doubt, and a month written out (Mar 3, 2026 or 3 March 2026) needs no reading order at all.

The date question
Column mapping, a column of dates that could be read two ways
An amber mapping row for the copied Due column, pointing at the Due date column, with the question These dates can be read two ways and the two chips 3 April (day first) and 4 March (month first) underneath
The footer while a question is open
Paste into columns, footer
The footer of the paste window reading Choose how to read the dates in Due, with the Create 8 items button greyed out

Before September 2026 every slash date was read month first without a word, so 03/04/2026 pasted from a Danish sheet landed on 4 March. If you pasted dates before then, that is why some were a month out.

11

After you create

1
Where the rows are
In the group you pasted into, at the bottom, in the order of the sheet. Each one is an ordinary item: open it, assign it, move it, delete it like any other.
2
Where the new columns are
At the right end of the board, in the order of the sheet, named after the sheet headings (or Email, Amount, Timeline, Status when there was no header). Drag a heading to move a column, and double-click it to rename.
3
Change a column setting later
Hover the column heading, open its menu and choose Edit column. A Number column shows its format, decimals and unit there; a Date column its format and Include time; a Status column its labels and which ones count as done.
4
The labels on a new Status column
They are the values from the sheet, in the order they first appeared, each with a colour. Edit column lets you reorder them, recolour them and mark which ones count as complete.
5
Undo
Select the pasted rows (click the first, Shift + click the last) and delete them; they go to Trash, where they can be restored for 30 days. A column the paste created is removed with Delete column in its column menu, which removes its values with it.
After Create
Board, the New signings group
The New signings group after the paste: eight client rows with their Status labels, empty Owner cells, the due dates, and the new Contact email column
12

Three real pastes

What people actually copy, and what they get.
A pipeline export from a CRM
Columns: Company, Contact, Email, Deal value, Stage, Expected close, Owner, Next step. You get: Company as the item name; Email as an Email column; Deal value ($1,200.50 style) as a Number column in USD with 2 decimals; Stage (Qualified, Proposal, Negotiation, Won) as a Status column with those four labels, because the heading says Stage; Expected close (04/13/2026 style) as a Date column, with no question because 13 settles the order; Owner as Text, because names are never matched to people; Next step and Contact as Text. Two things to do afterwards: Won is not a word Gript knows as complete, so mark it under Edit column, and give Owner to a Dropdown if you want to filter by it.
An IT asset register
Columns: Asset, Serial number, Purchased, Warranty, Cost, Location, In use. You get: Asset as the item name; Serial number as Text (letters mixed into digits are not a number); Purchased (12.03.2024 style) as a Date column read day first; Warranty (12.03.2024 to 11.03.2027) as a Timeline column; Cost (4.500,00 kr) as a Number column in DKK; Location as a Location column, by its heading; In use (Yes or No) as a Checkbox column.
A project plan
Columns: Task, Phase, Start, End, Effort, Owner, Done. You get: Task as the item name; Phase (Discovery, Build, Launch, repeated) as a Dropdown column with Status one click away; Start and End as two Date columns, because two separate columns are not joined into one Timeline (write them as one "start to end" column in the sheet if you want a Timeline); Effort (2h 30m) as a Duration column; Owner as Text; Done (x or blank) as a Checkbox column.
13

A worked example, row by row

Eight signed clients onto a board that already has Status, Owner and Due date columns. The screenshots on this page are this paste.

You copy these columns: Company, Contact email, Contract value, Due, Onboarding period, Stage, Priority, Owner, Notes. The first row reads: Nordisk Bolig A/S, [email protected], 125.000,00 kr, 03/04/2026, 01.03.2026 to 14.03.2026, In progress, High, Mette Sørensen, "Wants the portal live before their spring campaign."

Copied columnWhat the window shows
CompanyItem name. The heading said so.
Contact email+ New column (Email). Chips: Email, Text. "All 8 values are email addresses."
Contract value+ New column (Number in DKK, 2 decimals). Chips: Number in DKK, Plain number, Text. "All 8 values are amounts in Danish kroner, written 1.000,00 style. The column will show them as kr 125,000.00."
DueDue date, the existing column. The row is amber: "These dates can be read two ways. 03/04/2026 is: 3 April (day first) / 4 March (month first)." Create stays off until you click one.
Onboarding period+ New column (Timeline). Chips: Timeline, Date with end date, Text. "Every cell holds two dates, read as day.month.year."
StageStatus, the existing column. "Matched to Status by its header. In progress, Waiting, On hold are not on Status yet and will be added as new labels." (This board started with Not started, Working on it, Stuck and Done.)
Priority+ New column (Priority, 3 levels). Chips: Priority, Dropdown, Status. "3 different values across 8 rows: High, Medium, Low. The labels are added to the new column in that order."
OwnerSkip this column. "Owner is a person column and cannot be filled from pasted text."
Notes+ New column (Long text). Chips: Long text, Text. "Average length is 98 characters and every cell holds full sentences."

You click 3 April (day first), glance at the preview, and click Create 8 items. The board gains five columns at its right end, Contact email, Contract value in kr, Onboarding period, Priority and Notes, with every cell filled, and the Status column gains the labels In progress, Waiting and On hold.

14

Limits and rules

Limit or ruleDetail
RowsUp to 100 rows go through at once. More than that and the window tells you it kept the first 100. For a whole spreadsheet, use the CSV and Excel wizard under Data Migration.
New columnsUp to 20 in one paste. Map the rest onto columns you already have, or paste twice.
Status and DropdownA value that is not on the column yet is added to it for you, and the row says which ones before you create.
PeopleNames are never matched to people. A column of names next to a People column is set to Skip, with the reason on the row, because a name in a spreadsheet is not the same thing as a person in your workspace. Send it to a Text or Dropdown column if you want to keep it.
Two date columnsA Start column and an End column stay two columns. To get a Timeline, write them as one column, "start to end".
FormulasWhat you copy out of a spreadsheet is the result, not the formula, so a calculated cell arrives as its value.
Access+ New column only appears if you have full access to the board. With edit access you can still fill the columns that already exist.
Plain listsOne name per line and nothing else still creates one item per line, with no window. A single line is pasted as the name.
Sub-itemsClick + Add subitem under an item and paste into that name box. The same window opens and the rows become sub-items of that item, filling the same board columns.
Where it worksEvery board group, including a group shown through a filtered or saved view, where the window adds a Target group dropdown.
15

Import history

Under the sources sits Import History: every import you have run, when, from where, and how many boards and items it created.

ResultWhat it means
CompletedEverything came across.
PartialSome rows could not be brought across. Open it: it lists which, and why, and the reason is nearly always a value that does not fit the column type chosen for it.
FailedThe run did not finish.
16

Notes and other kinds of import

Boards are not the only thing you can bring in. A notebook imports Word documents, Markdown, HTML, PDFs and OneNote notebooks straight into pages. That lives in the notebook itself rather than here. See Notebook.

Diagrams can be imported too, from draw.io and Visio files. See Diagrams (draw.io).

17

Common questions

Will importing overwrite my existing boards?
No. An import always creates new boards. It never merges into, or writes over, a board you already have.
What happens to people who are not in my Gript workspace?
Their names come across as text on the task rather than as real assignments. Invite them to Gript first if you want the assignments to be live.
Can I import the same board twice?
Yes, and you will get two boards. Delete the first attempt before you re-run it, or you will be tidying up afterwards.
Some rows did not come across.
Open the run in Import History. A partial run lists what was skipped, and the reason is nearly always a value that does not fit the column type chosen for it, for example free text mapped to a Number column.
How long does a big import take?
It depends on the number of items and files, but you do not have to sit and watch. Large imports continue in the background and the history row tells you when they finished.
Can I move boards between two Gript workspaces?
Yes, that is what Gript Bridge does. It reads boards from another Gript workspace and recreates them in this one.
The paste created one long list of names instead of columns.
The copy lost its column boundaries, which happens with some web pages. Copy the table again from the source, or include the header row so Gript can see the shape. Lines written as Name <email> and cells that arrived on alternating lines are recognised on their own.
Why is the Create button greyed out?
A row is still asking a question, usually how to read a column of dates. The footer names the column. Click one of the two chips under it and Create switches on.
My amounts lost their kr sign.
They were pasted into a Number column that is set to plain numbers. The row said so. Send that column to + New column instead and Gript creates a Number column formatted in kr, or change the format of your existing column under Edit column.
Gript picked Dropdown but I wanted Status.
Click the Status chip under that row. When the words are not obvious states like Done or In progress, Gript offers both and lets you choose.
A column came through empty.
Its values did not fit the column you chose, and the row said how many would be left empty. Pick a different column or + New column, and the preview fills in.
Can I paste the same sheet again to update the rows?
No. A paste always creates new items. Delete the first set before pasting again, or you will have both.
The window did not open, my paste went in as a name.
The copied text had no line breaks or tabs, so it was one value. Copy at least two rows, or a row with more than one column.
Can I paste into a specific group when I am looking at a filtered view?
Yes. The window shows a Target group dropdown at the top when the group you pasted into is a filtered or virtual one. Pick the real group and create.
Can I undo a paste?
The items are ordinary items: select them and delete, and they go to Trash. A column the paste created is removed with Delete column in its column menu.
Does it read my formulas?
It reads what the spreadsheet put on the clipboard, which is the calculated value. The formula itself does not come across.
Was this article helpful?