Everything here
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.