Emacs Stack Exchange
Emacs Stack Exchange

Questions tagged [csv]

19 questions
18
votes
1 answer

Viewing & editing Excel spreadsheets and csv files in Emacs

Is there any way to view / edit Excel spreadsheets (e.g. xls and xlsx files) in Emacs? What about csv files? (e.g. column-aligning content). For reference, this is what I see when I try to open an .xlsx files in Emacs: M Filemode Length Date …
Amelio Vazquez-Reina
  • 5,157
  • 4
  • 32
  • 47
17
votes
1 answer

How to view and edit large delimiter separated value files?

I have been using csv-mode to modify small to medium sized CSV files, but recently I have been working with large files containing more than 40,812 entries. csv-mode struggles to align and navigate the tables, and is too slow to be usable as is. In…
holocronweaver
  • 1,319
  • 10
  • 22
11
votes
2 answers

Make emacs lock display of the first line of a file

How can I make Emacs always display the first line of a file which contains header information (such as a CSV) as I scroll down past where it would usually no longer be visible?
wdkrnls
  • 3,657
  • 2
  • 27
  • 46
8
votes
2 answers

How to search *just* the current line

I'm working with large, extra wide data files I probably should just be viewing in Excel... but I'd rather stay in Emacs. Is there an elisp function to search (and fontify) just on the current line?
wdkrnls
  • 3,657
  • 2
  • 27
  • 46
6
votes
2 answers

Display all/current CSV heading names

In CSV files (especially ones with a lot of columns and/or a lot of rows) I find that it's hard to tell which column I'm on. Normally I'd like to know either the column heading, or sometimes the column index (usually I want the index only if there…
Croad Langshan
  • 3,192
  • 14
  • 42
4
votes
1 answer

setq and csv-mode variables

Why can't I directly set csv-mode variables like that: (setq csv-separators '(";" "\t")) (setq csv-field-quotes '("\"" "'")) and I'm forced to set it like that: (custom-set-variables '(csv-separators '(";" "\t"))) (custom-set-variables…
P.-A.
  • 115
  • 10
3
votes
2 answers

Emacs Lisp to view text file like a table

I'd like to write a mode, or at least some Lisp functions, to view a tab-separated file like a table. What I mean is lines like this: foo\t123\tbar yabba dabba\t12345\treally long field here Should display something like: | foo | 123 | bar…
Rob N
  • 547
  • 2
  • 12
3
votes
0 answers

csv-mode is very slow

Just about any buffer with csv-mode enabled gets very slow/unresponsive, regardless of how big the file is. It takes up to half a second to jump to the next line/character. Any idea why that is? I use Spacemacs 0.200.9@24.5.1 I also had to change…
user430
  • 333
  • 2
  • 12
3
votes
1 answer

Export Org-Mode Timesheet Data?

I've taken to using org-mode for keeping track of my open tasks each week, notes on various tasks, and to generate a LaTeX formatted report at the end of each week that breaks down my time by task and subtask per day. This has all been great. I'm…
Kyle Rush
  • 75
  • 5
2
votes
2 answers

Exact steps to export to an org table to csv

Sorry if this is trivial. What are the exact step to export the following table: 1) to a buffer 2) to the file specified in properties For now if I position the cursor inside the M-x org-table-export I get a prompt for a file, not a buffer. *…
user19777
2
votes
2 answers

Creating a contact group from a local file to use with mu4e

I have a file ~/foo/contacts.csv whose first two columns look like Student ID,Student Name firstID@foo.org,"Lennon, John" secondID@foo.org,"McCartney, Paul" thirdID@foo.org,"Harrison, George" fourthID@foo.org,"Starr, Ringo" In actuality, the file…
Brian Fitzpatrick
  • 2,265
  • 1
  • 17
  • 40
1
vote
1 answer

Good mode to edit CSV files including adding and removing columns?

Looking for a mode to edit CSV files. I tried csv-mode which is great for viewing CSVs via the minor mode csv-align-mode. However I cannot find an easy way to add or delete columns in this mode. Is this possible in csv-mode or is there another mode…
halloleo
  • 1,215
  • 9
  • 23
1
vote
1 answer

csv-mode: do not split line on newline inside quoted field

I'm using the latest csv-mode in Emacs 25.3.1 in centos 6.10. The problem is that I have many fields that are long documentation strings and many of them have embedded newlines. This messed up csv-mode and causes affected rows to be split into…
David R
  • 21
  • 3
1
vote
2 answers

CSV to Markdown table

Say we have a CSV in a buffer: foo,bar,hello 1,234,95 8923,901,145 Are there any native Emacs or Markdown-mode built-ins in Emacs that can be used to convert it to a Markdown table? It looks like the syntax is quite different: | Tables | Are…
Amelio Vazquez-Reina
  • 5,157
  • 4
  • 32
  • 47
0
votes
0 answers

How can I display continuation lines only for csv-mode?

By default I have set truncate-lines to t, (do not display continuation lines), hence I want to enable it for csv-mode by default. Code section related to truncate-lines in my config file. (add-hook 'minibuffer-setup-hook (lambda () (setq…
alper
  • 1,238
  • 11
  • 30
1
2