Sourcetable Blog

Sourcetable is now free for students.

Sourcetable's AI spreadsheet is now free for students and faculty. We want to accelerate the adoption of AI in today's youth, and remove economic friction from their ability to experiment, learn and play.

Sourcetable in 2024.

Hello Sourcers! 2023 was a big year for Sourcetable. We built graphs, we built charts, we built pivots, conditional formatting, joins, a data library, and endless integrations to help people

funding

Sourcetable's Journey to Revolutionize Spreadsheets Just Got $4.25m Stronger!

Today, I'm excited to share that we've secured a $3m seed round led by Michael Berolzheimer at Bee Partners, in addition to $1.25m pre-seed funding from Lee Jacobs (Long Journey Ventures), Melody Koh (NextView Ventures) and Paul Bricault (AmplifyLA).

Figuring Out Your Company's Most Important Customer Demographics

What makes your business tick? If you're like most companies, your customers do! Understanding and analyzing your customer demographics can help you to optimize your marketing and sales strategies. This ensures that you're targeting the right audience, creating the right

Company Size and the Bizops role with Josh Schenker

How does the size of a company change the Business Operation (“bizops”) role? Josh Schenker, VP of Finance and Strategy at Clean.io gives us insight into this question in our most recent interview. Here are the highlights: About Clean.io Clean.io is

Bizops popularity, a discussion with Olivia Man at Loan Snap

Why are Business Operations (“BizOps”) people so popular in today’s market? What can they do for a company? How can someone get into BizOps, and what skills might they need? These are just some of the questions that Olivia Man, Chief of Financial

Bizops at Lemonade with Eliot Jenkins

Where does Business Operations (“bizops”) stand today and where is it heading? What can it do for a company? And what’s the value it could bring for yours? These are some of the questions that Eliot Jenkins, Head of Business Operations at Lemonade

How to choose a Business Intelligence tool.

Business Intelligence tools are software applications that take in large amounts of data and make it available for analysis purposes. If you're reading this post, there's a good chance that your business is growing, your current reporting systems are getting

bizops

Bizops at CoinList, an interview with Regan Bozman.

What are the typical tasks performed by business operations (“bizops”) people? How can someone get into bizops, and what skill sets might they need? These are just some of the questions that Regan Bozman [https://www.linkedin.com/in/reganbozman/], Director of Business Operations

HowTo

How to use Joins in Sourcetable

Sourcetable uses an easy interface with recommendations for joins between tables and across integrations to ensure success.

HowTo

How to use JSON data in Sourcetable

JSON files look confusing at first but once you understand their structure you can easily use the Parse formula to analyze them in Sourcetable.

Sourcetable vs Alternatives (Excel, Sheets and BI tools)

Our mission at Sourcetable is to make data accessible to everyone. To live up to this promise, we're building a next-generation of spreadsheet that is more powerful, more collaborative, and easier to use than alternatives on the market. More powerful than Excel:

bizops

The role of bizops in start-ups, with Jay Nargundkar

What is bizops? How does it best support the needs of the organization? Sourcetable sat down with Jay Nargundkar to find out.

Sourcetable

Sourcetable product update — conditional formatting, all-time data sync, and more

Hello Sourcers! Here's what we've been up to over the past couple of weeks: Conditional Formatting, All-time Data Sync, Other Exciting Updates! 1. Conditional Formatting Big fan of cohort analyses? So are we. Now you can make them shine with

Sourcetable product update

Groupby, Faster Joins, Bulk CSV import, and more Data Integrations! Hello Sourcers! We've been productive over the past couple of weeks. Here’s what we’ve released: 1. Groupby Want to find out your total orders by hour or day of the

HowTo

VLOOKUP in Sourcetable

These practical tips will give you an edge when implementing VLOOKUP.

BigData

Mason Bottle's Story

Mason Bottle needed a dashboard that synced their Shopify and advertising data automatically inside a spreadsheet. Using Sourcetable, they were able to get the live data for their business across multiple platforms and have one place to access it all.

business operations

Making an Ecommerce report: Top Products (SKUs) per Month

Running a business can be stressful and managing costs even more so. One way to help understand your business is to have a report with the top products, product SKUs, and product names, per month. Sourcetable’s online spreadsheets are a great way to easily create a report.

Dashboard

Case Study: Where's all my data?

Luv Aj needed all of their analytics and reports in one place without sacrificing complex analysis and granular details. Sourcetable was there to help.

shopify

Rachel Pohl Art's Story - a user case study

Rachel Pohl art is a fine art and apparel company that has been growing through social media and email outreach. They create athletic apparel and outdoor gear with designs from

How to use Aggregates in Sourcetable

Aggregating your data to find: AVG, COUNT, MIN, MAX, SUM Data analysis with spreadsheets relies on combining, changing, and investigating data to find useful information that can be used to make decisions. Aggregates are an important tool in your arsenal like structured referencing, or

bizops

KPI Reporting Dashboards: Are they worth it?

Are business analytics dashboards worth it? In a word: yes. As an e-commerce business, it's important to have a reporting dashboard set up to track your progress and

BigData

Spooky Data 🧪

What does the data say about this year's Halloween?

📊Introducing: Templates

This week we will be looking at the new reporting templates. Pre-made reporting templates make creating reports from your data easier than ever.

bizops

XLOOKUP in Sourcetable

A new alternative to VLOOKUP!

Subscribe to Sourcetable Blog