Skip to content
Navigation menu
Search
Powered by Algolia
Search
Log in
Create account
DEV Community
Close
#
excel
Follow
Hide
Posts
Left menu
👋
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
How to Build an IT Risk Register in Excel
Circuit & Capital
Circuit & Capital
Circuit & Capital
Follow
Nov 15
How to Build an IT Risk Register in Excel
#
cybersecurity
#
security
#
tutorial
#
excel
Comments
Add Comment
7 min read
Moderation
每周 15 分钟:三张表维护清单,月初记的账月底不用返工
alapha888
alapha888
alapha888
Follow
Nov 15
每周 15 分钟:三张表维护清单,月初记的账月底不用返工
#
excel
#
spreadsheet
#
smallbusiness
Comments
Add Comment
1 min read
Moderation
How to Clean Up a Messy Spreadsheet Without Learning Excel (10-Minute Checklist)
Quill Datafix
Quill Datafix
Quill Datafix
Follow
Nov 14
How to Clean Up a Messy Spreadsheet Without Learning Excel (10-Minute Checklist)
#
productivity
#
excel
#
data
#
beginners
Comments
Add Comment
3 min read
Moderation
Why plugins corrupt your .xlsx files (and how to check before it happens)
alice kelly
alice kelly
alice kelly
Follow
Nov 14
Why plugins corrupt your .xlsx files (and how to check before it happens)
#
excel
#
jetbrains
#
tooling
#
productivity
Comments
Add Comment
7 min read
Moderation
How to Convert Stripe Transaction Exports into Production SQL INSERTs
M Maaz Ul Haq
M Maaz Ul Haq
M Maaz Ul Haq
Follow
for
DataSort
Nov 13
How to Convert Stripe Transaction Exports into Production SQL INSERTs
#
sql
#
stripe
#
excel
#
dataengineering
Comments
Add Comment
5 min read
Moderation
Excel for the Web: Remove Duplicates Before the PivotTable, or Your Top Customer Is Overstated by $2,310
Robert Breen
Robert Breen
Robert Breen
Follow
Nov 13
Excel for the Web: Remove Duplicates Before the PivotTable, or Your Top Customer Is Overstated by $2,310
#
excel
#
datascience
#
productivity
#
beginners
Comments
Add Comment
4 min read
Moderation
Editing .xlsx files without Excel: what actually works in 2026
alice kelly
alice kelly
alice kelly
Follow
Nov 13
Editing .xlsx files without Excel: what actually works in 2026
#
excel
#
jetbrains
#
productivity
#
tooling
Comments
Add Comment
7 min read
Moderation
How to merge Shift_JIS, UTF-8 BOM, and Windows-1252 CSVs without guessing the encoding
ebhow
ebhow
ebhow
Follow
Nov 12
How to merge Shift_JIS, UTF-8 BOM, and Windows-1252 CSVs without guessing the encoding
#
python
#
csv
#
excel
#
tutorial
Comments
Add Comment
6 min read
Moderation
How to convert decimal hours to hours and minutes
Link Jen
Link Jen
Link Jen
Follow
Nov 11
How to convert decimal hours to hours and minutes
#
productivity
#
javascript
#
python
#
excel
Comments
Add Comment
6 min read
Moderation
Opening an .xlsx on a machine with no Excel
Anuj Kabra
Anuj Kabra
Anuj Kabra
Follow
Nov 11
Opening an .xlsx on a machine with no Excel
#
excel
#
linux
#
tutorial
#
productivity
Comments
Add Comment
4 min read
Moderation
Building Resilient Ingestion Pipelines for Messy Excel Payroll Exports
M Maaz Ul Haq
M Maaz Ul Haq
M Maaz Ul Haq
Follow
for
DataSort
Nov 11
Building Resilient Ingestion Pipelines for Messy Excel Payroll Exports
#
excel
#
payroll
#
datacleaning
#
adp
Comments
Add Comment
2 min read
Moderation
Automating Excel Reports with Python: A Pipeline That Survives Real Files
Lv Shao Mu
Lv Shao Mu
Lv Shao Mu
Follow
Nov 11
Automating Excel Reports with Python: A Pipeline That Survives Real Files
#
python
#
excel
#
pandas
#
automation
Comments
Add Comment
5 min read
Moderation
How to extract tables from a PDF into Excel or CSV
Tidy Byte Tools
Tidy Byte Tools
Tidy Byte Tools
Follow
Nov 11
How to extract tables from a PDF into Excel or CSV
#
pdf
#
excel
#
csv
#
tutorial
Comments
Add Comment
4 min read
Moderation
Normalizing Amazon Multi-Marketplace Settlement Files in Excel & ETL Workflows
M Maaz Ul Haq
M Maaz Ul Haq
M Maaz Ul Haq
Follow
for
DataSort
Nov 10
Normalizing Amazon Multi-Marketplace Settlement Files in Excel & ETL Workflows
#
amazonfba
#
excel
#
bookkeeping
#
ecommerceaccounting
Comments
Add Comment
3 min read
Moderation
Merging CSV and Excel files without breaking them: encodings, leading zeros, and header drift (.NET notes)
lxb dev
lxb dev
lxb dev
Follow
Nov 10
Merging CSV and Excel files without breaking them: encodings, leading zeros, and header drift (.NET notes)
#
dotnet
#
excel
#
tutorial
#
csv
Comments
Add Comment
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