View Topic(s)

Topics

Solution marked as active
Are you sure you want to delete?
Fix when all fields of Excel get imported into the first column
Solution ID:20 Type: Solution Updated On: Jan 30, 2020 05:36 PM

If when importing files from Excel all fields are shown in the first column, this is due to Excel using the computers "Local" setting for the field sseparator during the conversion of the Excel file to a CSV (Comma Separated Value). You can revert back to the original separator after the file has been imported.


     Follow the procedure below to change the separator comma.


     1. Open the Windows Start Menu.


     2. Open "Control Panel"


     3. Open the "Regional and Language Options" dialog box.


     4. Click on the Regional Options tab.


     5. Click "Customize".


     6. Type a Comma (,) in the "List Seprator" box.


     7. Click OK twice.


If you would like to learn more about the CSV format and Excel handling of CSV files refer to
http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm



























Solution Info

Solution

358

administrator

Jan 30, 2020 05:29 PM

administrator

Jan 30, 2020 05:36 PM

Solution marked as Expired
Mark as Expired