Tag feed

#excel

718 posts322 followers

Explore Hashnode

Alternatives

Trending tags this week

SSSmart SQLcomtools.hashnode.dev1d ago · 4 min read

Remove Duplicate Rows in Excel Before Importing Data (A Safer Workflow)

Duplicate records are one of the most common reasons for failed imports and inaccurate reports. Whether the data comes from CRM exports, multiple Excel files, or CSV downloads, duplicate rows eventual

0

SSSmart SQLcomtools.hashnode.dev2d ago · 4 min read

I Stopped Writing SQL INSERT Statements by Hand After This

Last week a teammate sent me an Excel file containing a little over 9,000 rows. The request sounded simple: "Can you import these users into SQL Server?" I've done this kind of work countless times,

0

SSSmart SQLcomtools.hashnode.dev3d ago · 4 min read

Excel to SQL: Generate INSERT, UPDATE, DELETE & MERGE Scripts in Seconds

If you've ever copied data from Excel into a database, you've probably experienced this: Writing hundreds of INSERT statements by hand Building complex UPDATE queries Double-checking quotes, commas

0

VYVamshi Yempallyvamshiindata.hashnode.devJun 27 · 6 min read

I Built a No-Code Email Automation Tool in Pure HTML — Here's How It Works

Send personalized bulk emails through Outlook without touching SMTP, credentials, or any third-party API. One HTML file. One Python script. Done. The Problem Every few weeks, my team needs to send p

0

UPUfumbuzi Progressive Web Appsufumbuzi.hashnode.devJun 20 · 1 min read

Generating SLK Files from Oracle to Open in Excel

A Robust Solution for Exporting Data to Excel In enterprise application development, the need to export data from Oracle databases to versatile formats such as Microsoft Excel is a common task. While

0

ASAnkur Sonijsontoexcel.hashnode.devJun 15 · 3 min read

Your JSON-to-Excel Converter Is Probably Corrupting Your Data. Here's the 30-Second Test

Last week a JSON-to-Excel tool quietly changed my data and I almost shipped it to a client. I pasted an API response into the top "JSON to Excel" tool on Google, downloaded the file, and opened it — a

0

Ccircobitgauchogrid.hashnode.devJun 12 · 5 min read

Designing Export Profiles for Different Data Workflows

A CSV is a CSV, right? Not when your user is a data analyst in Germany opening the file in Excel. Or a Python developer loading it into Pandas. Or a data engineer piping it into BigQuery. Each workflo

0

DADatadesk AUdatadeskau.hashnode.devJun 1 · 4 min read

How to Build a Clean Excel Dashboard (Step by Step)

Almost every business has the same spreadsheet somewhere: a dashboard that started clean and slowly turned into a tangle of colours, hidden tabs and formulas nobody dares touch. A good Excel dashboard

0

AVAloysius Vidhun Monaloysius05.hashnode.devMay 25 · 7 min read

How to Batch Convert Office Files to Google Docs & Sheets (Without Getting Timed Out)

If you've ever migrated an organization from Microsoft Office to Google Workspace, you know the headache of dealing with hundreds of legacy .docx, .doc, .xlsx, and .xls files. Sure, Google Drive lets

0

SSSoumyadeep Sarkarsoumyadeepbuilds.hashnode.devApr 29 · 13 min read

Automating a Twice-Daily Reporting Workflow with PowerShell, Excel VBA, Outlook, and Microsoft Teams

Daily reporting sounds simple until the same set of steps has to be repeated again and again with almost no room for mistakes. In one of my recent automation projects, the reporting process had to be

0

#excel

Search Hashnode

#excel

Explore Hashnode

Trending tags this week

Remove Duplicate Rows in Excel Before Importing Data (A Safer Workflow)

I Stopped Writing SQL INSERT Statements by Hand After This

Excel to SQL: Generate INSERT, UPDATE, DELETE & MERGE Scripts in Seconds

I Built a No-Code Email Automation Tool in Pure HTML — Here's How It Works

Generating SLK Files from Oracle to Open in Excel

Your JSON-to-Excel Converter Is Probably Corrupting Your Data. Here's the 30-Second Test

Designing Export Profiles for Different Data Workflows

How to Build a Clean Excel Dashboard (Step by Step)

How to Batch Convert Office Files to Google Docs & Sheets (Without Getting Timed Out)

Automating a Twice-Daily Reporting Workflow with PowerShell, Excel VBA, Outlook, and Microsoft Teams