Questions tagged [csv]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
36 views

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 '...
alper's user avatar
  • 1,340
3 votes
2 answers
294 views

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 ...
Rob N's user avatar
  • 597
0 votes
2 answers
181 views

In huge CSV files how can I easily find out in which CSV column the cursor is?

I use csv-mode with csv-align-mode to look at CSVs with header rows. For small CSVs (not many columns, not many rows) it is easy to determining in which column the current cell (i.e. the cell with the ...
halloleo's user avatar
  • 1,341
1 vote
1 answer
779 views

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 ...
halloleo's user avatar
  • 1,341
0 votes
1 answer
194 views

fixed width of column in csv mode

I plan to use csv-mode. In Excel, csv can be shown like the Picture 2. In emacs, C-c C-a yields Picture 1. Can I fix the width of the columns in csv-mode? Picture 1 Picture 2
hrkshr's user avatar
  • 143
2 votes
2 answers
1k views

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-...
user avatar
0 votes
0 answers
155 views

Use autocomplete variables from first column of a CSV file

I have used conventional auto complete feature in emacs and I think I understand how it works. I have a new requirement, where the variables to be used in a particular program (not conventional ...
Prasanna's user avatar
  • 1,540
1 vote
1 answer
225 views

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-...
David R's user avatar
  • 21
6 votes
2 answers
435 views

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 ...
Croad Langshan's user avatar
0 votes
1 answer
87 views

Insert a list of lists of strings as CSV

Given a list of lists, as returned e.g. by pcsv-parse-buffer, what's a correct way of inserting it to the buffer in CSV format ? I looked at pcsv.el and csv-mode.el but could not find a function to ...
YoungFrog's user avatar
  • 3,526
3 votes
0 answers
228 views

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 ...
user430's user avatar
  • 333
3 votes
1 answer
1k views

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 ...
Kyle Rush's user avatar
4 votes
1 answer
534 views

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-...
P.-A.'s user avatar
  • 115
2 votes
2 answers
484 views

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 [email protected],"Lennon, John" [email protected],"McCartney, Paul" [email protected],"Harrison, George" ...
Brian Fitzpatrick's user avatar
1 vote
2 answers
674 views

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 ...
Amelio Vazquez-Reina's user avatar
18 votes
1 answer
11k views

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 ....
Amelio Vazquez-Reina's user avatar
8 votes
2 answers
1k views

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's user avatar
  • 3,697
12 votes
2 answers
896 views

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's user avatar
  • 3,697
17 votes
1 answer
1k views

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 ...
holocronweaver's user avatar