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. 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?

    2 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      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
        I agree to the terms of service
        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
          I agree to the terms of service
          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
            I agree to the terms of service
            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
              I agree to the terms of service
              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
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                1 comment  ·  Suggestions  ·  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…

                2 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  1 comment  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
                • 1 vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    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
                      I agree to the terms of service
                      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