


ReplaceQuote = Table.ReplaceValue(Source,"'","""",Replacer. Source = Csv.Document(File.Contents("C:\Test\commas.txt"), ), On first step instead of Load click transform, in formula bar modify first step of the query as import without delimiter, after that replace single quote on double one and split column with comma as delimiter. You may modify a script a bit from user interface. I don't know the way to define single quote as text qualifier. Then select comma as the delimiter and hit finish Share Improve this answer Follow answered at 20:44 Raystafarian 21.5k 11 60 90 71 And you have to do that every time after double-clicking. text like "something","company, inc",1,2,3 Go to the Data tab and select text to columns under data tools then select delimited and hit next. If import by default From Text/CSV it recognises double quote as text qualifier, i.e. On the second step of the wizard select single quote as text qualifier To switch it on File->OptionsĪnd use it from Data->Get data->Legacy wizard.

You may use legacy file import wizard which is switched off by default.
