Skip to content

Plain steps for CSV exports and imports

Moving business data with CSV files

Plain steps for getting records out of one piece of software and into another. These notes cover exporting, cleaning, field mapping and importing CSV files. Each page explains the terms it uses.

Read this first Everything here

All the notes

  1. What a CSV file is and how it stores data

    A CSV file is plain text with one record per line and commas between fields. Here's what that means for the data you export from business software.

  2. A checklist for exporting your data before you switch software

    What to save from your old system before access ends, including records, history, file copies and tax-related data, and how to check each export.

  3. Field mapping explained: matching old columns to new fields

    How field mapping works in a CSV import, what happens to unmatched columns, and how to build a simple mapping table before you upload.

  4. Cleaning a CSV before you import it

    The common problems in CSV files that break imports or damage records, and a short order of checks to run before you upload.

  5. Fixing date, phone and number formats in a CSV

    Why dates, phone numbers and amounts often arrive wrong after a CSV import, and how to put each one in a form the new system can read.

  6. Testing an import with a small batch first

    How to try a CSV import on a handful of records, what to check afterward, and how to fix problems before loading the full file.