Transform Data by Example

Example-driven search engine that helps you find functions for your data wrangling task.

Project page (How-to, FAQ, Sample data, and more) | Rate us on Office Store

How can we improve Transform Data by Example?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Get Transform Data by Example addin without Office Store

    The idea is superb. But please make the Transform Data by Example add-in for Excel available for download on the Microsoft Download Center. Don't keep it only on the Office Store.

    1 vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    • 1 vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
      • Transform Data by Example not working anymore?

        I have used this add-in several times and it's extremely good, but it stopped working a week ago - it won't return any results nor throw an error. I have tried on several different computers. Is the cloud-end down?

        3 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          2 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
        • Transforming a order

          How can I transform a order in excel by only a click? For example: suppose I want to click on cell A2 then cell F12 will return to yellow color. Then I want to click on cell B15 then cell F12 will return again to green color in which cell F12 always is the constant. Nowadays, I am researching on the Symmetric Group Actions in mathematics (see www.emfps.org). What do you thing about using the new theorems in mathematics to develop some applications in excel? Can these theorems help us?

          1 vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 comments  ·  Activity Feed  ·  Flag idea as inappropriate…  ·  Admin →
          • Corporate controls for transformations

            I can think of lots of uses for this using internal data sources, but I'd like to give users a prepopulated set of transforms to use so they don't have to "discover" them. Also, we'd possibly like to minimize data leakage by blocking access to unapproved transform services.

            3 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
            • 2 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
              • Address what information is sent "over the wire" as part of this feature

                This feature appears to possibly send (or have the ability to send) protected health information (PHI) to Azure over the web. If I am using an address-related feature of Transform Data by Example, is the actual data sent over the wire, or is a computed hash of that data sent over the wire? It would be good to know what is being sent between servers. I like this plugin, but couldn't use it for some sensitive data if that data is sent out over the internet.

                3 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  1 comment  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
                • Silently Integrate with Flash Fill given certain confidence threshold

                  This is a beautiful feature! You could (a) add a HUGE value bump to Flash Fill, and hence add good value to Excel generally and (b) get this in front of WAY more users if you silently integrate this with the Flash Fill feature. Consider leaving the selection of functions to advanced users / v2 UX for flash fill and just surface these suggestions via Flash Fill when a certain confidence threshold is met. This could be a killer productivity feature for many information age workers, but this integration could be huge for getting it in front of the bulk…

                  3 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    1 comment  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
                  • Bring this out of the kitchen

                    This is a great feature - Dont let is languis in the kitchen like what you did with Fuzzy Lookup
                    https://www.microsoft.com/en-in/download/details.aspx?id=15011

                    1 vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      1 comment  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
                    • Feature Redundant

                      This feature seems redundant as there is a very powerful transform by example feature embedded in Power BI through POwerQuery. I suppose this feature will also soon be available for POwer Query in Excel

                      1 vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                      • Make it available for iPad iOS 10.3

                        I added using the store but it does not appear on add-in list

                        1 vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          1 comment  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
                        • Don't see your idea?

                        Transform Data by Example

                        Feedback and Knowledge Base