Skip to main content

CSV Files (Tools/APIs)

Work with CSV (comma-separated values) data sources.

Background Information

CSV (comma-separated values) is a simple, common format for data. For example, you can export to a .csv file from Microsoft Excel.

Available Tools


Load from CSV files into SQL tables using only InterSystems SQL. For more details, see LOAD DATA.

Record Mapper

Map CSV data into a production. For more details, see Using the Record Mapper.

Interactive CSV Import/Export

Import/export SQL data to or from a CSV file interactively by using the Management Portal. Use this option if you need to import or export data a single time. For more details, see Importing and Exporting SQL Data.

FeedbackOpens in a new tab