Skip to content

Everything here

  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.