Can I batch Import .txt files into numbers and .csv files on Mac?

macos tips
1

I have a number of text files that I need to convert to CSV files.
How can I realize this?

2

If your .txt files are structured like CSVs (e.g., tab- or comma-separated values), you can batch convert them to .csv using the Terminal:

  1. Open Terminal.
  2. Navigate to the directory with your .txt files: cd /path/to/your/txt/files
  3. Run this command to convert all .txt files to .csv: for file in *.txt; do cp “$file” “${file%.txt}.csv”; done

This simply renames them as .csv if they are already in a compatible format.

3

Numbers does not support true batch import into a single spreadsheet. You’ll need to copy-paste data manually if you want everything consolidated into one sheet.