• Arigion@feddit.de
        link
        fedilink
        English
        arrow-up
        17
        ·
        edit-2
        8 months ago

        Which actually is better than Excel. Currently I have to work with Excel. Gosh, how bad it got. Especially CSV import and cell formating. They really worked on being incompatible to even basic data formats just to keep you in their eco system. Try to import a UTF-8 CSV where the delimiter and the number format differs from the system settings. It completely fucks up your data and you have to import it as text and then you have to format each colum separately. Because changing the format from text to number does NOT change the view. You have to update each column manually. FU MS. There are comedy videos about number formatting in Excel: https://youtu.be/yb2zkxHDfUE?si=CtYMI-5FsU2bPZUF

        • zerosignal@lemmy.world
          link
          fedilink
          English
          arrow-up
          2
          ·
          8 months ago

          Power Query might solve your problem. You can do a text to columns with as many custom delimiters as you want.

          • Arigion@feddit.de
            link
            fedilink
            English
            arrow-up
            4
            ·
            8 months ago

            Thanks for trying to help. But that’s the point. They make something which was easy deliberately overly complicated. The next step will be that they force you to discuss the csv import with ChatGPT for 5 minutes. And every time you’ll hear: well ok, this step now is more complicated, but we gave you a mighty tool which can do SO much more.