Skip to content
Navigation menu
Search
Powered by Algolia
Search
Log in
Create account
DEV Community
Close
#
spreadsheet
Follow
Hide
Posts
Left menu
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
How to Clean a Messy Stripe / Shopify / Gumroad CSV Before Google Sheets (or Make)
April
April
April
Follow
Oct 27
How to Clean a Messy Stripe / Shopify / Gumroad CSV Before Google Sheets (or Make)
#
csv
#
spreadsheet
#
productivity
#
solopreneur
Comments
Add Comment
4 min read
Moderation
Building a printable invoice from a table in Excel and Google Sheets (no FILTER, no macros)
Black
Black
Black
Follow
Oct 25
Building a printable invoice from a table in Excel and Google Sheets (no FILTER, no macros)
#
excel
#
spreadsheet
#
freelance
#
productivity
Comments
Add Comment
2 min read
Moderation
Track online orders and shipments in Excel: ship-by dates, status and profit per order
Ashish Srivastava
Ashish Srivastava
Ashish Srivastava
Follow
Oct 25
Track online orders and shipments in Excel: ship-by dates, status and profit per order
#
excel
#
ecommerce
#
orders
#
spreadsheet
Comments
Add Comment
3 min read
Moderation
Google Sheets vs a Real Dashboard: When It Is Time to Graduate
Linac
Linac
Linac
Follow
Oct 24
Google Sheets vs a Real Dashboard: When It Is Time to Graduate
#
analytics
#
spreadsheet
#
businessintelligence
#
dataviz
Comments
Add Comment
3 min read
Moderation
The Status Column Trap: Why Your Tracker Has 12 Statuses and Nobody Updates It
Carlos Zhou
Carlos Zhou
Carlos Zhou
Follow
Oct 16
The Status Column Trap: Why Your Tracker Has 12 Statuses and Nobody Updates It
#
spreadsheet
#
productivity
#
googlesheets
#
xlsx
1
 reaction
Comments
Add Comment
4 min read
Moderation
One Sheet vs Linked Sheets: When to Break Up a Solo-Operator Template
Carlos Zhou
Carlos Zhou
Carlos Zhou
Follow
Oct 16
One Sheet vs Linked Sheets: When to Break Up a Solo-Operator Template
#
spreadsheet
#
productivity
#
googlesheets
#
xlsx
Comments
Add Comment
4 min read
Moderation
Freeze the Schema: A Rule That Stops Shared Spreadsheet Templates From Rotting
Carlos Zhou
Carlos Zhou
Carlos Zhou
Follow
Oct 16
Freeze the Schema: A Rule That Stops Shared Spreadsheet Templates From Rotting
#
spreadsheet
#
productivity
#
xlsx
#
tutorial
1
 reaction
Comments
Add Comment
4 min read
Moderation
Design a Template People Can Fill in Under 5 Minutes
Carlos Zhou
Carlos Zhou
Carlos Zhou
Follow
Oct 15
Design a Template People Can Fill in Under 5 Minutes
#
spreadsheet
#
productivity
#
templates
#
ux
Comments
Add Comment
5 min read
Moderation
Classify spreadsheet rows with Jev, and know which answers to trust
GreenFlux
GreenFlux
GreenFlux
Follow
Oct 16
Classify spreadsheet rows with Jev, and know which answers to trust
#
jev
#
ai
#
spreadsheet
#
javascript
2
 reactions
Comments
Add Comment
1 min read
Moderation
Excel vs Google Sheets vs Notion: How I Pick a Template Format (Without Overthinking It)
Carlos Zhou
Carlos Zhou
Carlos Zhou
Follow
Oct 14
Excel vs Google Sheets vs Notion: How I Pick a Template Format (Without Overthinking It)
#
spreadsheet
#
productivity
#
msexcel
#
notetaking
Comments
Add Comment
3 min read
Moderation
The Week-2 Death of Spreadsheet Templates (And a Checklist That Keeps Yours Alive)
Carlos Zhou
Carlos Zhou
Carlos Zhou
Follow
Oct 15
The Week-2 Death of Spreadsheet Templates (And a Checklist That Keeps Yours Alive)
#
spreadsheet
#
productivity
#
excel
#
googlesheets
1
 reaction
Comments
Add Comment
5 min read
Moderation
Spreadsheet exports need formula-injection controls at the data boundary
jeffrey
jeffrey
jeffrey
Follow
Oct 29
Spreadsheet exports need formula-injection controls at the data boundary
#
csvinjection
#
spreadsheet
#
applicationsecurity
Comments
1
 comment
3 min read
Moderation
How to Build a Monthly Sales Summary with SUMIFS (No Pivot Table)
Ashish Srivastava
Ashish Srivastava
Ashish Srivastava
Follow
Oct 21
How to Build a Monthly Sales Summary with SUMIFS (No Pivot Table)
#
excel
#
spreadsheet
#
productivity
#
tutorial
Comments
Add Comment
3 min read
Moderation
How to Catch Duplicate Orders and Misspelled Customer Names in a Spreadsheet
Ashish Srivastava
Ashish Srivastava
Ashish Srivastava
Follow
Oct 21
How to Catch Duplicate Orders and Misspelled Customer Names in a Spreadsheet
#
excel
#
spreadsheet
#
productivity
#
tutorial
Comments
1
 comment
3 min read
Moderation
Etsy profit per order: a worked example and the formula (after fees, shipping and product cost)
Botgauntlet
Botgauntlet
Botgauntlet
Follow
Oct 16
Etsy profit per order: a worked example and the formula (after fees, shipping and product cost)
#
ecommerce
#
etsy
#
spreadsheet
#
finance
Comments
2
 comments
2 min read
Moderation
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account