How to turn a spreadsheet into web application in minutes
We live in a world exploding with data. But what can you do with that data besides accumulating it? With Polymer Search, you can transform your data-filled spreadsheets into a highly interactive web application in minutes.
Polymer Search is an AI-powered tool that'll convert any spreadsheet into a beautiful, interactive web application in minutes! No download required, no time wasted.
You can share the web application via a URL (known as a Polymer Site), or embed the app on your website!
There are sample datasets for you to try so you can explore the possibilities of Polymer Search. Take a look at whichever type of data set are most similar to your own.
If you’re ready to learn about your own spreadsheet data, you can move on to step two.
Step 2: Upload & convert your spreadsheet into a web app
Polymer supports Excel files like .csv and .xlsx, but if you want to connect your Google Sheets or Airtable, that's also possible. To upload your file, drag it here:
Using the power of AI, Polymer Search will encrypt and analyze your data, transforming it into a beautiful web app that is not only visually appealing, but contains many features such as data analysis tools and visualization!
Step 3: Launch Polymer Site
On the right hand side, click "Open Polymer App" and this should launch your web application!
Choosing Your Layout
Immediately after starting up your Polymer Site, you'll be prompted with this screen:
You can change these in the settings at any time, so don't worry about picking the wrong answer, but here's an explanation of what they mean:
Search and present data: Tick this option if you want to present data.
Find AI-driven Inisights: Tick this if you want to analyze data. You can tick both of these if you want.
To Make Excel Look Like a Web Application, Choose "Grid View"
There you'll be presented with a tool called "Smart Pivot" which is basically a much easier to use and interactive pivot table.
Otherwise in terms of design, "gallery view" looks the best but requires the most effort to set up. In order to make the most out of gallery view, you'll need images for each entry (like FlixGem) and they need to be of the same size.
Cards view is good when you don't have images of the same size. You can change these settings any time by clicking this icon:
Sharing and Embedding
To share or embed a Polymer Site, you'll need to first make it public by going to "Share" (at the top right corner) > Public > Embed Code
Paste the embed code on a blank HTML page.
Alternatively you can copy the direct link to the Polymer App and send that link to other people so they can view it!
Further Customization:
This step can be pretty important, so don't skip it. To open settings, click on the cogwheel icon:
The first thing you want to customize are the "Column Settings." This will modify the settings for each individual column e.g. Age, First Name, Last Name.
Make sure the "Data Type" is set to the correct settings. E.g. Age should be a number:
"String" just means text like "First Name."
If you choose "Image" it'll automatically display images from a URL in the spreadsheet
URL becomes a link
Also you can separate a column into multiple columns by choosing the 'custom separator.'
For example, if a column says "Daniel, Alex, Tim" and you choose "comma" as the separator, it'll separate all those names into different columns.
And that’s it! Within minutes you will have an interactive web application that will deeply analyze your data to provide valuable insights and display it in visually appealing ways that are perfect for presentations.