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 DATA SQL command

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