Hi Kaye,
you are right.
But I couldn't believe Excel didn't have CSV import options like LibreOffice Calc does... So I looked better and found them!
These options are not available when opening a CSV file directly, like in LibreOffice Calc, instead you have to go through this:
- select the "Data" tab on the ribbon - select "From Text/CSV" in the "Get & Transform Data" section
Gianni
On Sat, 17 Apr 2021 10:39:00 +0000, Richard Kaye rkaye@invaluable.com wrote:
Thanks, Gianni. I can't really dictate to my customers what spreadsheet application to use.
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Gianni Turri Sent: Friday, April 16, 2021 6:30 PM To: profoxtech@leafe.com Subject: Re: Variations in CSV settings by region
Use LibreOffice Calc instead of Excel: when opening/importing a CSV or pasting text with delimited data, opens a panel with plenty of options.
Gianni