--- title: "How CSV import works" slug: "how-csv-import-works" description: "Learn about the Zilliant-developed CSV Import component that enables you to import a CSV file into SQL Server. " updated: 2024-01-02T16:03:12Z published: 2024-01-02T16:03:12Z canonical: "docs.zilliant.com/how-csv-import-works" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.zilliant.com/llms.txt > Use this file to discover all available pages before exploring further. # How CSV import works The **CSV Import** component enables you to flexibly import any comma-separated values (CSV) file into SQL Server. You can also define a job workflow to import CSV data into a Salesforce object. The Zilliant-developed **CSV Import** component is a platform-level component that you can use with all Zilliant products. It allows you to import a CSV file in any regional format, without the dependency on a Salesforce user locale. In the CSV file, you can select a preferred column separator, decimal separator, and date format, as well as map file columns to logical entity columns. Note - You can run **New Import** only if you drop the **CSV Import** component onto a Lightning record page. - You can view the import history only if you drop the **CSV Import** component on an app page. - CSV import runs through the **Upsert** method, which updates existing data and inserts new data. Use the following procedures to set up and configure a CSV import: - [Configure a CSV import component](/v1/docs/configure-csv-import-component) - [Configure the post-processing of lines](/v1/docs/configure-post-processing-of-lines) - (Optional.) [Configure a custom Apex hook for the post-processing of lines](/v1/docs/csvimportpostprocessordata) Once you have configured a **CSV Import** component, you can follow these steps to [import the lines](/v1/docs/import-lines-from-file).