If a CSV total looks wrong in Excel, check whether the amount column contains text. SUM ignores t...

If a CSV total looks wrong in Excel, check whether the amount column contains text. SUM ignores t...If a CSV total looks wrong in Excel, check whether the amount column contains text. SUM ignores t...

The network for creativity

Join 1.25M professional creatives like you

Connect with clients, get discovered, and run your business 100% commission-free

Creatives on Contra have earned over $150M and we are just getting started

Back to feedPost

Jaye Nichols

• Sep 8

If a CSV total looks wrong in Excel, check whether the amount column contains text. SUM ignores text cells, even when they look like currency.

Also check the import settings before opening order IDs as numbers. An ID like 000101 can lose its leading zeros.

We put together a short guide to importing CSVs, handling dates and reconciling totals, with links to Microsoft’s documentation: https://tidemark-export-rescue.netlify.app/csv-in-excel.html

Published by Export Rescue, our CSV cleanup service.

excel

tidemark-export-rescue.netlify.app

Why your CSV totals look wrong in Excel

Check CSV amount types, preserve order IDs, choose the correct locale, and reconcile records before trusting your Excel totals.

Mohit Patil

• Nov 8

I took a raw customer orders sheet with extra spaces, mixed text cases, duplicate rows, five different date formats and inconsistent phone numbers. I cleaned it into a consistent table and flagged the missing values for follow-up instead of guessing. I used trim, proper, datevalue, substitute and Remove Duplicates.

#Excel #MicrosoftExcel #DataAnalysis #DataAnalytics #Spreadsheets #ExcelExpert #Freelance#DataCleaning #DataCleansing #DataPreparation #ExcelTips #DataQuality

Microsoft Excel Accounting Account Management

Emmanuel Barasa

• Nov 8

Hello Contra community! 👋

I'm Emmanuel, an aspiring Data Analyst passionate about turning raw data into meaningful insights.

I'm currently building my skills in:

Excel and Power BI for data visualization and reporting.

SQL for data querying and analysis.

Python (Pandas, Matplotlib and Scikit-learn) for data cleaning, analysis and machine learning.

I'm using practical projects to strengthen my skills and explore how data can help businesses make better decisions.

Looking forward to connecting, learning and collaborating with other professionals here!

Microsoft Excel SQL Python

Tiisetso Moabelo

• Nov 9

Sample project: a bills tracker I built in Excel and Google Sheets for a fictional business.

Change one date and everything updates: the row colours (green = paid, orange = due within 2 days, red = overdue), the totals, the pie chart and the payment rate.

All data is fictional.

Which would you rather see in a monthly report: the pie chart of what's still owed, or the payment rate bar? I'd love your thoughts.