Navigation:  How do I ...? > Data Files >

How do I open a CSV (comma-separated values) file?

Print this Topic Previous pageReturn to chapter overviewNext page

If your files are XY data with X values in the first column and all subsequent columns being Y values for separate curves, you can drag-and-drop your CSV files onto DPlot or use Explorers “Open with…” right-click command and DPlot will correctly interpret them, including (if present) titles and axis labels (for a single curve) or legend entries for multiple curves. CSV files may also be opened with the File>Open menu command, of course (select the “D Multiple columns (2D)” file type).

For more information on DPlots support of CSV files, see the Help topic for Multiple columns files.

DPlot includes support for 3D (X,Y,Z) data (“K 3D X,Y,Z columns”) and for both 2D and 3D data allows you to specify which columns to plot, which column is X, or to specify that the data is alternating X,Y columns rather than X,Y,Y,Y. "CSV" is actually a bit misleading in this case, as DPlot will also allow tab- or space-separated columns.

DPlot will also allow you to save your data to a CSV file that can be read directly by Microsoft Excel.

Labels

For X,Y data files containing 3 (and only 3) columns or for 3D data files containing 4 columns, you may specify that the last column contains point labels by selecting the "Pick Columns to Plot" checkbox on the Open dialog. For example this data:

 

0.0, 0.000000000,"X=$X, Y=$Y"

0.1, 0.309016994,

0.2, 0.587785252,

0.3, 0.809016994,

0.4, 0.951056516,

0.5, 1.000000000,"X=$X, Y=$Y"

0.6, 0.951056516,

0.7, 0.809016994,

0.8, 0.587785252,

0.9, 0.309016994,

1.0, 0.000000000,"X=$X, Y=$Y"

1.1,-0.309016994,

1.2,-0.587785252,

1.3,-0.809016994,

1.4,-0.951056516,

1.5,-1.000000000,"X=$X, Y=$Y"

1.6,-0.951056516,

1.7,-0.809016994,

1.8,-0.587785252,

1.9,-0.309016994,

2.0, 0.000000000,"X=$X, Y=$Y"

will produce this plot:

 

 


Page url: https://www.dplot.com/help/index.htm?how_open_csv.htm