How to convert an Excel spreadsheet to accounting software

Step 1: understand what your spreadsheet actually holds

Before you move anything, open the sheet and look at it with fresh eyes. Most home-grown bookkeeping spreadsheets are really several different lists living in one file: a tab of customers, a tab of invoices, a running list of expenses, maybe a products or services list, and a summary tab with totals. Each of those is a separate thing in accounting software, so it helps to know which is which before you start.

Go through your tabs and label in your head what each one is:

• People you bill become customers.
• Things you sell become products or services.
• Money coming in becomes invoices or revenue.
• Money going out becomes expenses.

You don't need to do anything to the sheet yet. The point is just to know what you're working with, so that when the software asks "is this column a customer name or a product?" you already have the answer. A spreadsheet where you can't tell what a tab is for is a spreadsheet that will import into a mess, so this five-minute read-through saves time later.

Step 2: tidy the obvious problems

You don't need to reformat the whole thing. Good import tools handle messy, real-world sheets, including odd column names and columns in any order. But a few quick fixes make the import cleaner, and they take minutes:

• Give every column a header. The import reads your headers to figure out what each column is, so a column with no title in row one is a column it has to guess at. A plain label like "Customer", "Amount", or "Date" is enough.
• Put the data in a single block. One header row, then rows of data underneath, with no blank rows breaking it up and no notes floating off to the side. Stray cells and merged headers are the things most likely to confuse an import.
• Split lists onto their own tabs. If your customers and your expenses share one tab, separate them. You'll import each list on its own, so each wants to be its own clean table.
• Check your dates and amounts look like dates and amounts. A date typed as plain text, or an amount with a stray letter in it, can trip up the read. A quick scan down each column catches these.

What you do not need to do is rename your columns to match the software, reorder them, or strip out extra columns you don't need. A good importer maps your headers to its fields no matter what you called them or what order they're in, and lets you ignore the columns you don't want. Tidy the structure, not the wording.

Step 3: choose the software you are moving to

If you haven't already settled on a tool, pick one before you export, because the import step depends on it. The thing to check, specifically for this job, is how good the tool is at importing a spreadsheet. Plenty of accounting software can import a CSV, but the experience ranges from "drag the file in and review the mapping" to "match every column by hand through a fiddly wizard."

When you compare options, look for:

• Automatic column mapping. The tool reads your headers and proposes which field each column is, instead of leaving you to assign all of them manually.
• Tolerance for any column layout. It should cope with your columns named your way and in your order, not demand its own exact template.
• A review step before anything is saved. You want to see and adjust the mapping before it commits, not find out afterward.
• An undo. If the first import isn't right, you want to roll it back and try again in one click, not delete rows by hand.

If you're still weighing tools, our guide to the best free accounting software for small business covers the options and their trade-offs. Pick the one whose import you trust, since that's the part of the move you'll feel most.

Step 4: save your sheet as .xlsx or CSV

Accounting tools import spreadsheet files, which in practice means an Excel file (.xlsx) or a CSV. If you're working in Excel already, your file is .xlsx and you can often import it as-is. If your tool prefers CSV, or if your sheet has multiple tabs, save each list out separately.

To save a single tab as CSV in Excel: open the tab you want, choose File, then Save As, and pick "CSV (Comma delimited)" as the type. Excel saves the tab you're looking at, so if you have customers, invoices, and expenses on three tabs, you'll do this three times, once per tab, giving you three files. Name them clearly: customers.csv, invoices.csv, expenses.csv.

A couple of things worth knowing. CSV saves one tab at a time and drops your formulas, keeping only the values they produced, which is exactly what you want for an import. And CSV is plain text with no formatting, so colours and column widths don't carry over, which also doesn't matter, because the software only reads the data. If your tool takes .xlsx directly, you can skip the per-tab saving and import the workbook, but having clean single-list files never hurts.

Step 5: import and let the column mapping do the work

This is the step that replaces the retyping you were dreading. In a tool with a proper spreadsheet importer, you drag the file in, and the software reads your column headers and proposes a mapping: this column is the customer name, this one is the amount, this one is the date, and so on. You didn't have to match anything by hand, and your columns didn't have to be named or ordered the software's way.

This is exactly what the spreadsheet importer in Argo Books is built for. You drop in an Excel or CSV file, it reads whatever you called your columns and however you ordered them, and it maps them to the right fields, customers, products, invoices, expenses, or revenue, on its own. Messy real-world sheets and exports from other tools come in without reformatting. It handles Excel and CSV specifically, not arbitrary file types, so save your file as one of those first.

Import one list at a time. Start with customers, then products or services, then invoices, then expenses. Importing in that order means that when your invoices come in, the customers they belong to already exist, so everything links up instead of creating duplicates. If your tool lets you, do a small test first: import a handful of rows, confirm they land correctly, then bring in the rest.

Step 6: review the mapping before you commit

Automatic mapping is good, but it isn't telepathic, so look before you import. A solid importer shows you the proposed mapping and a preview of how the data will land, and lets you adjust before anything is saved. This is your chance to catch the small things that matter:

• Did each column map to the right field? If you had two date columns, an invoice date and a due date, make sure each went to the correct one rather than both landing on the same field.
• Are amounts going in as amounts? Check a tax or total column wasn't read as plain text, and that a negative or refund row came through with the right sign.
• Is anything you wanted to ignore being skipped? Extra columns like internal notes or a colour code can be left unmapped so they don't clutter your records.

Spend a minute here. Fixing the mapping before the import is one click; fixing hundreds of misfiled records afterward is an evening. Once the preview looks right, run the import. And because the whole thing has a one-click undo, if the result still isn't what you wanted, you roll it back and adjust, rather than hand-deleting rows. That undo is what makes it safe to try.

Step 7: check the totals and keep the old sheet as backup

The last step is the one that lets you trust the move. Take a few key totals from your spreadsheet and check them against the same totals in the software. Total revenue for the year, total expenses, the number of customers, the count of invoices. If your sheet says you billed forty-two invoices and the software shows forty-two, and the dollar totals match, the import is sound. If a number is off, the gap tells you what to look at: a tab you forgot to import, a few rows that didn't map cleanly, or a column read the wrong way.

This check matters because an import that looks fine but is quietly missing a tab will hand you wrong numbers at tax time. Five minutes matching totals now is what makes the difference between trusting your new books and second-guessing them.

Once the totals agree, don't delete the spreadsheet. Save a copy somewhere safe and leave it alone. It's your reference if you ever need to look something up the way it was, and your safety net if you spot something months later. Storage is free; re-creating a year of bookkeeping is not. Keep it archived, stop editing it, and do your new work in the software from here on.