THE SPENDIXAI JOURNAL

Make room for
better money habits.

Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.

READ. UNDERSTAND. PUT IT INTO PRACTICE.Original guides · SpendixAI Editorial

Find your next good read.

Small decisions. Clearer thinking. A useful place to start.

Clear

599 guides · Page 21 of 50

Take your time. Find what helps.
Editorial illustration for Return "Uncategorised" instead of #N/A in a lookup formula
Spreadsheets 3 min read

Return "Uncategorised" instead of #N/A in a lookup formula

Return Uncategorised instead of #N/A in a lookup: when IFNA is safer than IFERROR, and how to filter the leftover rows for a quick review.

Read article
Editorial illustration for IFS vs nested IF for categorising expenses
Spreadsheets 4 min read

IFS vs nested IF for categorising expenses

Write the same expense categorising logic with nested IF, IFS and SWITCH, compare readability and what happens on no match, and when to use a lookup.

Read article
Editorial illustration for IF formula to choose IGST or CGST+SGST by state in Excel
Spreadsheets 4 min read

IF formula to choose IGST or CGST+SGST by state in Excel

Use an IF formula in Excel to compare the seller's state with the place of supply and fill either CGST and SGST or IGST, with a state dropdown list.

Read article
Editorial illustration for Import a bank statement CSV into Google Sheets with dates intact
Spreadsheets 4 min read

Import a bank statement CSV into Google Sheets with dates intact

Import a bank statement CSV into Google Sheets with the right locale and separator so dates such as 05/01 are read correctly, with a before and after.

Read article
Editorial illustration for Import a CSV bank statement into Google Sheets and clean it up
Spreadsheets 4 min read

Import a CSV bank statement into Google Sheets and clean it up

Import a CSV bank statement into Google Sheets: the File, Import options, a locale check for dates, and first clean-up formulas for text amounts.

Read article
Editorial illustration for Importing an old expense sheet: prepare the columns for CSV
Spreadsheets 4 min read

Importing an old expense sheet: prepare the columns for CSV

Prepare an old expense sheet for CSV import: the minimum clean layout, plus fixes for merged cells, subtotal rows and amounts stored as text before export.

Read article
Editorial illustration for Import a statement CSV with Data > From Text/CSV, step by step
Spreadsheets 4 min read

Import a statement CSV with Data > From Text/CSV, step by step

Import a bank statement CSV into Excel with Data > From Text/CSV, so narration commas, long references and dates load correctly, step by step.

Read article
Editorial illustration for IMPORTDATA: load a CSV from a link into Google Sheets
Spreadsheets 4 min read

IMPORTDATA: load a CSV from a link into Google Sheets

Use IMPORTDATA to load a public CSV or TSV link into Google Sheets, learn how often it refreshes, and see why it cannot read a bank statement behind a login.

Read article
Editorial illustration for IMPORTHTML: pull a table from a web page into your budget sheet
Spreadsheets 4 min read

IMPORTHTML: pull a table from a web page into your budget sheet

Use IMPORTHTML in Google Sheets to pull a public table into a helper tab with the index argument, and see why it returns empty or breaks when a page changes.

Read article
Editorial illustration for Combine two people's expense sheets with IMPORTRANGE
Spreadsheets 3 min read

Combine two people's expense sheets with IMPORTRANGE

Combine two people's expense sheets into one summary with IMPORTRANGE in Google Sheets, handle the permission prompt and total by category with QUERY.

Read article
Editorial illustration for IMPORTRANGE #REF!: 'you need to connect these sheets' explained
Spreadsheets 4 min read

IMPORTRANGE #REF!: 'you need to connect these sheets' explained

Fix IMPORTRANGE #REF! and the 'you need to connect these sheets' message with the Allow access button, a range check and a three-step test.

Read article
Editorial illustration for IMPS narration: extract the beneficiary and mode in Excel
Spreadsheets 4 min read

IMPS narration: extract the beneficiary and mode in Excel

Split an IMPS narration into mode, reference and beneficiary in Excel, add a Mode column with SEARCH, and total spending by mode with a pivot.

Read article