{"id":8,"date":"2026-04-16T10:34:00","date_gmt":"2026-04-16T10:34:00","guid":{"rendered":"https:\/\/wisegrid.co\/blog\/how-to-migrate-off-smartsheet\/"},"modified":"2026-06-10T16:23:16","modified_gmt":"2026-06-10T16:23:16","slug":"how-to-migrate-off-smartsheet","status":"publish","type":"post","link":"https:\/\/wisegrid.co\/blog\/how-to-migrate-off-smartsheet\/","title":{"rendered":"How to Migrate Off Smartsheet (2026 Step-by-Step)"},"content":{"rendered":"<p><em>By <a href=\"\/blog\/author\/ryan-kramer\/\">Ryan Kramer<\/a>, founder of Wisegrid. Last updated June 2026.<\/em><\/p>\n<p>The hardest part of leaving Smartsheet isn\u2019t deciding to leave \u2014 it\u2019s the fear that the move will quietly break something. Lost formulas, dropped attachments, flattened column types, a hierarchy that comes out as a flat list. That fear is rational, because Smartsheet\u2019s <em>own<\/em> export loses a lot of that data. This guide shows you the manual path (so you know what you\u2019re avoiding) and the one-click path with Wisegrid\u2019s importer (so you don\u2019t have to).<\/p>\n<blockquote>\n<p><strong>Key takeaways<\/strong> \u2013 <strong>Manual export is lossy by design:<\/strong> Smartsheet\u2019s export drops formulas to values, excludes attachments\/groupings\/summary rows, flattens special column types to text, and turns Gantt into a flat task list. \u2013 <strong>One thing it keeps:<\/strong> comments (on separate tabs) \u2014 don\u2019t believe guides that claim otherwise. \u2013 <strong>The importer path:<\/strong> paste a read-only token, and Wisegrid mirrors sheets, rows, columns, formulas (translated), attachments, hierarchy, and cross-sheet references. \u2013 <strong>Nothing changes silently:<\/strong> anything the formula translator can\u2019t convert lands in a visible review queue. \u2013 <strong>Not imported yet:<\/strong> Reports, Dashboards, Forms, Automations \u2014 surfaced with \u201cnotify me,\u201d never dropped without warning.<\/p>\n<\/blockquote>\n<nav class=\"wg-toc\" aria-label=\"Table of contents\"><div class=\"wg-toc-eyebrow\"><span class=\"lp-dot\" aria-hidden=\"true\"><\/span> On this page<\/div><ul>\n<li><a href=\"#why-manual-migration-is-risky\">Why manual migration is risky<\/a><\/li>\n<li><a href=\"#what-smartsheets-own-export-drops\">What Smartsheet\u2019s own export drops<\/a><\/li>\n<li><a href=\"#the-fast-path-wisegrids-smartsheet-importer\">The fast path: Wisegrid\u2019s Smartsheet importer<\/a><\/li>\n<li><a href=\"#step-by-step-migration\">Step-by-step migration<\/a><\/li>\n<li><a href=\"#what-gets-imported-and-what-doesnt-yet\">What gets imported (and what doesn\u2019t, yet)<\/a><\/li>\n<li><a href=\"#how-formulas-are-handled\">How formulas are handled<\/a><\/li>\n<li><a href=\"#migration-checklist\">Migration checklist<\/a><\/li>\n<li><a href=\"#faq\">FAQ<\/a><\/li>\n<\/ul><\/nav>\n<h2 id=\"why-manual-migration-is-risky\">Why manual migration is risky<\/h2>\n<p>The manual route is: export each sheet to Excel or Google Sheets, then re-import elsewhere. The problem is that a Smartsheet export is lossy by design, so you spend days rebuilding the parts that didn\u2019t survive \u2014 and you can\u2019t always tell what silently changed.<\/p>\n<h2 id=\"what-smartsheets-own-export-drops\">What Smartsheet\u2019s own export drops<\/h2>\n<p>Per Smartsheet\u2019s own documentation, exporting a sheet to Excel\/Google Sheets:<\/p>\n<ul>\n<li><strong>Doesn\u2019t preserve formulas<\/strong> \u2014 <em>\u201cFormulas aren\u2019t preserved due to the differences between Excel and Smartsheet formula syntax.\u201d<\/em> You get computed values, not the formulas behind them.<\/li>\n<li><strong>Excludes attachments, groupings, and summary rows<\/strong> \u2014 <em>\u201cThe following items are excluded from exports: Groupings, Summary rows, Attachments.\u201d<\/em><\/li>\n<li><strong>Flattens special column types to plain text<\/strong> \u2014 dropdowns, contact lists, checkboxes, and symbol (RYG) columns export as text only.<\/li>\n<li><strong>Turns Gantt into a flat list<\/strong> \u2014 <em>\u201cExporting a Gantt chart to Excel exports only the task list it\u2019s based on.\u201d<\/em><\/li>\n<\/ul>\n<p>One thing the export <em>does<\/em> keep: comments and sheet summaries land on separate tabs, so don\u2019t believe any guide that tells you Smartsheet drops comments on export \u2014 it doesn\u2019t. But losing your formulas, files, column types, and Gantt is more than enough to make a manual move painful. For the full inventory of what survives versus what\u2019s lost, see <a href=\"\/blog\/smartsheet-export-what-you-lose\">What Smartsheet\u2019s export actually loses<\/a>.<\/p>\n<h2 id=\"the-fast-path-wisegrids-smartsheet-importer\">The fast path: Wisegrid\u2019s Smartsheet importer<\/h2>\n<p>Wisegrid\u2019s importer exists precisely to avoid that loss. Instead of exporting lossy files and rebuilding, you connect Smartsheet directly with a read-only API token, and Wisegrid <strong>mirrors<\/strong> your workspace \u2014 translating formulas instead of dropping them, carrying over attachments, hierarchy, and cross-sheet references instead of flattening them.<\/p>\n<p>The core promise: <strong>nothing changes silently.<\/strong> Anything the importer can\u2019t translate is surfaced in a review queue, so you always know what needs a human look.<\/p>\n<p>And the workspace it mirrors into has more headroom than the one you\u2019re leaving: <strong>1,000,000 cells per sheet \u2014 more than 2\u00d7 Smartsheet\u2019s 500K \u2014 at the same $9 Pro \/ $19 Business pricing.<\/strong> You\u2019re not just escaping a lossy export; you\u2019re landing on a bigger grid for the same money.<\/p>\n<p><a href=\"\/migrate\">Start a migration \u2192<\/a><\/p>\n<h2 id=\"step-by-step-migration\">Step-by-step migration<\/h2>\n<h3 id=\"1-sign-up-for-wisegrid\">1. Sign up for Wisegrid<\/h3>\n<p>Create an account (Google sign-in or email\/password). You can start on the free tier to test a migration before committing.<\/p>\n<h3 id=\"2-get-a-smartsheet-api-token\">2. Get a Smartsheet API token<\/h3>\n<p>In Smartsheet, generate a personal API access token from your account settings. Wisegrid uses it <strong>read-only<\/strong> \u2014 it discovers and copies your data; it doesn\u2019t modify your Smartsheet. The token is stored encrypted.<\/p>\n<h3 id=\"3-paste-the-token-into-the-importer\">3. Paste the token into the importer<\/h3>\n<p>In Wisegrid, open <strong>Import from Smartsheet<\/strong> and paste the token. Wisegrid validates it and then <strong>discovers your full landscape<\/strong> \u2014 workspaces, folders, and sheets \u2014 and presents them as a checkbox tree with row counts and storage estimates.<\/p>\n<figure><img decoding=\"async\" src=\"\/blog\/wp-content\/uploads\/2026\/06\/importer-landing.png\" alt='Wisegrid \"Import from Smartsheet\" connect screen, where you paste a read-only Smartsheet API token to start discovering your workspaces, folders, and sheets' loading=\"lazy\"><figcaption>The connect step: paste a read-only Smartsheet API token and Wisegrid discovers your landscape.<\/figcaption><\/figure>\n<h3 id=\"4-pick-what-to-migrate\">4. Pick what to migrate<\/h3>\n<p>Check the workspaces, folders, and sheets you want. Reports, Dashboards, Forms, and Automations appear in the tree but are shown as not-yet-importable, with a <strong>\u201cNotify me when ready\u201d<\/strong> option so you\u2019re never guessing what\u2019s pending.<\/p>\n<h3 id=\"5-confirm-capacity\">5. Confirm capacity<\/h3>\n<p>Before the job starts, Wisegrid shows a summary \u2014 <em>\u201cX workspaces, Y sheets, Z rows, W attachments \u2014 uses about A GB of your N GB storage\u201d<\/em> \u2014 and checks whether the attachments fit your tier. If they\u2019d overflow, you\u2019re prompted to upgrade or deselect oversized sheets, <strong>before<\/strong> anything runs (so a migration never half-fails on storage).<\/p>\n<h3 id=\"6-run-the-migration\">6. Run the migration<\/h3>\n<p>A background worker imports in two passes: first it creates all your sheets, then it resolves cross-sheet references once every sheet exists (this handles references that point at each other, which a naive one-pass import can\u2019t). Per-sheet progress streams to the screen.<\/p>\n<h3 id=\"7-review-the-completion-report\">7. Review the completion report<\/h3>\n<p>When it finishes you get a report like <em>\u201c\u2713 14 sheets, 4,863 rows imported. 8 items need manual review.\u201d<\/em> Click through to the review queue to see each formula the translator couldn\u2019t auto-convert, with the <strong>original Smartsheet syntax<\/strong>, a <strong>best-guess Wisegrid translation<\/strong>, and an edit field. You fix the handful that need it \u2014 and you can see exactly which ones, instead of trusting that everything came over clean.<\/p>\n<figure><img decoding=\"async\" src=\"\/blog\/wp-content\/uploads\/2026\/06\/formula-review-queue.png\" alt=\"Wisegrid migration-complete report showing 4,863 rows imported across 14 sheets, with 5 formulas, 2 columns, and 1 cell flagged for manual review in the translation queue\" loading=\"lazy\"><figcaption>A real migration-complete report: 4,863 rows across 14 sheets, with only 8 items flagged for review \u2014 each shown with its original Smartsheet syntax and a suggested Wisegrid translation.<\/figcaption><\/figure>\n<p>Here\u2019s what that looked like on a test migration we ran end-to-end through the importer: <strong>4,863 rows across 14 sheets<\/strong> mirrored over with <strong>attachments preserved<\/strong>, and the translator auto-converted everything except <strong>5 formulas, 2 columns, and 1 cell<\/strong> \u2014 eight items total \u2014 which it surfaced in the review queue with the original syntax and a suggested translation. That\u2019s the whole point: instead of trusting that thousands of cells came over clean, you get a short, explicit list of what needs a second look.<\/p>\n<h2 id=\"what-gets-imported-and-what-doesnt-yet\">What gets imported (and what doesn\u2019t, yet)<\/h2>\n<div class=\"wg-table-wrap\"><table>\n<thead>\n<tr>\n<th>Imported today<\/th>\n<th>Not imported yet (waitlisted in the tree)<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Workspaces \u2192 Projects<\/td>\n<td>Reports<\/td>\n<\/tr>\n<tr>\n<td>Folders \u2192 Folders<\/td>\n<td>Dashboards<\/td>\n<\/tr>\n<tr>\n<td>Sheets (rows, columns, cells)<\/td>\n<td>Forms<\/td>\n<\/tr>\n<tr>\n<td>Formulas (translated to Wisegrid syntax)<\/td>\n<td>Automations \/ workflows<\/td>\n<\/tr>\n<tr>\n<td>Attachments<\/td>\n<td>Comments \/ discussions<\/td>\n<\/tr>\n<tr>\n<td>Row hierarchies<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Cross-sheet references (translated)<\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<p>The not-yet-imported items aren\u2019t dropped silently \u2014 they\u2019re shown in the discovery tree with a \u201cnotify me\u201d capture so you know what\u2019s still on Smartsheet and get told when it\u2019s supported.<\/p>\n<h2 id=\"how-formulas-are-handled\">How formulas are handled<\/h2>\n<p>This is the part that makes or breaks a migration. Smartsheet\u2019s formula syntax differs from standard spreadsheet syntax \u2014 column references like <code>[Column Name]@row<\/code>, cross-sheet references as <code>{Reference Name}<\/code> objects. Wisegrid\u2019s importer:<\/p>\n<ol>\n<li><strong>Parses<\/strong> the Smartsheet formula into a structured form.<\/li>\n<li><strong>Translates<\/strong> it to Wisegrid syntax. Same-row column references stay the same <code>[Column]@row<\/code> same-row syntax as Smartsheet \u2014 nothing to relearn, and the importer brings it across unchanged. Cross-sheet references become Wisegrid\u2019s inline form: you type <code>[Sheet]!A1<\/code> inline (autocomplete as you type <code>[<\/code>), with no reference-picker modal and no 100-cross-reference-per-sheet cap.<\/li>\n<li><strong>Surfaces failures<\/strong> \u2014 anything it can\u2019t translate goes to the manual review queue with the original and a suggested translation, rather than producing a silently wrong value.<\/li>\n<\/ol>\n<p>That last point is the difference from a lossy export: instead of formulas becoming static values you have to rebuild blind, you get a short, explicit list of the few that need attention. If you want to see how specific Smartsheet functions map across before you migrate, the <a href=\"\/blog\/smartsheet-formulas-translation-guide\">Smartsheet formula translation guide<\/a> walks through the common ones (and the handful, like <code>LET<\/code>\/<code>LAMBDA<\/code>, that aren\u2019t supported yet).<\/p>\n<h2 id=\"migration-checklist\">Migration checklist<\/h2>\n<ul>\n<li><input type=\"checkbox\" disabled> Created a Wisegrid account<\/li>\n<li><input type=\"checkbox\" disabled> Generated a read-only Smartsheet API token<\/li>\n<li><input type=\"checkbox\" disabled> Pasted the token and reviewed the discovered landscape<\/li>\n<li><input type=\"checkbox\" disabled> Selected the workspaces\/sheets to migrate<\/li>\n<li><input type=\"checkbox\" disabled> Confirmed attachments fit your storage tier<\/li>\n<li><input type=\"checkbox\" disabled> Ran the migration and watched per-sheet progress<\/li>\n<li><input type=\"checkbox\" disabled> Reviewed the completion report and cleared the formula review queue<\/li>\n<li><input type=\"checkbox\" disabled> Spot-checked a few key sheets against the originals<\/li>\n<li><input type=\"checkbox\" disabled> Noted which items (Reports\/Dashboards\/Forms\/Automations) are still on Smartsheet via the waitlist<\/li>\n<\/ul>\n<h2 id=\"faq\">FAQ<\/h2>\n<h3 id=\"will-i-lose-my-formulas-migrating-from-smartsheet\">Will I lose my formulas migrating from Smartsheet?<\/h3>\n<p>Not with the importer \u2014 it translates them and shows you any it couldn\u2019t convert in a review queue. (By contrast, Smartsheet\u2019s own export to Excel drops formulas to values-only \u2014 see <a href=\"\/blog\/smartsheet-export-what-you-lose\">what Smartsheet\u2019s export actually loses<\/a>.)<\/p>\n<h3 id=\"does-the-importer-change-my-smartsheet-data\">Does the importer change my Smartsheet data?<\/h3>\n<p>No. It uses a read-only API token to copy your data into Wisegrid. Your original Smartsheet stays untouched, so you can migrate without burning any bridges.<\/p>\n<h3 id=\"how-long-does-migration-take\">How long does migration take?<\/h3>\n<p>Most workspaces mirror in minutes; very large ones with many attachments take longer. Progress streams per sheet, and the job is built to resume cleanly if interrupted.<\/p>\n<h3 id=\"what-about-reports-dashboards-forms-and-automations\">What about Reports, Dashboards, Forms, and Automations?<\/h3>\n<p>These aren\u2019t imported yet. They show up in the discovery tree with a \u201cnotify me\u201d option. Wisegrid has shipped its own Forms, Gantt, and Automations \u2014 you\u2019d rebuild those natively (and tell us to prioritize the importer support via the waitlist).<\/p>\n<h3 id=\"can-i-try-a-migration-before-paying\">Can I try a migration before paying?<\/h3>\n<p>Yes \u2014 start on the free tier, run a migration, and see your actual sheets before deciding.<\/p>\n<hr>\n<h3 id=\"migrate-in-minutes-not-days\">Migrate in minutes, not days<\/h3>\n<p>Paste a Smartsheet token and watch your workspace mirror over \u2014 formulas translated, attachments and hierarchy intact, at the same price you already pay.<\/p>\n<p><strong><a href=\"\/migrate\">Start your migration \u2192<\/a><\/strong> \u00b7 <a href=\"\/signup\">Start free \u2192<\/a> \u00b7 <a href=\"\/blog\/wisegrid-vs-smartsheet\">Wisegrid vs Smartsheet \u2192<\/a><\/p>\n<hr>\n<blockquote>\n<p><strong>About the author<\/strong> <strong><a href=\"\/blog\/author\/ryan-kramer\/\">Ryan Kramer<\/a><\/strong> is the founder of Wisegrid, a higher-capacity Smartsheet alternative built around a 1,000,000-cell-per-sheet grid, conflict-safe collaboration, and a one-click Smartsheet importer. He built Wisegrid out of first-hand experience hitting the walls in Smartsheet\u2019s grid, pricing model, and capacity limits, and writes about leaving Smartsheet without losing your data. <a href=\"\/blog\/author\/ryan-kramer\/\">More from Ryan \u2192<\/a><\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>A practical guide to migrating off Smartsheet without losing formulas, attachments, or hierarchy. Use Wisegrid&#8217;s one-click importer \u2014 paste a token, mirror your workspace.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-8","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/posts\/8","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/comments?post=8"}],"version-history":[{"count":4,"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/posts\/8\/revisions"}],"predecessor-version":[{"id":43,"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/posts\/8\/revisions\/43"}],"wp:attachment":[{"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/media?parent=8"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/categories?post=8"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/tags?post=8"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}