Which tools do you use for CSV files?

[AndyBoolean]

Hello everyone,

I currently have more to do with SuccessFactors HCM than I would like.
Anyway, I have noticed that you have to deal with a lot of CSV files and the separators and date / time formatting is very limited.

So a CSV file from SuccessFactors HCM always uses a comma, if another separator is possible, then this is very rare.
The other is the date / time, here the system is a little more flexible but there are also components that only know MM/DD/YYYY.

Well I work in Europe and the date format MM/DD/YYYYY and the comma separator isn't common for people and MS tools here.
So MS Excel can't be used.

So I wanted to ask around, which tools do you use to edit and view these CSV files?
I explicitly do not want to use MS Excel, as this type of CSV file cannot be handled without technical knowledge

Thanks for your input 😄

Greetings
Andy

[SyWi]

We are using Excel and LibreOffice.
For Excel the computer must be setup with the language settings defined for the englisch language, this works fine.

For LibreOffice no additional changes are required and can open the files properly at any time and is respecting formatting very good.

[AndyBoolean]

When I'm in a large company, it's usually not so easy to roll out another Office suite alongside MS Office. The IT department doesn't see the added value of going to such great expense here. So the recommendation from consultants and SAP is currently not satisfactory for me as a customer.

You can do this with the country changeover in the OS if it hasn't restricted IT.
It doesn't just change MS Excel, but all applications in my OS.
I can't do that to the business.

[TT]

Hi,

You can use OpenOffice Calc, which is a free tool and works very well with CSV files.

Best regards,

[formulaire]

OK. Thank you.

[AndyBoolean]

When I'm in a large company, it's usually not so easy to roll out another Office suite alongside MS Office. The IT department doesn't see the added value of going to such great expense here.

So the recommendation from consultants and SAP is currently not satisfactory for me as a customer.

[formulaire]

Hello,

To edit and view these CSV files, we use Excel, but it's true that each time we have to juggle with the American and European formats in the odinator's configuration panel to adjust the parameters. I don't have any other solutions! But if anyone has an answer, I'd be interested too.

Bests regards.

[AndyBoolean]

Hi @formulaire,

I'm currently testing out a few tools with which I can edit CSV files without using MS Excel, OpenOffice Calc, etc...

One that I find very handy is awk(1)  it allows me to create reusable scripts for repetitive tasks.
Unfortunately it isn't necessarily suitable for someone without programming knowledge.

Best regards,
Andy