Conditional import from txt or csv to Excel

Hello, so, I need to import data from a .txt file (might as well be a .csv) that contains: "Initial date", "Final date", "Group". In my Excel sheet I have empty date cells that must that must be wri...

excel

Formulas and Functions

Office Scripts

XXplore
Dec 27, 2022
Sounds like Power Query works:
(1) Goto Tab Data->Get Data->From File->From Text/CSV
(2) Select source file t-> "Transform Data" -> PowerQuery Editor
(3) Transform the data, e.g. "Use First Row as Headers" -> Add "Conditional Column"
(4) Edit condition, Filter By Contional Value, Apply & Close

peiyezhu

Bronze Contributor

Dec 19, 2022

the Group matches in both ends.
after import to Excel，have you tried xlook formula？

brezendelima
Copper Contributor
Dec 20, 2022
peiyezhu no, I haven't tried it, but I'll look forward to it, thank you.
- brezendelima
  Copper Contributor
  Dec 26, 2022
  I've tried the formula, unfortunately it wasn't enough to solve my problem. I'm still looking forward to it yet.
  - peiyezhu
    Bronze Contributor
    Dec 27, 2022
    import data from a .txt file (might as well be a .csv)
    
    can you share your file here?
    
    maybe another solution available

Forum Discussion

Conditional import from txt or csv to Excel

Resources