Export to CSV

Export to CSV

CSV (Comma-Separated Values) is the most universal flat-file format for data exchange. Nearly every database tool, spreadsheet application, and data processing system can read CSV files, making it the safest choice when you are unsure about the recipient's capabilities.

CSV Settings

• Delimiter — The character used to separate fields in each row. MatchLogic supports four delimiter options:
  • Comma (,) — The standard CSV delimiter. Use this unless your data contains commas within field values.
  • Semicolon (;) — Common in European locales where commas are used as decimal separators.
  • Pipe (|) — A safe choice when your data contains both commas and semicolons.
  • Tab — Produces a TSV (Tab-Separated Values) file. Useful when field values contain most printable characters.
• Encoding — The character encoding for the output file. UTF-8 is the default and recommended encoding, as it supports international characters and is widely compatible.
• Header Row — When enabled, the first row of the CSV file contains column names. Disable this only if your target system expects raw data without headers.
• Table Name — The name used for the exported file. MatchLogic appends the .csv extension automatically.

Step by Step

1. In the Final Export module, select CSV as your export destination.
2. Choose your preferred delimiter from the dropdown.
3. Confirm the encoding is set to UTF-8 (or change if needed).
4. Ensure the header row checkbox is checked (recommended).
5. Enter a table name for your output file.
6. Click Preview to verify the data before exporting (see #previewing-export-data).
7. Click Export to generate the file.

After Export

Once the export job completes, a download link becomes available. Click it to save the CSV file to your computer. The file size depends on the number of records and columns included in your export.