Forum Discussion
AI to work with Excel
Hello All,
I have been trying to find an AI that can help be transform data in Excel.
The specific task at hand is to transform data from a cash register into a csv that can be directly imported into a German accounting software named DATEV. It has some specific requirements concerning amounts (no thousand separator) and a date format that is a bit odd.
So far, I just pivoted the sales transaction data into a table with 8 columns for each product category and copied them manually into a csv that can be imported with no problem. That takes about 20 minutes, checking for errors etc.
Now I just spent 90 minutes explaining the task to ChatGPT, but it kept spitting out only nonsense, completely unusable.
I could of course learn python pandas, but that would take a while.
Does anyone know an AI that can translate a fairly simple format into another fairly simple format?
Thanks.
1 Reply
There are other AI tools and approaches that may be able to better help you achieve your goal more efficiently.
I think (and this is just my humble opinion) that you can do your job better using Microsoft Power Query (built into Excel). If that's not an option for you, here are some links with more information.
OpenAI Codex (via GitHub Copilot)
Python Script with Pandas
My answers are voluntary and without guarantee!
Hope this will help you.
