Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Will the import process work correctly if text fields within the worksheet contain commas since the file is being saved as a CSV (comma delimited) file type?

April 26, 2017Commas contain correctly Fields file import process text worksheet

0

Posted

Will the import process work correctly if text fields within the worksheet contain commas since the file is being saved as a CSV (comma delimited) file type?

1 Answer

0

Posted

A – Yes. Excel accounts for this possibility and encases text strings with double quotes. This tells the import routine to ignore any commas within the quotes.