skarbfolioOpen app
Getting Started
  • What is Skarbfolio?
  • Adding your first account
Accounts
  • How to add an account
  • How to edit or rename an account
  • How to archive an account
  • Zero-balance vs. archived accounts
Holdings & Transactions
  • How to add a holding
  • How to add a transaction
  • How to edit or delete a transaction
  • How to archive a holding
  • Editing a custom asset
  • Setting up a dividend schedule
Importing Data
  • Importing from Interactive Brokers
  • Importing from an Excel (XLSX) file
Asset Types
  • Tracking stocks
  • Tracking government bonds
  • Tracking crypto addresses
  • Custom assets
Activity & Income
  • Understanding the Activity feed
  • How income is calculated
Analytics
  • Reading the analytics dashboard
  • How net worth and charts are calculated
Settings
  • Connecting Interactive Brokers for live sync
  • Using the MCP connector
  • Billing & subscription
  • Changing language and currency
  • Debt payment reminders
  • Changing the theme
  • Deleting your account
Help & FAQ

Importing from an Excel (XLSX) file

If your broker doesn't have a dedicated import, you can bulk-import transactions from a spreadsheet. Accounts and assets are created automatically from the file — there's no separate account-selection step.

  1. Go to Holdings and click Import XLSX.
  2. Step 1 — download the template: one sheet of transactions, one row per BUY / SELL / DEPOSIT / COUPON / etc., with sample rows and column docs inside.
  3. Step 2 — fill it in and upload the file (up to 5 MB).
  4. Click Import.

You'll see a summary of imported transactions, new accounts created, matched rows, and any duplicates skipped — plus details on any rows that were skipped.

Importing is a Pro feature — see Billing & subscription if you need to upgrade.

Tips

  • Keep one row per transaction for the cleanest import — the template's sample rows show the expected format.
  • Run a small test file first if you're unsure about column formatting — it's easier to fix a few rows than a few hundred.
  • For stocks outside the US, fill the optional exchange column (LSE, Xetra, Euronext, Euronext Paris) or add a suffix to the ticker (VWRA.L). Left blank, Skarbfolio picks the listing that trades in the row's currency — and lists any ticker it had to choose for, so you can change the exchange if it guessed wrong.