Hello. I am trying to open this csv file into librecalc. I cant figure out what settings to select to make the spreadsheet open properly. If I select comma as seen in picture. It is the closest I get to it being proper but it still splits everything weird and leaves the " " around each thing . You can see the item name gets split in the middle. Any help would be appreciated (see attached picture)
Try with additional:
[x] Other: "
[x] merge Delimiters
String Delimiters: "
Instead of the screenshot, post a few lines from a text editor.
This is likely the only needed piece.
Thank you! It was this plus comma box checked