View Single Post
Old 01-03-2018, 09:44 AM
ekoranyi ekoranyi is offline
VanDyke Technical Support
Join Date: Jan 2017
Posts: 654
Hi iveybilly,

It looks like there may be a little confusion about creating CSV files in Excel vs a text editor like Notepad.

Excel will automatically add the required "," between each cell. Therefore each field will go in a different column without requiring a "," be entered.

If you are using a text editor, that's less sophisticated than Excel, you will need to manually enter the "," to separate the data.

Both of these images are the same file opened with a different application. It looks like it's just a matter of Excel doing some of the work for you.

Does using Excel and modifying your CSV to have only one field in each column change the behavior you see?
Attached Images
File Type: png ExcelCSVExample.png (3.9 KB, 2066 views)
File Type: png TextEditorCSVExample.png (5.4 KB, 2023 views)

VanDyke Software
Technical Support
(505) 332-5730
Reply With Quote