Imports and Spreadsheets

Use imports and spreadsheet sync when the best financial workflow is not a live institution connection alone. Some records are historical, private, manually maintained, or better reviewed in a spreadsheet model.

When to import data

Use imports for bounded offline data: historical account records, investment exports, private market records, statement periods, or files that should become part of the workspace without a live provider connection.

Imports work best when the file represents a clear slice of data:

• One source.
• One date range.
• One account or clearly separated accounts.
• Consistent currency and date formats.
• Stable identifiers when the source provides them.

If the same source changes frequently, consider provider sync or spreadsheet sync instead of repeatedly importing overlapping files.

Supported spreadsheet connections

Tablewealth supports these spreadsheet sync options:

• Google Sheets sync.
• Microsoft 365 Excel workbook sync.
• Local Excel sync through the Tablewealth add-in.

Google Sheets and Microsoft 365 syncs are self-serve in the product when the provider connection is available for your workspace. They create or update provider-hosted workbooks and do not count against API usage.

Local Excel sync uses the Tablewealth add-in inside the workbook open in Excel. See Local Excel Sync for installation, connection, refresh, and troubleshooting instructions. Local Excel sync usage counts against API usage.

Google Sheets sync

Google Sheets sync writes Tablewealth data into a Google workbook connected to your Google account. You connect Google from the Spreadsheet sync page, create a sync target, choose a template, and run the sync manually or on a schedule.

Google sync is useful when:

• You want a live planning model in Google Sheets.
• You want a workbook you can share through Google permissions.
• You want the guided Tablewealth Comprehensive Sheet.
• You want formulas, charts, and category helper columns to live in the sheet.

Reconnect Google if the page says Drive access needs attention.

Microsoft 365 Excel sync

Microsoft 365 sync writes Tablewealth data into an Excel workbook in OneDrive through the connected Microsoft account. Connect Microsoft from Spreadsheet sync, then create an Excel workbook sync target.

Microsoft 365 sync is useful when:

• Your household, team, or advisor workflow already runs in Excel.
• You want workbook files managed in OneDrive.
• You want a Microsoft 365 sharing and permissions model.
• You want current account, holding, and transaction tables in an Excel workbook.

The guided Tablewealth Comprehensive Sheet template is Google Sheets only. Microsoft 365 Excel sync supports workbook exports and templates that are configured for Excel.

Local Excel sync

Local Excel sync is for workflows where a local Excel file needs to be updated from Tablewealth data. Install the Tablewealth add-in, connect your workspace, then insert or refresh managed tables in the active workbook.

Follow the complete Local Excel Sync setup guide. If setup fails, email help@tablewealth.com with your Excel version, operating system, workspace name, and the step where the problem occurred.

Local Excel sync usage counts against API usage. Google Sheets and Microsoft 365 syncs do not count against API usage.

Spreadsheet sync targets

A sync target is one saved workbook destination. Each target has:

• Provider: Google Sheets or Microsoft Excel.
• Template: the workbook shape to create.
• Spreadsheet name: the workbook name used when the file is created.
• Asset scope: all accounts or selected accounts.
• Enabled sheets: accounts, holdings, transactions, or a template-defined set.
• Sync mode: latest values or history snapshots for accounts and holdings.
• Frequency: manual, as soon as updates are available, daily, weekly, or monthly depending on the plan and configuration.
• Internal note: optional context that stays inside Tablewealth and is not written into the spreadsheet.

You can create multiple targets for different workflows. For example, one Google Sheet can be a personal review workbook while another Excel workbook is built for an advisor meeting.

Workbook consoles

Each synced workbook has a console in Tablewealth. Use it to review the workbook setup, open the spreadsheet, check net worth summary values, confirm linked account scope, run auto-categorization, sync the workbook, inspect sync diagnostics, and archive or restore the workbook link.

The console separates app-side cleanup from workbook delivery. Categorize transactions, manage tags, add manual transactions, or update rules in Tablewealth first, then sync the workbook so the spreadsheet receives the latest decisions.

Auto-categorization

Auto-categorization runs active Tablewealth transaction rules against uncategorized transactions. From a workbook console, the run is scoped to that workbook's selected accounts when the workbook uses a custom account scope. After matching transactions are updated, Tablewealth can start a workbook sync so the sheet receives those category decisions.

Use Categories & rules when you want to create, pause, or delete rules. Use Auto-categorize when you want to apply the current rule set to recent uncategorized activity.

Archived workbooks and accounts

Archive a workbook when you want to keep the link visible for historical access but stop scheduled syncs. Archived workbooks remain openable from Spreadsheet sync and can be restored later.

Archive an account when it should stay in history but stop cluttering active workflows. Archived accounts are preserved, hidden from default spreadsheet account selection, and excluded from the default transactions view.

Templates

Spreadsheet templates decide what tabs the workbook starts with.

Current Assets & Transactions creates clean current tables for accounts, holdings, and transactions. Use it when you want current source data without extra formula-driven views.

Raw Data Export creates raw account, holding, and transaction tables for downstream analysis. It is useful when the spreadsheet is a staging area for your own model.

Tablewealth Comprehensive Sheet creates a guided Google Sheets workbook with summary, trend, category, and rule tabs. Use it when you want a ready-to-use workbook after the first sync.

Custom Template lets you choose the enabled tables and workbook tab names yourself when advanced spreadsheet sync is available.

App-managed and safe-to-edit tabs

In the Tablewealth Comprehensive Sheet, some tabs are managed by sync and some are safe for you to edit.

App-managed tabs include:

• Transactions Raw: synced transactions plus helper columns.
• Balances Raw: synced balance history used by trend formulas.
• Holdings Current: synced current positions.

Do not edit app-managed source columns. The next sync may replace them. In transaction sheets, the Category and Notes columns can be preserved depending on the target's transaction mode.

Safe-to-edit or working tabs include:

• Summary.
• Monthly Cash Flow.
• Net Worth Trend.
• Categories.
• Rules.
• Settings.

Use these tabs for your model, review workflow, category setup, and spreadsheet-side rules.

Spreadsheet-side categories

The Comprehensive Sheet includes a Categories tab. This is a spreadsheet-side category list used by the workbook formulas. Editing it changes how the spreadsheet views organize the synced data. It does not rewrite Tablewealth app categories or provider categories.

The starter categories include common groups such as Housing, Utilities, Groceries, Dining, Transportation, Shopping, Travel, Income, and Transfer. You can add, rename, hide, or regroup rows in the spreadsheet if your model needs a different shape.

Use spreadsheet categories when the categorization is mainly for that workbook. Use app categories when you want Tablewealth transactions, dashboards, exports, and future synced records to share the same workspace-level category.

Spreadsheet-side rules

The Comprehensive Sheet includes a Rules tab. Rules assign a spreadsheet-side category to rows in Transactions Raw.

Each rule row can match:

• Category: the category to return when the rule matches.
• Description Contains: text to search across the transaction name, merchant name, and original description.
• Account Contains: text to search in the account name.
• Institution Contains: text to search in the institution name.
• Amount Min: the smallest transaction amount that should match.
• Amount Max: the largest transaction amount that should match.

Blank match fields are ignored. A rule with only Description Contains will match any transaction whose description text contains that value. A rule with Description Contains plus Amount Min and Amount Max must satisfy all of those conditions.

Rules are evaluated from the editable rules range. When more than one rule matches, the formula returns the last matching rule in the range. Put more specific rules lower in the list when they should override broader starter rules.

Spreadsheet rules affect the workbook's helper category columns. They do not create app-side categorization rules. To create app-side rules, edit a transaction category in the Transactions table and choose Create rule when Tablewealth suggests one.

Sync modes

Latest values keeps account and holding sheets trimmed to the current state each time sync runs. Use it when the workbook only needs the latest balances and positions.

All values with As Of dates keeps account and holding snapshots from each sync. Use it when you want to compare balances or positions across time.

Transactions use a separate transaction mode:

• Preserve sheet edits refreshes source transaction fields while keeping sheet edits in Category and Notes.
• Prefer Sheets keeps posted rows as they are in the sheet and appends new transactions. Pending rows may still refresh until they post.
• Prefer Tablewealth App replaces transaction rows with the latest values from Tablewealth on every sync.

Schedules, update-triggered sync, and manual runs

A sync can be manual, update-triggered, or recurring. Manual syncs run when you click Run now or Sync data. Recurring syncs are scheduled by the product and show the next run time on the sync target when available.

Use As soon as updates are available when the workbook should refresh after Tablewealth receives new account, holding, or transaction updates from a connected financial source. This is the closest spreadsheet sync mode to real-time: Tablewealth listens for source updates, refreshes workspace data, then starts a workbook sync for matching spreadsheet targets.

The timing still depends on the source. If a bank, brokerage, or data provider has not made new data available yet, the spreadsheet will not show it simply because the workbook is set to update-triggered sync. When a provider sends an update webhook or a deferred provider refresh completes, Tablewealth can push the latest available workspace data into the spreadsheet.

Use manual sync when a workbook only needs to be refreshed before a review. Use daily, weekly, or monthly sync when the workbook is part of a recurring workflow but does not need to refresh immediately after source updates arrive.

Mapping and formatting

Before importing or syncing, make sure dates, amounts, account names, and category columns are consistent. Good spreadsheet inputs and outputs have:

• One header row.
• Stable column names.
• Consistent date formats.
• Consistent currency formats.
• No merged cells inside synced ranges.
• One purpose per sheet.

If a source column has mixed meaning, split it before mapping. For example, separate account name from institution name, or convert separate debit and credit columns into one signed amount.

After an import or sync

Review the result before trusting a report:

• Confirm row count.
• Review date range.
• Check the largest positive and negative amounts.
• Confirm account assignment.
• Confirm the workbook opened in the expected provider.
• Check whether the sync target is using all accounts or selected accounts.
• Check the enabled sheets and sync mode.
• Look for duplicate transactions near the start and end dates.
• Review categories before using the data in dashboards.

If a Google or Microsoft sync fails, reconnect the provider account and run the sync again. If a local Excel workflow fails or is not available in your workspace, email help@tablewealth.com.