Skip to article

Import or export balance history

Updated Nov 17, 2026Updated Nov 17, 2026

Bring past balances, property values, and debts into Net Worth from a spreadsheet. Add the accounts and assets first so you can match each column to the right one.

Import your spreadsheet

On Net Worth, select the three dots beside Search accounts, then Import historical values.

Load your history screen with options to upload a file, paste a spreadsheet, or download a template.

  1. Upload a CSV or TSV file, or paste cells from your spreadsheet. You can also download the template with your accounts already listed.
  2. Confirm the dates and match each column to an account, asset, or debt.
  3. Choose Merge to add or update values while keeping the rest of your saved history. Choose Replace to clear saved values missing from the file between the first and last imported dates for each matched field.
  4. Review the preview, then select Import (or Apply changes if entries will be removed) to save the ready values.

Important

Leave a cell blank when you’re not providing a value for that date. Enter 0 when the balance was zero. An entry dated today also updates the current balance.

Export history

Open the same three-dot menu and select Export history. Choose the accounts and layout, then select Download CSV or Copy. Save any changes in Edit history first so the export includes them.

A history export contains your balance records. For a copy that also includes your plans and settings, back up your data.

If something looks off

The dates or amounts look wrong

Use Date format and Number format to match your spreadsheet. Adjust layout helps when dates and accounts have been read from the wrong rows or columns.

Some values weren’t imported

Look at the flagged cells in the preview. Import the ready values, then resolve those cells for another pass. For a few individual changes, edit past balances directly.

Next: Update your current balances

Need a hand?

Try it in your own plan

Simulate your financial future and chart a course toward your best life.

Disclaimer: The content, tools, and resources on ProjectionLab.com are intended solely for informational and educational purposes and should not be construed as professional financial or investment advice. Our materials are designed to provide general guidance and are based on the input and data provided by users. ProjectionLab makes no guarantee of the accuracy, completeness, or applicability of this content to individual circumstances. Effective financial planning and investment involve comprehensive consideration of a wide array of personal financial factors. The tools and resources available on ProjectionLab are aimed at helping users develop an understanding of their financial trajectory. However, they should not be solely relied upon for creating a complete financial plan. We strongly recommend consulting a financial services professional who can provide personalized advice based on your unique financial situation before making any significant financial decisions. While we endeavor to keep the information on ProjectionLab current and accurate, the content may differ from that found on other financial institutions, service providers, or specific product sites. All content and tools on ProjectionLab are provided without any guarantees or warranties of any kind.