View semicolon-separated .csv files in gnumeric
I have a semicolon-separated csv file over here, and I would like to be able to look at it with gnumeric. Sadly, gnumeric does not read the semicolon as a separator.
I have tried:
- appending
sep=;on the first line - clicking through the GUI menus
- using sed to replace the semicolons with commas (sadly, that leads to breakage, since by document occasionally uses commas within cells
What else can I do?
Solution
In recent versions of gnumeric a new Import Data tool is available. To launch the tool choose Data|Import Data|Import Text File... from the menu.
- In the
Import Data Filedialog choose your file and hitOpen. - In the next screen select
Separatedformat and clickForward - In the following screen select a separator from a number of available options and click
Forwardonce again to choose the columns to import. - Click
Finishto complete.
- Python: get the names of specific file types in a given folder
- readr has no reasons to say there are less columns than expected
- Write CSV file with double quotes for particular column not working
- How to pretty-print / view tabular file (e.g., CSV) from the command line?
- How can I read a csv file and pass the values to a List<String> in flutter?
- "extra data after last expected column" while trying to import a csv file into postgresql
- Count the number of rows for each csv, faster code
- Among many subfolders, find CSVs starting with a given string and within ZIPs or not, and merge them while adding their names in a new column with R
- How to get rid of "Unnamed: 0" column in a pandas DataFrame read in from CSV file?
- Dowload public Google Spreadsheet
- Retrieving repeated records from a CSV using the Java Stream API
- How to convert array of ActiveRecord models to CSV?
- How to properly escape a double quote in CSV?
- How to get affected row count on WordPress query?
- How can I clean a year column with messy values?
- How can I extract specific values from a .csv-File and add them into a specific cell in a pre-exisiting dataframe/tibble in R automatically?
- add data to specific row and colum in csv python
- How can I output MySQL query results in CSV format?
- How to save values to a CSV file in exponent in python
- Parsing csv file to NSMutableArray
- Is there a way to read CSV in node.js synchronously?
- Python FastAPI: How to return a Response with Unicode or non-ASCII characters encoded into JSON or CSV data?
- Zip list of files python
- What's the most robust way to efficiently parse CSV using awk?
- Having an issue displaying a part of a string read in from a csv file
- How to scrape a csv table contained within a JavaScript button using Python?
- How to join two large CSV files?
- efficient way to join 65,000 .csv files
- Merging multiple csv files in java
- join two csv files with key value