What's new in Polymer: Mar 29, 2023
Secondary axes, Google Ads connector improvements, & more
Excel is a great tool for storing/editing data, but let’s be real: the interface is very plain and can be counter-intuitive. Here's how you can fix that in a matter of minutes!
There are several ways to design your Excel spreadsheets to look prettier, but those options are quite limited and can be time consuming. I'm going to show you a better way.
We'll be using a tool called Polymer Search to transform your boring Excel dataset into a beautiful, interactive aesthetic spreadsheet in 30 seconds! Here's a sneak peak of what it'll look like:
There’s 3 main important reasons why you want to make your spreadsheets look good:
Data fatigue is a common issue for spreadsheet users and even expert data analysts. People who use Polymer Search report less data fatigue and more productivity!
Separating columns by colors and tags also makes data easier to read.
Here's how to make spreadsheets look professional in a way that's impossible to do on Excel itself:
Since the basic design looks very clean, you won't have to do much customization (if any), but the option is there if you want to go for a certain look or feel.
There are also several in-built tools for data analysis: namely the pivot table feature and auto-explainer feature which uses AI to help you interpret your data. There's also a visualization feature to create bar charts, scatterplots, heatmaps and time series. Feel free to try these out!
You can customize your layout by pressing this icon:
There are 3 layouts to choose from:
Grid view is basically an Excel spreadsheet, but with better design, interactivity and easier navigation.
This is the main layout used for analyzing data. The other 2 layouts don't have the in-built pivot table feature called ‘smart pivot.’
Card view organizes your data into rows. You can customize which tags are showing and can include an image for each row.
Gallery view organizes your data into rows and columns and allows you to include an image for each of them. This essentially turns your Excel spreadsheet into an application. Examples of this:
This one can be the most beautiful to use, but setting it up can also be the most time consuming. Gallery view is best used when you have image data, but it's possible to use it with no images too. Here's what that'll look like:
To add images: you'll need to create a separate column in your Excel file and include a URL link to the image.
The default Polymer Search color scheme already looks 10x better than Excel, but if you want to have your own custom colors, you can do so by going into settings -> advanced.
There you can change:
Also, don't forget the sidebar does exist and is an extremely useful tool for filtering data:
See for yourself how fast and easy it is to create visualizations, build dashboards, and unmask valuable insights in your data.
Start for free