CSV & Excel Guides
Everything you need to know about working with CSV files, Excel spreadsheets, and data imports. Learn best practices, avoid common pitfalls, and master data preparation.
Guides for your role
Curated guides specifically for your industry or role.
CSV Basics
Essential concepts every user should know
What Is a CSV File?
Learn what CSV files are, how they work, and why they are commonly used for importing and exporting data.
CSV Import Guide
Learn how to prepare CSV files and avoid common problems when importing data.
CSV & Data Import Glossary
Plain-English definitions of CSV and data import terms, from delimiters and encoding to ISO 8601 and E.164.
CSV Delimiter Guide
CSV import failing? Learn what delimiters are and how to fix comma, tab, semicolon, and pipe problems.
CSV Header Naming Best Practices
Learn how to name your column headers to guide users, reduce errors, and enforce data validation when collecting spreadsheet data.
Using Sample Rows to Guide Data Format
Learn how to include sample data rows in your CSV template to show users exactly what format you expect, and how to protect and remove them.
CSV
Data cleaning and formatting techniques
How to Export Google Sheets to CSV Without Breaking Your Data
Download a sheet as CSV with dates your system reads, leading zeros and long IDs kept, and accents that survive Excel.
Shopify Product CSV Import Errors and How to Fix Them
Why Shopify product imports fail or split variants, lose images and change barcodes, with the fix for each.
WooCommerce Product CSV Import Errors and How to Fix Them
Why WooCommerce skips rows, loses variations or images, splits categories or garbles accents, with the fix for each and a variable product example.
Product Variants in a CSV: How Shopify, WooCommerce and Squarespace Lay Them Out
How sizes and colours are laid out across rows in each platform's product CSV, with side-by-side examples and the mistakes that break imports.
Google Merchant Center Product Feed: Required Attributes and File Format
The attributes Merchant Center needs and their formats, why to use TSV or Google Sheets instead of CSV, and the mistakes behind most disapprovals.
How to Collect Product Data from Suppliers Without Spreadsheet Chaos
What to ask suppliers for, from SKUs and barcodes to variants, prices and images, the mistakes that break product imports, and how to collect it in one format.
Moving Tenant and Lease Data to New Property Management Software
Import order, the errors that get rows rejected and a checklist for moving properties, owners, tenants and leases into DoorLoop, Buildium or TenantCloud.
How to Collect Tenant, Lease and Unit Details When Taking On a New Property
What to ask an owner or outgoing manager for, from units and owners to leases, balances and documents, and the mistakes that lead to wrong rent charges.
Moving Contacts to a New Real Estate CRM
Exporting, assigned agents, stages, dates, duplicates and consent when moving contacts between Follow Up Boss, BoldTrail (kvCORE) and Lofty.
How to Bring a New Agent's Contacts into Your Brokerage CRM
Getting a joining agent's sphere and past clients out of their old CRM, iPhone, Android or Google Contacts, what to ask for, and the mistakes that leave contacts unassigned or merged.
Moving Products and Stock into New Inventory Software
Import order, the one-time opening stock import, and the CSV mistakes that create duplicates or lose data in Unleashed, Cin7 Core and inFlow.
Wholesale Price Tiers, Minimum Orders and Pack Sizes in a CSV
Price tiers, customer-specific prices, minimum quantities and pack sizes in Unleashed, Cin7 Core and inFlow, and the pricing mistakes that cost margin.
Shipping Label CSV Upload Errors: Shippo, ShipStation and Pirate Ship
Split addresses, country codes, ZIP codes that lost their zeros, units in weight cells and merged orders, with the fix for each.
Bill of Materials CSV Import: Katana, MRPeasy and Fishbowl
One row per component, multi-level products, items that must exist first, units and the errors that stop a BOM import.
HubSpot CSV Import Errors and How to Fix Them
Why HubSpot imports create duplicates, skip dropdown values or get dates wrong, with the fix for each.
Moving Contacts Between CRMs
Keeping contacts, companies and deals linked, plus owners, stages, dates and duplicates, when moving between HubSpot, Salesforce, Pipedrive and Zoho CRM.
Zoho CRM Import Errors and How to Fix Them
How to import contacts into Zoho CRM, and why rows are skipped, contacts duplicated or accounts left unlinked, with the fix for each.
Procore Budget Import Errors and How to Fix Them
How to import a budget into Procore: the Excel template, cost codes and cost types, Manual Calculation, amounts and the 500-line limit.
Email List CSV Import Errors: Mailchimp, Klaviyo and Brevo
Rejected addresses, missing contacts, phone numbers in the wrong country, broken tags and consent, with the fix for each.
Facebook Vehicle Catalog Feed Errors and How to Fix Them
Duplicate vehicle IDs, price format, VIN length, mileage, body styles, Marketplace rules, descriptions, images and addresses, with the fix for each.
Commercial Invoice and Packing List Errors That Hold Up Customs
HS codes losing zeros, vague descriptions, country names, origin vs ship-from, mixed currencies and units, totals rows and mismatched quantities, with the fix for each.
Why Franchise Sales Reports Don't Combine, and How to Fix Them
Store IDs written differently, overlapping periods, gross vs net, sales tax, amounts as text, renamed columns, totals rows and duplicate reports, with the fix for each.
Statement of Values and Vehicle Schedule Errors
Values written as text, totals rows, freehand construction types, decades for years, lost ZIP zeros, wrong-length VINs and duplicate vehicles, with the fix for each.
Event Attendee Import Errors in Zoom and Check-In Tools
Missing import buttons, column order, header rows, duplicate guests, ticket types, country codes and file limits, with the fix for each.
Donor Import Errors in Givebutter and Bloomerang
Import order, matching donors, duplicates, addresses, country codes, ZIP codes, payment methods and file limits, with the fix for each.
QuickBooks Online CSV Import Errors and How to Fix Them
Why QuickBooks won't import your customer or supplier list: the 1,000-row limit, duplicate names, headers and formulas, with the fix for each.
Xero Contacts Import Errors and How to Fix Them
How to import contacts into Xero, and why imports duplicate contacts, wipe details or mangle bank numbers, with the fix for each.
QuickBooks Bank CSV Upload Errors and How to Fix Them
Why QuickBooks rejects a bank CSV or imports it wrong: columns, date formats, amount signs, Credit/Debit headers, zeros and Mac files.
Bookkeeping Client Onboarding Checklist: What to Collect and How
Everything to collect from a new bookkeeping client, from engagement and bank accounts to customer lists and opening balances, and how to collect it cleanly.
NAP Consistency: Keep Your Name, Address and Phone the Same Everywhere
Why mismatched business listings cost local visibility, where inconsistencies come from, and how to fix them for one location or hundreds.
Google Business Profile Bulk Upload Errors and How to Fix Them
Why a Business Profile bulk upload shows errors, from daily limits and store codes to phones, websites, categories and coordinates, with Google's fix for each.
Google Business Profile Bulk Verification: Requirements and Common Delays
Who can bulk verify 10 or more locations, how to request it in Business Profile Manager, and the common reasons Google delays it.
How to Collect Location Details from Multi-Location Clients
What local SEO agencies should collect for every location, the mistakes that break bulk uploads, and how to collect it once for every listing platform.
CSV Date Formatting Guide
Learn how date formatting can cause CSV import problems and how to keep dates consistent.
How to Strip Currency Symbols from CSV Price Columns
Learn how to remove currency symbols, thousand separators, and formatting from price data to prepare it for database imports.
How to Handle Blank and Empty Cells in CSV
Learn when blank cells are acceptable, when they break imports, and how to manage missing data properly.
How to Handle Special Characters in CSV
Learn how to properly handle accents, symbols, Unicode characters, and encoding issues in CSV files.
Fix Invisible Characters Breaking Your CSV Imports
Learn how to detect and remove invisible characters like BOM, zero-width spaces, and non-breaking spaces that corrupt CSV data.
Commas Breaking Your CSV Imports? CSV Escaping Guide
When data contains commas, CSV parsing fails. Learn how CSV quoting and escaping work to handle commas in your data.
Leading Zeros Disappearing from Account IDs?
Customer IDs (00847 → 847), SKUs, and ZIP codes lose leading zeros in Excel. Learn why and how to prevent it.
How to Format Phone Numbers in CSV
Learn how to standardize phone numbers in different formats to avoid validation failures and ensure consistent data.
How to Validate URLs and Websites in CSV
Learn why website, LinkedIn and image URLs fail imports, when you need https://, and how to clean them in Excel.
How to Combine Multiple CSV Files
Learn how to merge CSV files from different sources without losing data, creating duplicates, or breaking your import.
How to Detect and Remove Duplicate Rows in CSV
Learn how to find duplicate records, why they break imports, and how to safely remove them before importing.
How to Handle Leading and Trailing Whitespace in CSV
Learn how to detect and remove invisible spaces that break validation, deduplication, and lookups.
Excel
Protection, validation, and Excel best practices
How to Convert Excel to CSV Properly Without Losing Data
Learn the correct way to convert Excel spreadsheets to CSV format without breaking dates, stripping leading zeros, or introducing encoding errors.
Excel Leading Zeros Guide
Learn why Excel removes leading zeros and how to preserve IDs, codes, and other important values.
Excel Formatting Guide
Learn how Excel formatting can affect CSV files and how to avoid common data problems.
How to Enforce Dropdowns in Excel
Learn how to use Excel Data Validation to lock down cells with dropdown lists and prevent messy, unstandardized user inputs before export.
How to Prevent Users From Modifying or Deleting Row 1 in Excel
Learn how to lock the first row in Excel so users cannot edit headers, delete rows, or break your required CSV structure.
How to Prevent Users From Adding or Deleting Columns in Excel
Learn how to lock Excel columns so clients and team members cannot alter your schema structure or disrupt backend integrations.
How to Make a Column Required in Excel
Learn how to use Excel Data Validation and custom formulas to ensure users cannot leave critical columns or mandatory fields blank before exporting to CSV.
How to Enforce a Row Limit in Excel
Learn how to use Excel Data Validation and COUNTA formulas to restrict the total number of rows users can fill out before exporting to CSV.
How to Collect Data When Clients Use Different Excel Spreadsheets
Learn how to collect consistent data when clients already use their own Excel spreadsheets, with column mapping, validation, and structured CSV exports.
How to Enforce Unique Values in an Excel Column
Learn how to use Excel Data Validation and COUNTIF formulas to prevent duplicate entries and ensure unique identifiers before exporting to CSV.
How to Stop Clients Changing Your Excel Template
Learn why clients change Excel templates, how to prevent columns being renamed or removed, and how to collect structured data without spreadsheet back-and-forth.
How to Stop Clients Sending Incomplete Excel Spreadsheets
Learn how to collect complete client data without chasing missing fields, correcting spreadsheets, or repeatedly emailing Excel files.
Why Does Excel Convert Numbers to Scientific Notation?
Learn why Excel converts large numbers to scientific notation and how to prevent problems with IDs, barcodes, and CSV files.
Need something more?
Import Builder helps you collect clean, validated data without relying on spreadsheets.
Start building free