CSV Import & Export Guide

By Online CSV Editor · Last updated: 2026-03-30

Most CSV import and export problems are not caused by the upload button. They come from messy headers, delimiter mismatches, inconsistent values, encoding drift, duplicate rows, or files that were converted without a clear schema plan. The goal of this hub is simple: make a CSV predictable before it moves.

Use this section when you are preparing a file for a CRM, ecommerce platform, reporting tool, app, or API. If the problem is more about cleanup than conversion, start from the CSV cleaning guide.

The best order for import and export prep

Open the file correctly first. Confirm delimiter, encoding, and header row before changing values.
Fix the schema next. Rename headers, remove junk columns, and preserve key fields or IDs.
Choose the right workflow. Combine rows, merge files, convert formats, or export with a new delimiter based on the actual job.
Validate the output. Spot-check records and run a small sample import or script test before using the full dataset.

What import-ready and export-ready actually mean

The file opens into the correct columns with no row drift.
Headers map cleanly to the destination fields or code-level keys.
Critical IDs, dates, and optional values follow one consistent rule.
The conversion path is explicit: combine, merge, delimiter change, CSV to JSON, or direct import.
A small real-world test confirms the destination accepts the result.

Example: taking a supplier export into an app API

Suppose you receive a supplier CSV with columns like Product Name, SKU, Price, and Updated At. Before converting that file into JSON for an internal app, you would first validate the delimiter, clean the headers, standardize dates and blanks, and confirm SKUs stay text-safe.

Open and validate the CSV structure.
Rename headers for cleaner downstream keys.
Normalize missing values and date formats.
Convert the cleaned CSV to JSON.
Test a few objects in the API or app before using the full dataset.

Core import and export guides

Convert CSV to JSON online

Turn flat CSV rows into predictable JSON objects with clean headers and intentional null handling.

Combine multiple CSV files into one

Append files safely when the schema matches and you need a single master CSV.

Merge two CSV files by common column

Join columns from different files using a stable key like email, ID, or SKU.

Change CSV delimiter safely

Switch between comma, semicolon, or tab-delimited formats without breaking quoted fields.

CSV import checklist

Run a final pre-upload QA pass for headers, delimiters, parser warnings, and destination mapping.

CSV delimiters and encoding guide

Understand region-specific separators, UTF-8, BOM, and why files open incorrectly.

How to open a CSV file correctly

Check parsing and file structure before you export, convert, or import anything downstream.

Common mistakes teams make

Converting before cleaning: format changes do not fix structural mess. They often freeze it into a new output type.

Skipping header QA: unclear headers break both import mapping and JSON key quality.

Not deciding how to handle blanks: empty cells, placeholders, and null values need one deliberate rule.

No sample test: even a technically correct file can still fail the real destination workflow.

Quick tips

Always keep the original export unchanged.
Pick one schema reference before combining or merging files.
Validate delimiter and encoding before assuming a file is broken.
Use a small sample import or API call as the final QA step.

FAQ

What should I check before importing a CSV anywhere?

Check delimiter, encoding, headers, required columns, duplicate risk, and a small sample import before uploading the full file.

What is the difference between combining and merging CSV files?

Combining means stacking rows from files that share the same schema. Merging means joining columns from different files by a shared key such as email, customer ID, or SKU.

When should I convert CSV to JSON instead of keeping CSV?

Convert to JSON when a script, app, or API needs object-based data. Keep CSV when the workflow is still centered on flat tables, spreadsheets, or bulk imports.

Canonical: https://csveditoronline.com/docs/csv-import-export-guide