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 with access enabled by Tablewealth.

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 is also supported, but access is not self-serve. Email help@tablewealth.com to get access. 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. It requires Tablewealth to enable access for your workspace.

Email help@tablewealth.com if you need local Excel sync. Include the workspace name, the kind of workbook you are maintaining, and whether the workflow is for personal use, a family office, an advisor workflow, or another team process.

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, 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.

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.

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 stay current separately. Transaction sync refreshes the current transaction export rather than appending every historical snapshot of the same transaction row.

Schedules and manual runs

A sync can be manual 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 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.

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.