CVS File not importing properly

25 views

Skip to first unread message

vishes...@gmail.com

unread,

Oct 31, 2019, 5:55:39 AM10/31/19

to Data Illustrator

Hi there,

When I import a CSV file, data illustrater merges all columns into one long column with each heading separated by a ";". Can anyone advise how to fix this?

Regards,
Vishesh

Screen Shot 2019-10-31 at 11.53.07 AM.png

Leo Zhicheng Liu

unread,

Nov 1, 2019, 1:33:22 PM11/1/19

to Data Illustrator

Hi Vishesh,

Data Illustrator current can only read CSV files using comma as the separator between values, and does not recognize ";" as a separator. You can open your file in Excel, and save it as a CSV file using comma to separate the values.