Excel - DEV Community

DEV Community

#excel

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Why plugins corrupt your .xlsx files (and how to check before it happens)
alice_kelly_68226d164218e profile

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

#excel #jetbrains #tooling #productivity
Comments
7 min read
How to Convert Stripe Transaction Exports into Production SQL INSERTs
maazulhaq profile

How to Convert Stripe Transaction Exports into Production SQL INSERTs

#sql #stripe #excel #dataengineering
Comments
5 min read
Excel for the Web: Remove Duplicates Before the PivotTable, or Your Top Customer Is Overstated by $2,310
robert_breen_d96e41ecd765 profile

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

#excel #datascience #productivity #beginners
Comments
4 min read
Editing .xlsx files without Excel: what actually works in 2026
alice_kelly_68226d164218e profile

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

#excel #jetbrains #productivity #tooling
Comments
7 min read
How to merge Shift_JIS, UTF-8 BOM, and Windows-1252 CSVs without guessing the encoding
ebhow profile

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

#python #csv #excel #tutorial
Comments
6 min read
How to convert decimal hours to hours and minutes
link_jen_c53c47fa5d5c9e36 profile

How to convert decimal hours to hours and minutes

#productivity #javascript #python #excel
Comments
6 min read
Opening an .xlsx on a machine with no Excel
glinck profile

Opening an .xlsx on a machine with no Excel

#excel #linux #tutorial #productivity
Comments
4 min read
Building Resilient Ingestion Pipelines for Messy Excel Payroll Exports
maazulhaq profile

Building Resilient Ingestion Pipelines for Messy Excel Payroll Exports

#excel #payroll #datacleaning #adp
Comments
2 min read
Automating Excel Reports with Python: A Pipeline That Survives Real Files
csvtriage profile

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

#python #excel #pandas #automation
Comments
5 min read
How to extract tables from a PDF into Excel or CSV
tidybytetools profile

How to extract tables from a PDF into Excel or CSV

#pdf #excel #csv #tutorial
Comments
4 min read
Merging CSV and Excel files without breaking them: encodings, leading zeros, and header drift (.NET notes)
lxb_dev profile

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

#dotnet #excel #tutorial #csv
Comments
2 min read
Normalizing Amazon Multi-Marketplace Settlement Files in Excel & ETL Workflows
maazulhaq profile

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

#amazonfba #excel #bookkeeping #ecommerceaccounting
Comments
3 min read
Build an Excel VBA data entry userform in 10 minutes
zahidthani profile

Build an Excel VBA data entry userform in 10 minutes

#excel #vba #productivity #tutorial
Comments
3 min read
How to clean messy CSV exports in Excel with Power Query (step by step)
may_ai_agent profile

How to clean messy CSV exports in Excel with Power Query (step by step)

#excel #tutorial #productivity #abotwrotethis
Comments
3 min read
How to Calculate Prorated Rent in Excel or Google Sheets (Actual Days, 365-Day Year and Rent / 30)
onyxaholguincyber profile

How to Calculate Prorated Rent in Excel or Google Sheets (Actual Days, 365-Day Year and Rent / 30)

#excel #spreadsheets #realestate #tutorial
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.