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.
All the notes
- 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.