DEV Community

#excel

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
How to Build an IT Risk Register in Excel

How to Build an IT Risk Register in Excel

Comments
7 min read
每周 15 分钟:三张表维护清单,月初记的账月底不用返工

每周 15 分钟:三张表维护清单,月初记的账月底不用返工

Comments
1 min read
How to Clean Up a Messy Spreadsheet Without Learning Excel (10-Minute Checklist)

How to Clean Up a Messy Spreadsheet Without Learning Excel (10-Minute Checklist)

Comments
3 min read
Why plugins corrupt your .xlsx files (and how to check before it happens)

Why plugins corrupt your .xlsx files (and how to check before it happens)

Comments
7 min read
How to Convert Stripe Transaction Exports into Production SQL INSERTs

How to Convert Stripe Transaction Exports into Production SQL INSERTs

Comments
5 min read
Excel for the Web: Remove Duplicates Before the PivotTable, or Your Top Customer Is Overstated by $2,310

Excel for the Web: Remove Duplicates Before the PivotTable, or Your Top Customer Is Overstated by $2,310

Comments
4 min read
Editing .xlsx files without Excel: what actually works in 2026

Editing .xlsx files without Excel: what actually works in 2026

Comments
7 min read
How to merge Shift_JIS, UTF-8 BOM, and Windows-1252 CSVs without guessing the encoding

How to merge Shift_JIS, UTF-8 BOM, and Windows-1252 CSVs without guessing the encoding

Comments
6 min read
How to convert decimal hours to hours and minutes

How to convert decimal hours to hours and minutes

Comments
6 min read
Opening an .xlsx on a machine with no Excel

Opening an .xlsx on a machine with no Excel

Comments
4 min read
Building Resilient Ingestion Pipelines for Messy Excel Payroll Exports

Building Resilient Ingestion Pipelines for Messy Excel Payroll Exports

Comments
2 min read
Automating Excel Reports with Python: A Pipeline That Survives Real Files

Automating Excel Reports with Python: A Pipeline That Survives Real Files

Comments
5 min read
How to extract tables from a PDF into Excel or CSV

How to extract tables from a PDF into Excel or CSV

Comments
4 min read
Normalizing Amazon Multi-Marketplace Settlement Files in Excel & ETL Workflows

Normalizing Amazon Multi-Marketplace Settlement Files in Excel & ETL Workflows

Comments
3 min read
Merging CSV and Excel files without breaking them: encodings, leading zeros, and header drift (.NET notes)

Merging CSV and Excel files without breaking them: encodings, leading zeros, and header drift (.NET notes)

Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.